Microsoft Access Level 3
The Level 3 course is for the individual whose job responsibilities include working with related tables; creating advanced queries, forms, and reports; writing macros to automate common tasks; and performing general database maintenance.
Lesson 1: Structuring Existing Data
- Analyze Tables
- Create a Junction Table
- Improve the Table Structure
Lesson 2: Writing Advanced Queries
- Create Subqueries
- Create Unmatched and Duplicate Queries
- Group and Summarize Records Using Criteria
- Summarize Data Using a Crosstab Query
- Create a PivotTable and a PivotChart
Lesson 3: Simplifying Tasks with Macros
- Create a Macro
- Attach a Macro
- Restrict Records Using a Condition
- Validate Data Using a Macro
- Automate Data Entry Using a Macro
Lesson 4: Making Effective Use of Forms
- Display a Calendar on a Form
- Organize Information with Tab Pages
- Display a Summary of Data in a Form
Lesson 5: Making Reports More Effective
- Include a Chart in a Report
- Print Data in Columns
- Cancel Printing of a Blank Report
- Create a Report Snapshot
Lesson 6: Maintaining an Access Database
- Link Tables to External Data Sources
- Manage a Database
- Determine Object Dependency
- Document a Database
- Analyze the Performance of a Database
Microsoft Access
Click Here
We are offering a 2 day course that covers concepts on how databases work, how to build a relational database and how to query and filter your data for $399.
Includes essential topics from levels 1, 2, 3 & 4.
