Microsoft Office Access 2007 Step by Step
3 day Instructor-Led Course (24 hours)
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
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
|
