Access 2003: Level 2

 

Performance-Based Objectives

·         Follow The Steps Required To Properly Design A Simple Database.

·         Create A New Database With Related Tables.

·         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.

·         Create Flexible Queries To Display Specified Records; Allow For User-Determined Query Criteria; And Add, Update, And Delete Data With Queries.

·         Enhance The Appearance, Data Entry, And Data Access Capabilities Of Your Forms.

·         Customize Reports To Better Organize The Displayed Information And Produce Specific Print Layouts Such As Mailing Labels.

·        Use Access Data In Other Applications, Including Microsoft Word And Excel.

 

Course Content

 

Lesson 1: Planning a Database

·         Design a Relational Database

·         Identify Database Purpose

·         Review Existing Data

·         Determine Fields

·         Group Fields into Tables

·         Normalize the Data

·         Designate Primary and Foreign Keys

 

Lesson 2: Building the Structure of a Database

·         Create a New Database

·         Create a Table Using a Wizard

·         Create Tables in Design View

·         Create Relationships between Tables

 

Lesson 3: Controlling Data Entry

·         Restrict Data Entry with Field Properties

·         Create an Input Mask

·         Create a Lookup Field

 

Lesson 4: Finding and Joining Data

·         Find Data with Filters

·         Create Query Joins

·         Join Unrelated Tables

·        Relate Data Within a Table

Lesson 5: Creating Flexible Queries

·         Set Select Query Properties

·         Create Parameter Queries

·         Create Action Queries

 

Lesson 6: Improving Your Forms

·         Enhance the Appearance of a Form

·         Restrict Data Entry in Forms

·         Add Command Buttons/Create a Subform

 

Lesson 7: Customizing Your Reports

·         Organize Report Information

·         Set Report Control Properties

·         Control Report Pagination

·         Summarize Information

·         Add a Subreport to an Existing Report

·         Create Mailing Labels

 

Lesson 8: Expanding the Reach of Your Data

·         Publish Access Data as a Word Document

·         Analyze Access Data in Excel

·         Export Data to a Text File

·         Merge Access Data with a Word Document

 

Appendix A: Microsoft Office Specialist Program