Access 2010 Advanced

Warm welcome

WE aimed to improve and develop the human resources to be qualified for job Opportunities. By assure quality through the four basic elements of learning process (Official curriculum, Expert Teaching Staff, Hand-ON labs, Suitable Environment)...

Admission

This course is designed for trainees who would like to master Access 2010 advanced features.

Access 2010 Advanced

Exam #

Duration

Language

Level

Type

Classroom

Code

Fees

Arabic/English

Advanced

Course

Classroom

Cs121

300 LE

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.

Objectives :

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

Topics :

Advanced Database Techniques

Normalizing databases
First, second and third normal forms
Analyzing databases
Performance Analyzer & Documenter

Advanced Queries

Crosstab queries
PivotTables & PivotCharts
Joining tables through queries
Make table query
Update query
Append query
Delete query
SQL queries

Automating Database Applications

Working with macros
Assigning macros to controls
Assigning macros to events
Assigning macros to conditions
Working with macro groups

Securing & Maintaining Databases

Converting databases
Backing up, compacting and repairing databases
Splitting databases
Creating Navigation Form
Applying a database password

Recommended Knowledge :

Access 2010 Core.

Recommended Course(s) :

Access 2010 Core

Training Materials :

EnterCaps Official Courseware

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.

Category :
Office

The Instructor:

MISSION

learning process

Warm welcome

Quality assurance