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
- SPECIAL OFFER: Upgrade this ebook with O’Reilly
- 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
- SPECIAL OFFER: Upgrade this ebook with O’Reilly
- 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 Access 2013 Plain & Simple
Learn the simplest ways to get things done with Microsoft Access 2013 Get the full-color, visual …
book
Access® 2010 Bible
The expert guidance you need to get the most out of Access 2010 Get the Access …
book
Access 2016 Bible
Master database creation and management Access 2016 Bible is your, comprehensive reference to the world's most …
book
A Programmer's Introduction to Visual Basic® .NET
A Programmer's Introduction to Visual Basic .NET helps current Visual Basic developers identify and understand some …