Corporate Training By Zack Academy - Access 2013 - Intermediate

Why Should You Take This Access 2013 - Intermediate Course?

This ILT Series course provides students with additional skills and concepts needed to use Microsoft Access 2013 productively and efficiently. They will learn to normalize data, join tables while observing referential integrity, query multiple tables, format forms and reports, insert background images and charts; and create specialized objects such as lookup fields, subforms and subreports, navigation forms, and calculated fields. This course will help students prepare for the Microsoft Office Specialist exam for Access 2013 (exam 77-424). For comprehensive certification training, students should complete the Basic, Intermediate, and Advanced courses for Access 2013.

Taking this course will give you the skills necessary to effectively and efficiently:

• Create and manage a database
• Build tables
• Create queries 
• Create forms
• Create reports

The Following Topics Will Be Covered:

1.  Relational Databases:

• Topic A: Database normalization
• Topic B: Table relationships
• Topic C: Referential integrity 

2.  Related Tables:

• Topic A: Creating lookup fields
• Topic B: Modifying lookup fields
• Topic C: Sub-datasheets

3.  Complex Queries:

• Topic A: Joining tables in queries
• Topic B: Using calculated fields
• Topic C: Summarizing and grouping values

4.  Advanced Form Design:

• Topic A: Adding unbound controls
• Topic B: Graphics
• Topic C: Adding calculated values
• Topic D: Adding combo boxes
• Topic E: Advanced form types

5.  Reports and Printing:

• Topic A: Report formatting
• Topic B: Calculated values and subreports
• Topic C: Printing
• Topic D: Label printing

6.  Charts:

• Topic A: Charts in forms
• Topic B: Charts in reports

Syllabus

Unit 1: Relational Databases:

• Topic A: Database normalization
• Topic B: Table relationships
• Topic C: Referential integrity

Unit 2: Related Tables:

• Topic A: Creating lookup fields
• Topic B: Modifying lookup fields
• Topic C: Subdatasheets

Unit 3: Complex Queries:

• Topic A: Joining tables in queries
• Topic B: Using calculated fields
• Topic C: Summarizing and grouping values

Unit 4: Advanced Form Design:

• Topic A: Adding unbound controls
• Topic B: Graphics
• Topic C: Adding calculated values
• Topic D: Adding combo boxes
• Topic E: Advanced form types

Unit 5: Reports and Printing:

• Topic A: Report formatting
• Topic B: Calculated values and subreports
• Topic C: Printing
• Topic D: Label printing

Unit 6: Charts:

• Topic A: Charts in forms
• Topic B: Charts in reports