[ux_slider] [ux_banner height=”545px” bg=”1191″ bg_size=”original”] [text_box text_color=”dark” width=”43″ width__sm=”90″ margin=”1px 1px 1px 1″ padding=”2px 20px 2px 20px” animate=”none” position_x=”0″ position_y=”100″ position_y__sm=”95″ text_align=”left” bg=”rgba(255, 255, 255, 0.94)” depth=”1″]

Microsoft Office

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.

[/text_box] [/ux_banner] [ux_banner height=”545px” bg=”1194″] [/ux_banner] [/ux_slider] [title style=”center” text=”Fees & Facts” tag_name=”h1″ color=”rgb(0, 109, 160)”] [section bg_color=”rgba(122, 156, 89, 0.16)” mask=”arrow”] [row style=”large” col_style=”divided” h_align=”center”] [col span=”3″] [featured_box img=”1213″ img_width=”74″ pos=”center” title=”Fees” margin=”1px 1px 1px 1″ icon_color=”rgb(0, 109, 160)”]

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

[/featured_box] [/col] [col span=”3″] [featured_box img=”1205″ pos=”center” title=”schedule” margin=”1px 1px 1px 1″]

• July 8, 2020
• September 16, 2020
• November 10, 2020

[/featured_box] [/col] [col span=”3″] [featured_box img=”1206″ img_width=”50″ pos=”center” title=”Duration” margin=”01px 1px 1px 1px”]

• Academic: 13 weeks in-class and 10 weeks practical Training.
• Total length: 6 Month including scheduled breaks.

[/featured_box] [/col] [col span=”3″] [featured_box img=”1207″ img_width=”67″ pos=”center” title=”Class Time:” margin=”1px 1px 1px 1″ icon_color=”rgb(0, 109, 160)”]

• Timing: 0830 – 1630 Hrs for Institute Students.
• Online Students: Day timing according to teacher/student schedule.

[/featured_box] [/col] [/row] [/section] [title style=”center” text=”Program Outcomes” tag_name=”h1″ color=”rgb(0, 109, 160)”] [section bg=”1201″ bg_size=”original” bg_overlay=”rgba(0,0,0,.5)” effect=”confetti” dark=”true” mask=”arrow” padding=”70px” border=”1px 1px 1px 1″ border_radius=”21″] [row style=”large” width=”full-width” v_align=”middle”] [col span=”6″ span__sm=”12″] [ux_image id=”7454″ depth=”2″] [/col] [col span=”6″ span__sm=”12″ divider=”0″ align=”left” bg_color=”rgb(0, 0, 0)” color=”light”]

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

[/col] [/row] [/section] [title style=”center” text=”Program Modules” tag_name=”h1″ color=”rgb(0, 109, 160)”] [section label=”Media Right” bg=”1202″ bg_size=”original” bg_overlay=”rgba(0, 0, 0, 0.6)” bg_pos=”0% 0%” dark=”true” mask=”arrow” padding=”1px” video_visibility=”visible”] [row style=”large” v_align=”middle”] [col span__sm=”12″ align=”left” bg_color=”rgba(0, 0, 0, 0.55)” color=”light”] [accordion] [accordion-item title=”Session 1″]

Section A: Introduction

• Course Opening

• How to Study for This Exam

[divider align=”left” width=”10000px” height=”2px” margin=”2px” color=”rgb(242, 197, 197)”]

Section B: Introduction to Access

• Database Definition

• Tour of Access

[divider align=”left” width=”10000px” height=”2px” margin=”2px” color=”rgb(242, 197, 197)”]

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

[divider align=”left” width=”10000px” height=”2px” margin=”2px” color=”rgb(242, 197, 197)”]

Section D: Rules of Databases

• Relational Database Definition

• Flat Database Problem

• Rules of Relational Table Design

• Planning a Database

[divider align=”left” width=”10000px” height=”2px” margin=”2px” color=”rgb(242, 197, 197)”]

Section E: Manage Relationships and Keys

• Create and Modify Relationships

• Set Primary Keys

• Referential Integrity and Foreign Keys

• View Relationships

[divider align=”left” width=”10000px” height=”2px” margin=”2px” color=”rgb(242, 197, 197)”]

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

[divider align=”left” width=”10000px” height=”2px” margin=”2px” color=”rgb(242, 197, 197)”]

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

[divider align=”left” width=”10000px” height=”2px” margin=”2px” color=”rgb(242, 197, 197)”]

Section H: Print and Export Data

• Print Reports

• Print Records

• Save a Database as a Template

• Export Data

[divider align=”left” width=”10000px” height=”2px” margin=”2px” color=”rgb(242, 197, 197)”]

Section I: Session 1 Recap

• Domain 1 Test Tips

[/accordion-item] [accordion-item title=”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

[divider align=”left” width=”10000px” height=”2px” margin=”2px” color=”rgb(242, 197, 197)”]

Section B: Manage Tables

• Hide Fields in Tables

• Add Total Rows

• Add Table Descriptions

• Rename Tables

[divider align=”left” width=”10000px” height=”2px” margin=”2px” color=”rgb(242, 197, 197)”]

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

[divider align=”left” width=”10000px” height=”2px” margin=”2px” color=”rgb(242, 197, 197)”]

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

[divider align=”left” width=”10000px” height=”2px” margin=”2px” color=”rgb(242, 197, 197)”]

Section E: Session 2 Recap

• Domain 2 Test Tips

[/accordion-item] [accordion-item title=”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

[divider align=”left” width=”10000px” height=”2px” margin=”2px” color=”rgb(242, 197, 197)”]

Section B: Modify a Query

• Rename a Query

• Add Fields

• Remove Fields, Hide Fields

• Sort Data Within Queries

• Format Fields Within Queries

[divider align=”left” width=”10000px” height=”2px” margin=”2px” color=”rgb(242, 197, 197)”]

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

[/accordion-item] [accordion-item title=”Session 4″]

Section A: Build Forms

• Create a Form

• Use Application Parts to Create a Form

• Save a Form

[divider align=”left” width=”10000px” height=”2px” margin=”2px” color=”rgb(242, 197, 197)”]

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

[divider align=”left” width=”10000px” height=”2px” margin=”2px” color=”rgb(242, 197, 197)”]

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

[divider align=”left” width=”10000px” height=”2px” margin=”2px” color=”rgb(242, 197, 197)”]

Section D: Session 4 Recap

• Domain 4 Test Tips

[/accordion-item] [accordion-item title=”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

[divider align=”left” width=”10000px” height=”2px” margin=”2px” color=”rgb(242, 197, 197)”]

Section B: Configure Report Controls

• Group and Sort Fields

• Modify Data Sources

• Add Report Controls

• Add and Modify Labels

[divider align=”left” width=”10000px” height=”2px” margin=”2px” color=”rgb(242, 197, 197)”]

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

[divider align=”left” width=”10000px” height=”2px” margin=”2px” color=”rgb(242, 197, 197)”]

Section D: Session 5 Recap

• Domain 5 Test Tips

• Conclusion

[/accordion-item] [/accordion] [/col] [/row] [/section] [title style=”center” text=”Other Program details” tag_name=”h1″ color=”rgb(0, 109, 160)”] [section bg_color=”rgba(122, 156, 89, 0.16)” mask=”arrow”] [row style=”large” col_style=”divided” h_align=”center”] [col span=”3″] [featured_box img=”1239″ img_width=”84″ pos=”center” title=”Admission Requirement” margin=”1px 1px 1px 1″ icon_color=”rgb(0, 109, 160)”]

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

[/featured_box] [/col] [col span=”3″] [featured_box img=”1241″ img_width=”72″ pos=”center” title=”Assessment Method” margin=”1px 1px 1px 1″]

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%

[/featured_box] [/col] [col span=”3″] [featured_box img=”1244″ img_width=”69″ pos=”center” title=”Benefits” margin=”01px 1px 1px 1px”]

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

[/featured_box] [/col] [col span=”3″] [featured_box img=”1245″ img_width=”110″ pos=”center” title=”Careers Opportunities” margin=”1px 1px 1px 1″ icon_color=”rgb(0, 109, 160)”]

After Passing this course can consider career opportunities which includes positions such as:

• Office Assistant
• Asst Project Coordinator
• Virtual Assistant
• Administrator

[/featured_box] [/col] [/row] [/section] [message_box bg_color=”rgba(122, 156, 89, 0.16)” padding=”12″] [row v_align=”middle”] [col span=”7″ span__sm=”12″]

Don’t Miss this opportunity

Apply Online

OR

Contact us for more information

[/col] [col span=”5″ span__sm=”12″ align=”right”] [button text=”Apply online” color=”alert” size=”larger” animate=”flipInY” link=”https://www.american-tech-institute.edu/apply-now/” target=”_blank”] [/col] [/row] [button text=”Contact us” color=”alert” size=”larger” animate=”flipInY” link=”https://www.american-tech-institute.edu/contact/” target=”_blank”] [/message_box]