Comprehensive Microsoft Access 2003 Training

Delivery Options

• Customized Onsite Training (4 days): Request a Proposal

Class Description

Class Overview

Class Goals

• Understand how Microsoft Access and relational databases work.
• Examine the Microsoft Access database application.
• Learn to manage the data in a Microsoft Access database.
• Examine existing table relationships in Microsoft Access.
• Learn to query a Microsoft Access database.
• Learn to design simple forms in Microsoft Access.
• Learn to create and modify Microsoft Access reports.
• Learn to design a simple database in Microsoft Access.
• Learn to create a new database with related tables.
• Learn to control data entry by modifying the design of a table to streamline data entry and maintain data integrity.
• Find and retrieve desired data by using filters and joins between tables and within a single table.
• Learn to create flexible queries to display specified records; allow for user-determined query criteria; and add, update, and delete data with queries.
• Learn to improve the appearance, data entry, and data access capabilities of your forms.
• Learn to customize reports to better organize the displayed information and produce specific print layouts such as mailing labels.
• Learn to use Access data in other applications, including Microsoft Word and Excel.
• Learn to restructure an existing set of data to improve the design of a database.
• Learn to use a variety of techniques to summarize and present data with queries.
• Learn to create and revise basic Access macros.
• Learn to create macros that improve data entry efficiency and integrity.
• Learn to improve the effectiveness of data entry in forms.
• Learn to improve the effectiveness of data displayed in reports.
• Learn to maintain an Access database by using various utility tools.
• Learn to develop a data access page, a PivotTable, and a PivotChart.
• Learn to import XML data and export Access data.
• Learn to use VBA to automate a business process.
• Learn to create and modify a database switchboard, and set and modify your startup options.
• Learn to distribute a database and add security features to it.

Class Outline

1. An Overview of Microsoft Access
   1. Understand Relational Databases
   2. Examine the Access Environment
   3. Open the Database Environment
   4. Examine an Access Table
2. Managing Data in Microsoft Access
   1. Examine an Access Form
   2. Add and Delete Records
   3. Sort Records
   4. Display Recordsets
   5. Update Records
   6. Run a Report
3. Establishing Table Relationships in Microsoft Access
   1. Identify Table Relationships
   2. Identify Primary and Foreign Keys in the Relationships Window
   3. Work with Subdatasheets
4. Querying the Database in Microsoft Access
   1. Create a Select Query
   2. Add Criteria to a Query
   3. Add a Calculated Field to a Query
   4. Perform a Calculation on a Record Grouping
5. Designing Forms in Microsoft Access
   1. Examine Form Design Guidelines
   2. Create a Form Using AutoForm
   3. Create a Form Using the Form Wizard
   4. Modify the Design of a Form
6. Producing Reports in Microsoft Access
   1. Create an AutoReport
   2. Create a Report by Using the Wizard
   3. Examine a Report in Design View
   4. Add a Calculated Field to a Report
   5. Modify the Format Properties of a Control
   6. AutoFormat a Report
   7. Adjust the Width of a Report
7. Planning a Database in Microsoft Access
   1. Design a Relational Database
   2. Identify Database Purpose
   3. Review Existing Data
   4. Determine Fields
   5. Group Fields into Tables
   6. Normalize the Data
   7. Designate Primary and Foreign Keys
8. Building the Structure of a Database in Microsoft Access
   1. Create a New Database
   2. Create a Table Using a Wizard
   3. Create Tables in Design View
   4. Create Relationships between Tables
9. Controlling Data Entry in Microsoft Access
   1. Restrict Data Entry with Field Properties
   2. Create an Input Mask
   3. Create a Lookup Field
10. Finding and Joining Data in Microsoft Access
    1. Find Data with Filters
    2. Create Query Joins
    3. Join Unrelated Tables
    4. Relate Data Within a Table
11. Creating Flexible Queries in Microsoft Access
    1. Set Select Query Properties
    2. Create Parameter Queries
    3. Create Action Queries
    4. Improving Your Forms
    5. Enhance the Appearance of a Form
    6. Restrict Data Entry in Forms
    7. Add Command Buttons
    8. Create a Subform
12. Customizing Your Reports in Microsoft Access
    1. Organize Report Information
    2. Set Report Control Properties
    3. Control Report Pagination
    4. Summarize Information
    5. Add a Subreport to an Existing Report
    6. Create Mailing Labels
13. Expanding the Reach of Your Data in Microsoft Access
    1. Publish Access Data as a Word Document
    2. Analyze Access Data in Excel
    3. Export Data to a Text File
    4. Merge Access Data with a Word Document
14. Structuring Existing Data in Microsoft Access
    1. Import Data
    2. Analyze Tables
    3. Create a Junction Table
    4. Improve Table Structure
15. Writing Advanced Queries in Microsoft Access
    1. Create Unmatched and Duplicates Queries
    2. Group and Summarize Records Using the Criteria Field
    3. Summarize Data with a Crosstab Query
    4. Create a PivotTable and a PivotChart
    5. Display a Graphical Summary on a Form
16. Simplifying Tasks with Macros in Microsoft Access
    1. Create a Macro
    2. Attach a Macro to a Command Button
    3. Restrict Records Using a Where Condition
17. Adding Interaction and Automation with Macros in Microsoft Access
    1. Require Data Entry with a Macro
    2. Display a Message Box with a Macro
    3. Automate Data Entry
18. Making Forms More Effective in Microsoft Access
    1. Change the Display of Data Conditionally
    2. Display a Calendar on a Form
    3. Organize Information with Tab Pages
19. Making Reports More Effective in Microsoft Access
    1. Cancel Printing of a Blank Report
    2. Include a Chart in a Report
    3. Arrange Data in Columns
    4. Create a Report Snapshot
    5. Maintaining an Access Database
    6. Link Tables to External Data Sources
    7. Back Up a Database
    8. Compact and Repair a Database
    9. Protect a Database with a Password
    10. Determine Object Dependency
    11. Document a Database
    12. Analyze the Performance of a Database
20. Making Your Data Available on the Web
    1. Create a Data Access Page by Using the Wizard
    2. Improve the Presentation of the Data Access Page
    3. Viewing Data Access Pages with the Browser
    4. Edit Data Using the Data Access Page
    5. Group Records in the Data Access Page
21. Developing a Data Access Page in Design View
    1. Create a Data Access Page in Design View
    2. Incorporate a ComboBox in the Data Access Page
    3. Test the New Record Function of the Data Access Page
    4. Develop a PivotTable with the Office PivotTable Tool
    5. Develop a PivotChart
22. Integrating Access into Your Business
    1. Import XML Data into an Access Database
    2. Export Access Data to XML Format
    3. Share Data with Other Office Applications
23. Automating a Business Process with VBA
    1. Create a Standard Module
    2. Develop Code
    3. Call a Procedure from a Form
    4. Run the Procedure
24. Creating a Switchboard and Setting the Startup Options
    1. Create a Database Switchboard
    2. Modify a Database Switchboard
    3. Set the Startup Options
    4. Modify the Startup Options
25. Distributing and Securing the Database
    1. Split a Database
    2. Implement Security
    3. Set Passwords
    4. Encode and Decode a Database
    5. Convert an Access Database to an MDE File

Class Materials

All students receive a course manual or book and all the class examples.

Students in private onsite classes will also receive:

• Technical Reference Library

Technical Requirements

Our computer technical requirements and setup process is easy, with support just a click away.

• Course technical requirements and setup instructions.