MICROSOFT OFFICE 

  ACCESS EXPERT 

BEST MICROSOFT OFFICE ACCESS EXPERT TRAINING INSTITUTE & MICROSOFT OFFICE ACCESS ASSOCIATE CERTIFICATIONS OF WORLD

CORE FEATURES OF OUR MICROSOFT OFFICE ACCESS EXPERT PROGRAM

Microsoft Office Specialist Access Expert certification & Training

The Microsoft Office Specialist: Access Expert Training & Certification demonstrates competency in database design principles. The exam covers the ability to create and maintain Access Database objects including tables, relationships, data entry forms, multilevel reports, and multi-table queries. This course demonstrate the correct application of the principal features of Access and can complete tasks independently.

Course Objectives

1.1 Modify database structure

1.1.1 Import objects or data from other sources
1.1.2 Delete database objects
1.1.3 Hide and display objects in the Navigation Pane

1.2 Manage table relationships and keys

1.2.1 Understand relationships
1.2.2 Display relationships
1.2.3 Set Primary Keys
1.2.4 Enforce referential integrity
1.2.5 Set foreign keys

1.3 Print and export data

1.3.1 Configure print options for records, forms,
and reports
1.3.2 Export objects to alternative formats

2.1 Create tables

2.1.1 Import data into tables
2.1.2 Create linked tables from
external sources
2.1.3 Import tables from other databases

2.2 Manage tables

2.3 Manage table records

2.3.1 Find and replace data
2.3.2 Sort records
2.3.3 Filter records

2.4 Create and modify fields

2.4.1 Add and remove fields
2.4.2 Add validation rules to fields
2.4.3 Change field captions
2.4.4 Change field sizes
2.4.5 Change field data types
2.4.6 Configure fields to auto-increment
2.4.7 Set default values
2.4.8 Apply built-in input masks

3.1 Create and run queries

3.1.1 Create simple queries
3.1.2 Create basic crosstab queries
3.1.3 Create basic parameter queries
3.1.4 Create basic action queries
3.1.5 Create basic multi-table queries
3.1.6 Save queries
3.1.7 Run queries

4.1 Configure form controls

4.1.1 Add, move, and remove form
controls
4.1.2 Set form control properties
4.1.3 Add and modify form labels

3.2 Modify queries

3.2.1 Add, hide, and remove
fields in queries
3.2.2 Sort data within queries
3.2.3 Filter data within queries
3.2.4 Format fields within queries

3.3 Create and modify lists

4.2 Create and manage reference tables

4.2.1 Modify tab order on forms
4.2.2 Sort records by form field
4.2.3 Modify form positioning
4.2.4 Insert information in form
headers and footers
4.2.5 Insert images on forms

3.3.1 Format paragraphs as numbered
and bulleted lists
3.3.2 Change bullet characters and
number formats
3.3.3 Define custom bullet characters
and number formats
3.3.4 Increase and decrease list levels
3.3.5 Restart and continue list numbering
3.3.6 Set starting number values

5.1 Configure report controls

5.1.1 Group and sort fields on reports
5.1.2 Add report controls
5.1.3 Add and modify labels on reports

5.2.1 Format a report into multiple
columns
5.2.2 Modify report positioning
5.2.3 Format report elements
5.2.4 Change report orientation
5.2.5 Insert information in report
headers and footers
5.2.6 Insert images on reports

For More Information Regarding Course Outline,Lesson Plan,Project,Assignment Please mail us or call us

We do provide world wide training & certification

a.jpg
BEST AUTODESK AUTHORIZED ENGINEERING CAD DESIGN TRAINING LEARNING CERTIFICATION CENTER LOGO IN KOLKATA INDIA

B I M DESIGN & TECHNOLOGY

NAVIGATION

ADDRESS: 315,SWAMI VIVEKANANDA PALLY, TAKI ROAD, BARASAT, KOLKATA, WEST BENGAL 700124,INDIA

PHONE: +917439015299

OUR GLOBAL PARTNERS LOCATED

 KERALA/DUBAI/SINGAPORE/NEW YORK

© 2020 by BIM DESIGN & TECHNOLOGY. All Rights Reserved.