MS Access 2016 Course - American Tech Institute
MS Access 2016 Course

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 & Facts

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.

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.
Program Modules

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

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

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

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

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
Other Program details

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

Don’t Miss this opportunity