Hours: 8
Short Description
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.
Course Outline
| 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 |
