Your training in and use of Microsoft® Office Access 2003 has provided you with a solid foundation in the basic and intermediate skills for working in Microsoft® Office Access 2003. You're now ready to extend your knowledge into some of the more specialized and advanced capabilities.
Upon successful completion of this course, students will be able to:
- restructure an existing set of data to improve the design of a database.
- use a variety of techniques to summarize and present data with queries.
- create and revise basic Access macros.
- create macros that improve data entry efficiency and integrity.
- improve the effectiveness of data entry in forms.
- improve the effectiveness of data displayed in reports.
- maintain an Access database by using various utility tools.
This course is designed for the student who wishes to learn intermediate and advanced operations of the Microsoft® Office Access 2003 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® Office Specialist Certification for Microsoft® Office Access 2003, and it is a prerequisite to taking more advanced courses in Microsoft® Office Access 2003.
To ensure the successful completion of Microsoft® Office Access 2003: Level 3, we recommend completion of the following courses, or equivalent knowledge (familiarity with basic and intermediate features of Access tables, relationships, queries, forms, and reports) from another source:
- Microsoft® Office Access 2003: Level 1
- Microsoft® Office Access 2003: Level 2
Lesson 1: Structuring Existing DataTopic 1A: Import DataTopic 1B: Analyze TablesTopic 1C: Create a Junction TableTopic 1D: Improve Table StructureLesson 2: Writing Advanced QueriesTopic 2A: Create Unmatched and Duplicates QueriesTopic 2B: Group and Summarize Records Using the Criteria FieldTopic 2C: Summarize Data with a Crosstab QueryTopic 2D: Create a PivotTable and a PivotChartTopic 2E: Display a Graphical Summary on a FormLesson 3: Simplifying Tasks with MacrosTopic 3A: Create a MacroTopic 3B: Attach a Macro to a Command ButtonTopic 3C: Restrict Records Using a Where Condition Lesson 4: Adding Interaction and Automation with MacrosTopic 4A: Require Data Entry with a MacroTopic 4B: Display a Message Box with a MacroTopic 4C: Automate Data EntryLesson 5: Making Forms More EffectiveTopic 5A: Change the Display of Data ConditionallyTopic 5B: Display a Calendar on a FormTopic 5C: Organize Information with Tab PagesLesson 6: Making Reports More EffectiveTopic 6A: Cancel Printing of a Blank ReportTopic 6B: Include a Chart in a ReportTopic 6C: Arrange Data in ColumnsTopic 6D: Create a Report SnapshotLesson 7: Maintaining an Access DatabaseTopic 7A: Link Tables to External Data SourcesTopic 7B: Back Up a DatabaseTopic 7C: Compact and Repair a DatabaseTopic 7D: Protect a Database with a PasswordTopic 7E: Determine Object DependencyTopic 7F: Document a DatabaseTopic 7G: Analyze the Performance of a Database