Courses + Certifications
Professional Development | | Desktop Applications | | Technical | |
|
Home > Desktop Applications > Microsoft Access > Access 2003 - Level 2
Access 2003 - Level 2
| Print Preview | Send to a friend |
| Learning Method: |
Instructor Led |
Overview: |
| In this course, student will extend their knowledge into some of the more specialized and advanced capabilities. |
Target Audience: |
| 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. |
| Module 1: Structuring Existing Data |
- Import Data
- Analyze Tables
- Create a Junction Table
- Improve Table Structure
|
| Module 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
|
| Module 3: Simplifying Tasks with Macros |
- Create a Macro
- Attach a Macro to a Command Button
- Restrict Records Using a Where Condition
|
| Module 4: Adding Interaction and Automation with Macros |
- Require Data Entry with a Macro
- Display a Message Box with a Macro
- Automate Data Entry
|
| Module 5: Making Forms more Effective |
- Change the Display of Data Conditionally
- Display a Calendar on a Form
- Organize Information with Tab Pages
|
| Module 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
|
| Module 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
|
|
 |
|
|
