Access 2003 Advanced Level Seminar

Full Day:Upon completion of this course, the students will be able to restructure an existing set of data to improve the design of a database. They will create macros that will improve data entry efficiency and integrity and maintain an Access database by using various utility tools.

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

Writing Advanced Queries
•    Create Unmatched and Duplicate 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

Download this outline as a PDF.