This course is not currently offered by Global Knowledge. Information here is provided for reference only.

Learn to plan, implement, and navigate an Access 2003 database.

What You'll Learn

• Plan a database design that meets your organization's requirements
• Identify relationships within a database
• Add a table and modify fields to define a table's features
• Create a database containing relational tables in response to a business requirement
• Select methods for adding, formatting, and manipulating controls
• Format a form and manage records
• Create a crosstab query
• Use queries to obtain useful information
• Perform backup and view dependencies in Access 2003
• Edit a SELECT query using SQL
• Organize data with PivotTables and PivotCharts
• Create, launch, modify, and debug macros
• Use the Visual Basic Editor to allow a database object to start handling users' actions

Who Needs to Attend

End users seeking to become familiar with Microsoft Access 2003 or to obtain Microsoft Office Specialist (MOS) certification in the use of Microsoft Access 2003 at Core level.

Prerequisites

Familiarity with the Microsoft Office environment

Follow-On Courses

There are no follow-ons for this course.

Course Outline

1. Microsoft Office 2003: Beginning Access

• Key database concepts for Access 2003
• Planning Access 2003 databases
• Planning relationships in database tables
• Getting started with Access 2003
• Components of an Access 2003 database
• Creating and viewing an Access 2003 database

2. Basic Access 2003 Tables

• Creating tables in Access 2003
• Using the Design and Datasheet views in Access 2003
• Modifying tables in Access 2003
• Using masked input fields and indexing in Access 2003
• Manipulating data in records in Access 2003
• Creating and editing relationships in Access 2003
• Creating a relational database in Access 2003

3. Basic Access 2003 Forms

• Creating forms in Access 2003
• Adding controls and setting properties in Access 2003
• Resizing and repositioning controls in Access 2003
• Creating bound controls in Access 2003
• Creating a form with bound controls in Access 2003
• Formatting a form and managing records in Access 2003

4. Using Queries and Reports in Access 2003

• Creating and viewing queries in Access 2003
• Refining a query in Access 2003
• Adding calculations to a query in Access 2003
• Unmatched and duplicate queries in Access 2003
• Creating and using reports in Access 2003
• Adding controls to Access 2003 reports
• Organizing Access 2003 report data

5. Personalizing and Maintaining Access 2003

• Personalizing Access 2003
• Access 2003 maintenance and management
• Access 2003 backup and object dependencies
• Personalizing and maintaining a database in Access 2003

6. Enhancing Tables, Forms, and Reports in Access 2003

• Accessing and validating table data in Access 2003
• Creating switchboards in Access 2003
• Using subforms, subreports, and switchboards in Access 2003
• Using conditional formatting in Access 2003

7. Advanced Querying in Access 2003

• Joins and parameter queries in Access 2003
• Using action queries to update, append, and delete records and make tables
• Using SQL in Access 2003 queries
• Using joins and creating an update and an SQL query

8. Working with Data and Presentation in Access 2003

• Importing and exporting data in Access 2003
• Creating a PivotTable in Access 2003
• Creating a PivotChart in Access 2003
• Using Access 2003 PivotTables and PivotCharts

9. Access 2003 and the Web

• Adding hyperlinks in Access 2003
• Creating data access pages in Access 2003
• Modifying and deploying an Access 2003 data access page

10. Access 2003 Programmability

• Creating macros in Access 2003
• Launching and modifying macros in Access 2003
• Introducing VBA in Access 2003
• Handling events in Access 2003

11. Database Administration in Access 2003

• Securing database information in Access 2003
• Setting a password and securing VB code in Access 2003
• Sharing a database in Access 2003
• Replicating a database in Access 2003
• Optimizing Access 2003 database performance