Microsoft Access 2013 or 2016 - Level 1 - Beginner

Office Applications/Productivity
Schedules
  12/26/17 - 9-5pm PST Glendale - CA
Delivery Type (Must Select One)
  Instructor-Led
  Online Live Instructor-Led
Version (Must Select One)
  2013
  2016
Optional
  Certiport Test with Proctor Fee ($126.00)
  Certiport Test with 1 Retake / Proctor Fee ($145.00)
  LearnITAnytime Online Subscription (1 Year Subscription - $195.00)
  IT Online Library (1 Year Subscription - $1595.00)
  Private Mentoring 3 Hours ($125)
Quantity
If quantity is more than 1, Please add all Attendees' Names /Voucher #/ Learning Credit below separated with a comma. If not specified, we will contact you prior to the class start date. Special Instructions

 

This hands-on beginners course is suitable for Access 2010/2013/2016 users.
Live face-to-face instructor-led training. No minimum class size - all classes guaranteed to run.
You will learn the skills necessary to create a new database, construct data tables, design basic forms and reports, run queries and secure your data.


Opening and Closing Access
  • Opening Access
  • Using the Recent List and Opening Files
  • Understanding Security Warnings
  • Understanding the Ribbon and the Status Bar
  • About Your Account
  • Closing Files vs. Closing Access

An Introduction to Databases
  • About Common Database Terms
  • Using the Navigation Pane
  • Understanding Tables and Table Relationships
  • Understanding Queries
  • Understanding Forms
  • Understanding Reports
  • Closing Database Objects

An Introduction to Desktop Databases
  • Opening a Table in Data Sheet View
  • About Keys
  • About Data Types
  • Entering and Editing Data
  • Selecting Records
  • Deleting Records
  • About Fields

Understanding Basic Table Tasks
  • Entering a New Record
  • Saving Records
  • Using the Clipboard
  • Formatting Text
  • Adding a Field by Entering Data

Working With Fields
  • Adding a Specific Type of Field
  • Changing Field Name, Caption, or Description
  • Changing the Data Type
  • Changing Field Format
  • Deleting a Field

Navigating Records
  • Filtering Records
  • Sorting Records
  • Searching for Records Using the Search Box
  • Finding and Replacing Text
  • Navigating Records

An Introduction to Queries, Forms, and Reports
  • Types of Queries
  • Creating a Query with the Wizard
  • Executing a Query
  • About the Different Form Views
  • Viewing a Report
  • Using Print Preview

Protecting Your Data
  • Planning Backups
  • Backing Up a Database
  • Restoring a Database
  • Restoring Objects in a Database



Our outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class.


 

Certificate of Course Completion


 

This hands-on beginners course is suitable for Access 2010/2013/2016 users.


 

Previous Windows experience recommended


 

You may cancel this class 10 or more business days prior to the start date of the class for a full refund. No shows or cancellations made within 10 days will forfeit all fees paid.