Access 2010 - Level 2

Course details

Students will learn advanced Access features such as, database management, advanced form design, packaging a database, encrypting a database, preparing a database for multi-user access and more.

Objectives

Upon successful completion of this course, students will be able to: 

• restructure data into appropriate tables to ensure data dependency and minimize redundancy.
• write advanced queries to analyze and summarize data.
• create macros.
• customize reports by using various Access features.
• maintain your database using Access tools.

Lessons

Lesson 1: Structuring Existing DataRestructure the Data in a Table 

• Create a Junction Table 
• Improve the Table Structure

Lesson 2: Writing Advanced Queries

• Create Subqueries
• Create Unmatched and Duplicate Queries 
• Filter 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: Creating Effective Reports

• Include a Chart in a Report 
• Print Data in Columns 
• Cancel Printing of a Blank Report 
• Publish a Report as a PDF

Lesson 5: 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