Microsoft Access 2003: Level 2

Revision: TE1305_20060318

Course Length:

1 Day

Course Description:

Students will learn how to design and create a new Access database, customize database components, and share Access data with other applications. This is one of a series of courses that addresses Microsoft Office Specialist skill sets. The Office Specialist program is for individuals who use Microsoft’s business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more proficiency exams in order to earn Office Specialist certification.

Who Should Attend:

This course is for students who wish to learn intermediate-level operations of the Access program. This course is also designed for students pursuing the Microsoft Office Specialist Certification for Access 2003, and it is a prerequisite to taking more advanced courses in Access 2003.

Benefits of Attendance:

Upon completion of this course, students will be able to:

• Follow the steps required to design a simple database.
• Create a new database with related tables.
• Control data entry by modifying the design of a table.
• Find and retrieve desired data by using filters and joins between tables and within a single table.
• Create flexible queries.
• Enhance the appearance, data entry, and data access capabilities of your forms.
• Customize reports.
• Use Access data in other applications.

Prerequisites:

Students should have taken Microsoft Access 2003: Level 1 or have equivalent knowledge. A basic understanding of Microsoft® Excel and Microsoft® Word would also be helpful but is not required.

Course Outline:

• Chapter 1: Planning A Database
  1. Designing a Relational Database
  2. Identifying Database Purpose
  3. Reviewing Existing Data
  4. Determining Fields
  5. Grouping Fields into Tables
  6. Normalizing the Data
  7. Designating Primary and Foreign Keys
• Chapter 2: Building The Structure Of A Database
  1. Creating a New Database
  2. Creating a Table Using a Wizard
  3. Creating Tables in Design View
  4. Creating Relationships Between Tables
• Chapter 3: Controlling Data Entry
  1. Restricting Data Entry with Field Properties
  2. Creating an Input Mask
  3. Creating a Lookup Field
• Chapter 4: Finding And Joining Data
  1. Finding Data with Filters
  2. Creating Query Joins
  3. Joining Unrelated Tables
  4. Relating Data Within a Table
• Chapter 5: Creating Flexible Queries
  1. Setting Select Query Properties
  2. Creating Parameter Queries
  3. Creating Action Queries
• Chapter 6: Improving Your Forms
  1. Enhancing the Appearance of a Form
  2. Restricting Data Entry in Forms
  3. Adding Command Buttons
  4. Creating a Subform
• Chapter 7: Customizing Your Reports
  1. Organizing Report Information
  2. Setting Report Control Properties
  3. Controlling Report Pagination
  4. Summarizing Information
  5. Adding a Subreport to an Existing Report
  6. Creating Mailing Labels
• Chapter 8: Expanding The Reach Of Your Data
  1. Publishing Access Data as a Word Document
  2. Analyzing Access Data in Excel
  3. Exporting Data to a Text File
  4. Merging Access Data with a Word Document
• Appendix A: Microsoft Office Specialist Program