Course Overview
• Build databases from
scratch or from templates
• Exchange data with other databases and Office documents
• Create forms to simplify data entry
• Use filters and queries to find and analyze information
• Design rich reports that help make your data meaningful
• Help prevent data corruption and unauthorized access
Your all-in-one learning experience includes:
• Files for building skills and practicing the book’s lessons
• Fully searchable eBook
• Bonus quick reference to the Ribbon, the new Microsoft Office
interface
• Windows Vista Product Guide eReference—plus other resources on CD
Target Audience
Beg/Int
Microsoft Press Book Details
384
pages, 1 companion CD
Course Outline
1 Exploring Access 2007
Working in Access 2007
Understanding Database Concepts
Opening an Existing Database
• Sidebar: Enabling Macros and Other Database Content
Exploring Tables
Exploring Queries
Exploring Forms
Exploring Reports
Exploring Other Access Objects
Previewing and Printing Access Objects
Key Points
2 Creating a Database
Creating a Database from a Template
Creating a Table Manually
Creating a Table from a Template
Manipulating Table Columns and Rows
Key Points
3 Populating a Database
Importing Information from Another Access Database
• Sidebar: Migrating a Database from a Previous Version of
Access
Importing Information from an Excel Worksheet
• Sidebar: Linking to Information
Importing or Linking to a SharePoint List
Collecting Data Through E-Mail
Importing Information from a Text File
• Sidebar: Importing Information from Other Sources
Importing Information from an XML File
Importing Information from an HTML File
Importing Information from an Outlook Folder
Importing Information from a dBASE File
Key Points
4 Sharing and Reusing
Information
Exporting Information to Another Access Database
Exporting Information to Excel
Exporting Information to a SharePoint List
Exporting Information to Word
• Sidebar: Exporting Information to PDF and XPS Files
Exporting Information to a Text File
Exporting Information to an XML File
Exporting Information to an HTML File
Copying Information to Other Office Programs
Key Points
5 Simplifying Data Entry by Using Forms
Creating a Form by Using the Form Tool
• Sidebar: Relationships
Refining Form Properties
Changing the Arrangement of a Form
Adding Controls to a Form
Entering Data in a Form by Using VBA
Creating a Form by Using an AutoForm
• Sidebar: Simultaneously Creating Forms and Subforms
Adding a Subform to a Form
Key Points
6 Locating Specific Information
Sorting Information in a Table
• Sidebar: How Access Sorts
Filtering Information in a Table
• Sidebar: Wildcards
• Sidebar: Expressions
Filtering Information by Using a Form
Locating Information That Matches Multiple Criteria
Creating a Query Manually
• Sidebar: Filters and Sorts vs. Queries
• Sidebar: Expression Builder
Creating a Query by Using a Wizard
Performing Calculations by Using a Query
Key Points
7 Keeping Your Information
Accurate
Restricting the Type of Data in a Field
Restricting the Amount of Data in a Field
Specifying the Format of Data in a Field
Restricting Data by Using Validation Rules
Creating a Simple Lookup List
Creating a Multi-Column Lookup List
Updating Information in a Table
Deleting Information from a Table
Preventing Database Problems
Key Points
8 Working with Reports
• Sidebar: Forms vs. Reports
Creating a Report by Using a Wizard
Modifying Report Design
Creating a Report Manually
Modifying Report Content
Adding a Subreport to a Report
Previewing and Printing a Report
Key Points
9 Making Your Database Easy
to Use
Creating a Switchboard
Creating Custom Categories
Controlling the Features Available to Database Users
Making Favorite Access Commands Quickly Available
Key Points
10 Securing and Sharing
Information
Assigning a Password to a Database
• Sidebar: Creating a Secure Password
• Sidebar: Database Encrypting
Preventing Changes to Database Code
Securing a Database for Distribution
• Sidebar: Collaborating Through SharePoint