Microsoft Access 2003 Advanced

Advanced users 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
Skills Gained
* 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..

By the end of this course you will be able to produce advanced form interfaces, understand hyperlinked and data access pages, create and use macros, design advanced data queries and implement Access security features.

Structuring Existing Data
Import Data. Analyze Tables. Create a Junction Table. Improve Table Structure.

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.

Simplifying Tasks with Macros
Create a Macro. Attach a Macro to a Command Button. Restrict Records Using a Where Condition.

Adding Interaction and Automation with Macros
Require Data Entry with a Macro. Display a Message Box with a Macro. Automate Data Entry.

Making Forms More Effective
Change the Display of Data Conditionally. Display a Calendar on a Form. Organize Information with Tab Pages.

Making Reports More Effective
Cancel Printing of a Blank Report. Include a Chart in a Report. Arrange Data in Columns. Create a Report Snapshot.

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.