Microsoft Access 2007 Training DVD

Introduction

• Welcome Demo

1. Getting Started with Access

• Database concepts and terminology Demo
• Starting Access Demo
• The Getting Started window Demo
• The Quick Access toolbar Demo
• Opening an existing Access database Demo
• The work environment Demo
• Customizing the Access environment

2. Creating Databases and Tables

• Planning and designing databases
• Working with fields
• Choosing keys
• Creating tables
• Creating fields
• Working with records
• Working with data
• Checking spelling

3. Working with Fields and Records

• Modifying table design
• Finding and editing records
• Organizing and sorting records

4. Creating Data Entry Rules

• Setting field properties
• Using input masks
• Setting validation rules

5. Relational Database Techniques

• Creating key fields
• Creating table relationships
• Enforcing referential integrity
• Using subdatasheets

6. Working with Queries

• Creating a query using the wizard
• Creating a query from scratch
• Modifying a query in Design view
• Performing calculations on a group of records
• Creating flexible queries

7. Working with Forms

• Introduction to forms
• Creating forms with the Form wizard
• Creating forms from the Design view
• Modifying a form's design
• Creating subforms
• Adding command buttons to a form
• Sorting and filtering with forms
• Switchboards vs. the Navigation pane

8. Working with Reports

• Using the Report wizard
• Modifying reports in Design view
• Adding custom calculated fields to a report
• Formatting reports
• Summarizing report information
• Creating a mailing label report
• Printing reports

9. Working with Macros

• Creating macros
• Attaching macros
• Automating data entry with macros
• Validating data with macros
• Creating auto-executing macros

10. Sharing Data with Word and Excel

• Importing data into Access
• Using Package and Sign
• Sharing via email
• Exporting data to Excel

11. Working with Charts

• Working with charts
• Working with pivot charts