MISSION

supervised and delivers only the official training programs for more than 3000 Courses and 480 Certificates, through 30 dedicated Learning Centers in Egypt, Kuwait, and UAE.....

Read more   

learning process

partner of the most world's technology leaders such as: Microsoft, Cisco, Math-Works, CompTia, WiMax, CWNP, Oracle, EC-Council, CIW, Symantec, ETS, Parametric, PearsonVUE, and more ...

Read more   

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)...

Read more   

Quality assurance

our quality control and montoring system is added value, allow our customers watching the secure cams 24/7, performance and evaluate the training progress. ...

Read more   
Nada Youssef
Date: 2012-11-10
nice site... More...
Ahmed Ali
Date: 2012-11-10
I like the site design, it's sweet .. simple ... well organized. Hope to see next projects... More...
Maha el Said
Date: 2012-11-11
Very Helpful and very organized company...it opens its doors for people who are willing to learn and develop their designing abilities.... More...
mohamed saad
Date: 2012-11-28
it\'s very nice website go ahead..... More...

  • Category: Microsoft Office
    Date: 2012-11-12
                                    Play

  • Category: Adobe
    Date: 2012-11-12
                                    Play

  • Category: Adobe
    Date: 2012-11-12
                                    Play

  • Category: Entercaps Traning Center
    Date: 2012-11-11
                                    Play
  • Photoshop CS5-The Missing Manual
    Photoshop CS5-The Missing Manual
    DOWNLOAD
  • Photoshop CS6 For Dummies
    A dobe Photoshop is one of the most impo
    DOWNLOAD
  • Pro .NET Best Practices
    Pro .NET Best Practices
    DOWNLOAD
  • Hardening Cisco Routers
    Hardening Cisco Routers
    DOWNLOAD
   Access 2010 Advanced

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
-- 12 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: