
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
-
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
Session 3
Section A: Create a Query
-
Create a Select Query
-
Add Criteria
-
Create a Crosstab Query
-
Create a Parameter Query
-
Create an Action Query
-
Create a Multi-Table Query
-
Save 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
-
Move Form Controls
-
Add Form Controls
-
Modify Data Sources
-
Remove Form Controls
-
Set Form Control Properties
-
Manage Labels
-
Add Subforms
Section C: Format a Form
-
Modify Tab Order
-
Configure Print Settings
-
Sort Records by Form Field
-
Apply a Theme
-
Control Form Positioning
-
Insert Backgrounds
-
Insert Headers and Footers
-
Insert Images
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
-
Split Report into Multiple Columns
-
Add Calculated Fields
-
Control Report Positioning
-
Format Report Elements
-
Change Report Orientation
-
Insert Header and Footer Information
-
Insert Logo and Title
-
Insert Images
-
Apply a Theme
Section D: Session 5 Recap
-
Domain 5 Test Tips
-
Conclusion
Admission Requirement
All students must be at least eighteen (18) years of age on or before the first day of class. Students must provide a High School Diploma or a General Education Development Certificate (G.E.D) .
Assessment Method
You must successfully complete all modules to be awarded the certificate.
The assessment of each module consists of:
• Individual assignment or class test: 50%
• Final exam: 50%
Benefits
• This is a 100% hands-on course; every student will have his or her own laptop/computer to work on.
• FREE retake for up to 9 months.
• Courses cover all required technique used in practical.
• Highly qualified Instructor and trainer.
• Great for beginners to intermediate users.
• Online courses are also available on demand.
Careers Opportunities
After Passing this course can consider career opportunities which includes positions such as:
• Office Assistant
• Asst Project Coordinator
• Virtual Assistant
• Administrator