Access 2003 - Level 2 Training Class

Course ID: 5356

Access 2003 - Level 2 Training Seminar

Overview:
In this course, student will extend their knowledge into some of the more specialized and advanced capabilities.

Who Should Attend:
Access 2003: Level 2 is designed for the student who wishes to learn intermediate and advanced operations of the Microsoft Access Database program. The Level 3 course is for the individual whose job responsibilities include working with heavily related tables; creating advanced queries, forms, and reports; writing macros to automate common tasks; and performing general database maintenance. It is also designed as one in a series of courses for students pursuing the Microsoft MOS Certification for Access 2003, and it is a prerequisite to taking more advanced courses in Access 2003.

Agenda

Lesson 1: Structuring Existing Data Import Data Analyze Tables Create a Junction Table Improve Table Structure
Lesson 2: Writing Advanced Queries Create Unmatched and Duplicates Queries Group and Summarize Records Using the Criteria Field Summarize Data with a Crosstab Query Create a PivotTable and a PivotChart Display a Graphical Summary on a Form
Lesson 3: Simplifying Tasks with Macros Create a Macro Attach a Macro to a Command Button Restrict Records Using a Where Condition
Lesson 4: Adding Interaction and Automation with Macros Require Data Entry with a Macro Display a Message Box with a Macro Automate Data Entry
Lesson 5: Making Forms more Effective Change the Display of Data Conditionally Display a Calendar on a Form Organize Information with Tab Pages
Lesson 6: Making Reports More Effective Cancel Printing of a Blank Report Include a Chart in a Report Arrange Data in Columns Create a Report Snapshot
Lesson 7: Maintaining an Access Database Link Tables to External Data Sources Back Up a Database Compact and Repair a Database Protect a Database with a Password Determine Object Dependency Document a Database Analyze the Performance of a Database