· Understand and get familiar with the database normalization
· Work with the Table Analyzer to enhance tables' design
· Use the Performance Analyzer to enhance the database performance
· Use the Documenter to produce statistical reports about databases
· Create and use crosstab queries to get structural matrix reports
· Create and customize PivotTables to produce complex structural matrix reports
· Create PivotCharts to graphically represent data
· Display related data from multiple tables using joins
· Manipulate tables' data using action queries
· Write simple SQL SELECT statements against tables' data
· Use the WHERE clause to restrict data through SELECT statements
· Use the ORDER BY clause to sort data through SELECT statements
· Create and use macros to automate database usual tasks
· Assign macros to controls, events and conditions
· Create and use macro groups
· Convert databases between various Microsoft Access versions
· Split a database to back-end and front-end databases
· Compact and repair databases
· Create a backup copy from the database file
· Secure databases by using passwords
· Create Navigation Form
Description
In this course, trainees will learn advanced features of Microsoft Access 2010. They will go through the development of several sophisticated applications a step by step. The course stresses on providing in-depth understanding of database design, as well as using the advanced Access 2010 techniques to enhance both of the appearance and functionality of the database applications.
Audience :
This course is designed for trainees who would like to master Access 2010 advanced features.
Topics :
Advanced Database Techniques
o Normalizing databases
o First, second and third normal forms
o Analyzing databases
o Performance Analyzer & Documenter
Advanced Queries
o Crosstab queries
o PivotTables & PivotCharts
o Joining tables through queries
o Make table query
o Update query
o Append query
o Delete query
o SQL queries
Automating Database Applications
o Working with macros
o Assigning macros to controls
o Assigning macros to events
o Assigning macros to conditions
o Working with macro groups
Securing & Maintaining Databases
o Converting databases
o Backing up, compacting and repairing databases
o Splitting databases
o Creating Navigation Form
o Applying a database password
Recommended Knowledge :
Access 2010 Core
Recommended Course(s) :
Category :
Training Materials :
YAT Official Courseware (YOC)
Labs :
This course includes several labs to ensure you will gain the targeted skills and experience.
Credential :
With the Core level, this course covers the entire topics required for MOS: Microsoft Office Access 2010 exam.
