Diplomas
Certificates
Courses

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   
Call our Sales
   Clients Testimonials
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 Core

Admission

This course designed for trainees who would like to master Microsoft Access 2010 basic Features.


Access 2010 Core
Exam # Duration Language Level Type Classroom Code Fees
-- 21 Arabic/English Core Course Classroom Cs120 400 LE
Description :

In this course, trainees will learn basic features of Microsoft Access 2010. Trainees will have a systematic guidance through the development of database applications and will learn how to use & create the database objects within their database applications. The course stresses on providing basic understanding of database building.



Objectives :
  • Understanding database concepts
  • Using Access databases
  • Creating & using database objects
  • Customizing database objects to suite end users
  • Exchanging data between Access databases and the other programs


Topics :

Using Access Databases

  • Database Concepts
  • Introducing Access 2010
  • Introducing Database Objects
  • Displaying Object Dependencies
  • Displaying & Organizing Data
  • Manipulating & Constraining Data

Tables

  • Creating Access Databases
  • Creating & Customizing Tables
  • Displaying & Printing Table Data
  • Customizing Field Properties
  • Creating Table Relationships
  • Creating Indexes
  • Creating Lookup Fields
  • Creating Multi-Valued Lookup Fields

Queries

  • Creating Select Queries
  • Find Duplicates Query
  • Find Unmatched Query
  • Customizing Queries
  • Sorting & Filtering through Queries
  • Building Query Expressions
  • Using Parameters in Queries

Forms

  • Creating Simple Forms
  • Designing Forms from Scratch
  • Customizing Form Properties
  • Creating Form Controls
  • Creating Sub Forms
  • Creating Search Screens

Reports

  • Creating Simple Reports
  • Designing Reports from Scratch
  • Customizing Report Look & Feel
  • Grouping & Sorting Report Data
  • Creating Mailing Labels
  • Adding Controls to Reports
  • Previewing & Printing Reports

Exchanging Data

  • Importing Data to Access Databases
  • Exporting Data from Access Databases
  • Linking Data with Access Databases
  • Working with Saved Imports & Exports
 
 
 

 





Recommended Knowledge :

Previous Knowledge of Windows operating system (any version).

Recommended Course(s) :

Windows 7 Core


Training Materials :

EnterCaps Official Courseware .


Labs :

This course includes several labs to ensure you will gain the targeted skills and experience.


Credential :

This course is an essential part of EnterCaps Professional Diploma in Accounting. With the advanced level, this course covers the entire topics required for MOS: Microsoft Office Access 2010 exam.

Category :
Office


The Instructor:
Copyright © 2008-2012 - EnterCaps for Design and Development - All rights reserved.