|
| |
Microsoft Access 2007 Outlines
Access 2007 New Features
Access 2007 Introduction
Access 2007 Intermediate
Classes are available in Microsoft Office 97, 2000, 2002,
2003, and 2007.
Class Length: 3-hours
Lesson 1: Exploring the Access Environment
- Explore the User Interface
- Work with the Ribbon
- Work with Contextual Tabs
- Customize the Access Environment
Lesson 2: Creating Tables and Forms
- Create a Table
- Create a Form
- Design a Form Layout
Lesson 3: Creating Queries and Reports
- Query a Database
- Generate Reports
- Format a Report
Lesson 4: Working with External Data
Class Length: 6-hours
Lesson 1: Exploring the Access Environment
- Examine Database Concepts
- Explore the User Interface
- Explore the Ribbon
- Customize the Access Environment
- Obtain Help
- Use an Existing Access Database
Lesson 2: Designing a Database
- Describe the Relational Database Design Process
- Define Database Purpose
- Review Existing Data
- Determine Fields
- Group Fields into Tables
- Normalize Data
- Designate Primary and Foreign Keys
- Determine Table Relationships
Lesson 3: Building a Database
- Create a New Database
- Create a Table
- Manage Tables
- Create a Table Relationship
Lesson 4: Managing Data in a Table
- Modify Table Data
- Sort Records
- Work with Subdatasheets
Lesson 5: Querying a Database
- Filter Records
- Create a Query
- Add Criteria to a Query
- Add a Calculated Field to a Query
- Perform Calculations on a Record Grouping
Lesson 6: Designing Forms
- View Data Using an Access Form
- Create a Form
- Create a Form Using the Form Wizard
- Modify the Design of a Form
Lesson 7: Generating Reports
- View an Access Report
- Create a Report
- Create a Report Using the Report Wizard
- Add a Custom Calculated Field to a Report
- Format the Controls in a Report
- Apply an AutoFormat to a Report
- Prepare a Report for Print
Class Length: 6-hours
Lesson 1: Controlling Data Entry
- Restrict Data Entry Using Field Properties
- Establish a Pattern for Entering Field Values
- Create a List of Values for a Field
Lesson 2: Joining Tables
- Create Query Joins
- Join Unrelated Tables
- Relate Data Within a Table
Lesson 3: Creating Flexible Queries
- Set Select Query Properties
- Create Parameter Queries
- Create Action Queries
Lesson 4: Improving Forms
- Design a Form Layout
- Enhance the Appearance of a Form
- Restrict Data Entry in Forms
- Add a Command Button to a Form
- Create a Subform
Lesson 5: Customizing Reports
- Organize Report Information
- Format the Report
- Set Report Control Properties
- Control Report Pagination
- Summarize Report Information
- Add a Subreport to an Existing Report
- Create a Mailing Label Report
Lesson 6: Sharing Data Across Applications
- Import Data into Access
- Export Data
- Analyze Access Data in Excel
- Export Data to a Text File
- Merge Access Data with a Word Document
|
