Book description
You’re beyond the basics, so dive right in and really put
your database skills to work! This supremely organized reference is
packed with hundreds of timesaving solutions, troubleshooting tips,
and workarounds. It’s all muscle and no fluff. Discover how
the experts tackle Access 2007—and challenge yourself to new
levels of mastery!
Create tables that support your database design strategy
Import and link to data from spreadsheets, text files, databases, and other ODBC data sources
Build simple to complex queries to manipulate data
Learn advanced techniques for building and customizing user interface forms
Design attractive reports to calculate and analyze large sets of data
Automate your application with Microsoft Visual Basic(R) for Applications
Customize the Office Fluent Ribbon
Explore using XML and Windows(R) SharePoint(R) Services to create Web-based applications
CD includes:
Fully searchable eBook—plus bonus chapters
Sample database applications—including query, form, and report examples
Articles from the experts: designing databases, understanding SQL, exporting data, and more
Links to demos, blogs, and user communities
References for finding Access 2003 commands in Access 2007
Windows Vista(R) Product Guide eReference and other eBooks
For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.
Table of contents
- Microsoft Office® Access 2007 Inside Out
- A Note Regarding Supplemental Files
- Acknowledgments
- About the CD
- Conventions and Features Used in This Book
- Introduction
-
1. Understanding Microsoft Access
- 1. What Is Microsoft Access?
-
2. Exploring the New Look of Access 2007
- Opening Access for the First Time
- Getting Started—A New Look for Access
- Understanding Content Security
- Understanding the New Ribbon Feature
- Understanding the New Navigation Pane
- Using the Single-Document vs. Multiple-Document Interface
- Modifying Global Settings via the Access Options Dialog Box
- 3. Microsoft Office Access 2007 Overview
-
2. Building an Access 2007 Desktop Application
-
4. Creating Your Database and Tables
- Creating a New Database
- Creating Your First Simple Table by Entering Data
- Creating a Table Using a Table Template
- Creating a Table in Design View
- Defining Fields
- Defining a Primary Key
- Defining a Table Validation Rule
- Understanding Other Table Properties
- Defining Relationships
- Adding Indexes
- Setting Table Design Options
- Creating a Default Template for New Databases
- Printing a Table Definition
- Database Limitations
-
5. Modifying Your Table Design
- Before You Get Started
- Deleting Tables
- Renaming Tables
- Changing Field Names
- Moving Fields
- Inserting Fields
- Copying Fields
- Deleting Fields
- Changing Data Attributes
- Reversing Changes
- Using the Table Analyzer Wizard
- Taking a Look at Lookup Properties
- Working with Multi-Value Lookup Fields
- Changing the Primary Key
- Compacting Your Database
- 6. Importing and Linking Data
- 7. Creating and Working with Simple Queries
- 8. Building Complex Queries
- 9. Modifying Data with Action Queries
-
4. Creating Your Database and Tables
-
3. Creating Forms and Reports in a Desktop Application
-
10. Using Forms
- Uses of Forms
- A Tour of Forms
- Moving Around on Forms and Working with Data
- Adding Records and Changing Data
- Searching for and Sorting Data
- Printing Forms
-
11. Building a Form
- Forms and Object-Oriented Programming
- Starting from Scratch—A Simple Input Form
- Working with Quick Create Commands and the Form Wizard
- Simplifying Data Input with a Form
- 12. Customizing a Form
- 13. Advanced Form Design
- 14. Using Reports
- 15. Constructing a Report
- 16. Advanced Report Design
-
10. Using Forms
-
4. Automating an Access Application
- 17. Understanding Event Processing
-
18. Automating Your Application with Macros
- Uses of Macros
- The Macro Design Facility—An Overview
- Defining Multiple Actions
- Grouping Macros
- Understanding Conditional Expressions
- Using Embedded Macros
- Using Temporary Variables
- Trapping Errors in Macros
- Understanding Macro Actions That Are Not Trusted
- Making Your Application Come Alive with Macros
- Converting Your Macros to Visual Basic
-
19. Understanding Visual Basic Fundamentals
- The Visual Basic Development Environment
- Variables and Constants
- Declaring Constants and Variables
- Collections, Objects, Properties, and Methods
- Functions and Subroutines
- Understanding Class Modules
- Controlling the Flow of Statements
- Running Macro Actions and Menu Commands
- Trapping Errors
- Some Complex Visual Basic Examples
- 20. Automating Your Application with Visual Basic
-
5. Linking Access and the Web
- 21. Publishing Data on the Web
-
22. Working with Windows SharePoint Services
- Working Within the Windows SharePoint Services User Interface
- Using Windows SharePoint Services from Access
- Migrating an Access Database to a Windows SharePoint Services Site
- 23. Using XML
-
6. After Completing Your Application
- 24. The Finishing Touches
- 25. Distributing Your Application
- A. Installing Your Software
- B. Index to Troubleshooting Topics
- C. About the Authors
- D. Choose the Right Book for You
- Index
- About the Authors
- Copyright
Product information
- Title: Microsoft Office® Access 2007 Inside Out
- Author(s):
- Release date: April 2007
- Publisher(s): Microsoft Press
- ISBN: 9780735623255
You might also like
book
Microsoft® Office Access 2003 Inside Out
Take your database expertise to the next level! This supremely organized reference packs hundreds of timesaving …
book
Microsoft® Office Access™ 2007 Step by Step
Experience learning made easy—and quickly teach yourself how to build database solutions with Access 2007. With …
book
Microsoft® Office Access 2007 on Demand
Microsoft Office Access 2007 For those who would rather be shown how than told how See …
book
RibbonX: Customizing the Office 2007 Ribbon
As the most radical change to the Office interface in its history, the Ribbon replaces the …