Microsoft Access 2016

COURSE LENGTH

6 Months

Course Description:

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.

What can you achieve as a MS Access Specialist?

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

  • Office Assistant

  • Asst Project Coordinator

  • Virtual Assistant

  • Administrator

Here’s what you will learn

Course Details

Session 1

  • Course Opening
  • How to Study for This Exam

  • Database Definition
  • Tour of Access

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

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

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

  • 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

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

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

  • Domain 1 Test Tips

Session 2

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

 

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

    • Update Records
    • Add and Delete Records
    • Append Records from External Data
    • Find and Replace Data
    • Sort Records
    • Filter Records

    • 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

    • Domain 2 Test Tips

Session 3

    • 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

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

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

Session 4

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

      • Move Form Controls
      • Add Form Controls
      • Modify Data Sources
      • Remove Form Controls
      • Set Form Control Properties
      • Manage Labels
      • Add Subforms

      • 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

  • Domain 4 Test Tips

Session 5

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

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

  • 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

    • Domain 5 Test Tips
    • Conclusion

Fees & Facts

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

July 8, 2020

September 16, 2020

November 10, 2020

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

Total length: 6 Month including scheduled breaks.

Timing: 0830 – 1630 Hrs for Institute Students.

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

Program Outcomes

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

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) 

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%

Take the First Step to
Secure Your Future

Speak with an Enrollment Counsellor today

Shopping Basket