Microsoft Access

In Access 2016, the relational database app in Microsoft Office, you can design your own databases or use templates to create databases to share with others, namely coworkers. LearnKey Senior Instructor Jason Manibog will take you through creating databases, creating tables, building queries, building forms, and building reports. These five topics are also the topics on the Microsoft Office Specialist exam for Access 2016 (Exam 77-730). This, combined with what you will learn about relational database structures, will improve your employability prospects in any position needing skills with small to medium-sized relational databases.

Fees

$200 USD One Time
Special Discount (75% OFF) Available for Online students

Fees after scholarship*
$150 international students
$150 US domestic students
*Valid from June 2020 intake.

schedule

July 8, 2020

September 16, 2020

November 10, 2020

Duration

Academic: 13 weeks in-class and 10 weeks practical Training.

Total length: 6 Month including scheduled breaks.

Class Time:

Timing: 0830 – 1630 Hrs for Institute Students.

Online Students: Day timing according to teacher/student schedule.

Gain the skills and confidence required to successfully obtain your Microsoft Office Access 2016 certification
Test prep questions that meet all Access 2016 exam objectives
View your online course ware anytime, anywhere
Enhance your personal and professional skills to achieve your goals.
Develop the necessary skills and knowledge to become an effective professional.

Session 1

Section A: Introduction

Course Opening
How to Study for This Exam

Section B: Introduction to Access

Database Definition
Tour of Access

Section C: Create and Modify Databases

Create a Blank Database
Create a Database from a Template
Import Objects from Access
Import Objects from Excel
Delete Database Objects

Section D: Rules of Databases

Relational Database Definition
Flat Database Problem
Rules of Relational Table Design
Planning a Database

Section E: Manage Relationships and Keys

Create and Modify Relationships
Set Primary Keys
Referential Integrity and Foreign Keys
View Relationships

Section F: Navigate Through a Database

Section G: Protect and Maintain Databases

Compact and Repair a Database
Back Up a Database
Split a Database
Encrypt a Database
Recover Data from a Backup

Section H: Print and Export Data

Print Reports
Print Records
Save a Database as a Template
Export Data

Section I: Session 1 Recap

Domain 1 Test Tips

Session 2

Section A: Create Tables

Build Tables
Import Data into Tables
Create External Links to Tables
Import Tables from Other Databases
Use Application Parts to Create Table

Section B: Manage Tables

Hide Fields in Tables
Add Total Rows
Add Table Descriptions
Rename Tables

Section C: Manage Records in Tables

Section D: Create and Modify Fields

Section E: Session 2 Recap

Domain 2 Test Tips

Session 3

Section A: Create a Query

Section B: Modify a Query

Rename a Query
Add Fields
Remove Fields, Hide Fields
Sort Data Within Queries
Format Fields Within Queries

Section C: Calculated Fields and Grouping

Add Calculated Fields
Set Filtering Criteria
Inner and Outer Joins
Group and Summarize Data
Use Comparison, Arithmetic, and Logical

Session 4

Section A: Build Forms

Create a Form
Use Application Parts to Create a Form
Save a Form

Section B: Configure Form Controls

Section C: Format a Form

Section D: Session 4 Recap

Domain 4 Test Tips

Session 5

Section A: Create Reports

Reports Based on a Queries and Tables
Create a Report in Design View
Create a Report by Using a Wizard

Section B: Configure Report Controls

Group and Sort Fields
Modify Data Sources
Add Report Controls
Add and Modify Labels

Section C: Format a Report

Section D: Session 5 Recap

Domain 5 Test Tips
Conclusion

Don’t Miss this opportunity

Microsoft Access

Fees

schedule

Duration

Class Time:

Session 1

Section A: Introduction

Course Opening

How to Study for This Exam

Section B: Introduction to Access

Database Definition

Tour of Access

Section C: Create and Modify Databases

Create a Blank Database

Create a Database from a Template

Import Objects from Access

Import Objects from Excel

Delete Database Objects

Section D: Rules of Databases

Relational Database Definition

Flat Database Problem

Rules of Relational Table Design

Planning a Database

Section E: Manage Relationships and Keys

Create and Modify Relationships

Set Primary Keys

Referential Integrity and Foreign Keys

View Relationships

Section F: Navigate Through a Database

Navigate Specific Records

Create a Navigation Form

Modify a Navigation Form

Set a Form as the Startup Option

Set Navigation Pane Display Options

Change Object Views

Section G: Protect and Maintain Databases

Compact and Repair a Database

Back Up a Database

Split a Database

Encrypt a Database

Recover Data from a Backup

Section H: Print and Export Data

Print Reports

Print Records

Save a Database as a Template

Export Data

Section I: Session 1 Recap

Domain 1 Test Tips

Session 2

Section A: Create Tables

Build Tables

Import Data into Tables

Create External Links to Tables

Import Tables from Other Databases

Use Application Parts to Create Table

Section B: Manage Tables

Hide Fields in Tables

Add Total Rows

Add Table Descriptions

Rename Tables

Section C: Manage Records in Tables

Update Records

Add and Delete Records

Append Records from External Data

Find and Replace Data

Sort Records

Filter Records

Section D: Create and Modify Fields

Add Fields to Tables

Add Field Validation Rules

Change Fields Captions

Change Field Sizes

Change Field Data Types

Change Field Formatting

Configure Fields to Auto-Increment

Set Default Values

Use Input Masks

Delete Fields

Section E: Session 2 Recap

Domain 2 Test Tips