Access 2016 - Level 2 - Tables and Managing Access eLearning Course

Return to category list

Overview

The Access 2016 - Tables and Managing Access course covers topics included in the Microsoft Office Specialist (MOS) exam 77-730. You will manage databases, perform Backups and Split databases. You will also build and design tables, import data, create relationships, and modify options.

About the course

The Access 2016 - Tables and Managing Access course covers topics included in the Microsoft Office Specialist (MOS) exam 77-730. You will manage databases, perform Backups and Split databases. You will also build and design tables, import data, create relationships, and modify options.

Modules

There are 8 modules in this course

  • Managing Databases
  • Application Parts
  • Backup and Splitting Databases
  • Table Basics
  • Table Design
  • Table Relationships
  • Importing Data
  • Modifying Options

Course features

  • Simulation training replicates the software you are learning providing a realistic learning experience.
  • Learn how to perform tasks at your own pace and interactively by following easy step-by-step actions.
  • Reinforce your knowledge at the end of each lesson by completing interactive and multiple choice quiz questions.
  • Assess your skills at any time by undertaking the Course Test.
  • Lessons can be completed within 30 minutes so training can be undertaken in ?bite? size pieces.
  • Bookmarking allows you to learn in multiple training sessions.
  • Course navigation features allow you to jump directly to specific topics of interest quickly and easily.
  • Designed for people who require initial and refresher training activities.
  • Available on-line 24 hours a day.
  • Version for Mobile Devices.
  • Review course content with eBooks

You?ll learn how to:

Managing the Access Environment
Managing Databases

  • Open Databases;
  • Use the Navigation Pane;
  • Copy Databases Objects;
  • Add Table Descriptions;
  • Rename Database Objects;
  • Delete Database Objects;
  • Use Compact & Repair;
  • Apply Password Protection

Application Parts

  • Understand Application Parts;
  • Save a Database as a Template;
  • Create Application Parts;
  • Use the Application List;
  • Use Quick Start options;
  • Use Blank Forms;
  • Save Databases

Backup and Splitting Databases

  • Backup Databases;
  • Save to OneDrive;
  • Restore Backups;
  • Import Database Objects;
  • Save for Backward Compatibility;
  • Split Databases;
  • Link to Databases.

Building Tables
Table Basics

  • Create Tables in Design View;
  • Add and Edit Fields;
  • View and Set Field Properties;
  • Add New Records;
  • Modify and Delete Records;
  • Hide and Unhide Fields;
  • Freeze Fields;
  • Add Total Rows;
  • Delete Tables.

Table Design

  • Understand Field Properties;
  • Change Field Names;
  • Modify Field Properties;
  • Set Validation Rules;
  • Index Fields;
  • Set Primary Key Fields;
  • Modify Field Order;
  • Save Design Changes;
  • Modify Column Widths.

Table Relationships

  • Use the Relationships Window;
  • Create Relationships;
  • Select Tables;
  • Understand Referential Integrity;
  • Edit Relationships;
  • Remove Relationships;
  • Hide/Show Tables;
  • Use Many-to-Many Relationships;
  • Create Link Tables.

Importing Data

  • Import Data into Access;
  • Use Import Options;
  • Import from Access Database;
  • Import from Excel Spreadsheet;
  • Append Imported Data;
  • Create Linked Tables;
  • Update Linked Tables.

Access Options
Modifying Options

  • Modify General Options;
  • Use Current Database Options;
  • Set Datasheet Options;
  • Use Object Designer Options;
  • Set Proofing Options;
  • Modify Language Options;
  • Use Client Settings Options;
  • Customize the Ribbons;
  • Modify the QAT.
Language
UK
Date last updated
3/27/2018
Duration
3 Hours
Suitable Devices
  • PC
  • Phone
  • Tablet
Audio is Required
  • Yes
Includes Video
  • No
Downloadable Resources
  • eBook
  • Hints and Tips
Completion Criteria
  • Multiple Choice Assessment
Pass Mark
  • 70% pass mark required
Course Technology
  • HTML5
  • SCORM 1.2
Languages
  • English
Accreditation or Endorsements
  • No
Customisation Available
  • No

This course has a minimum of 25 learner registrations for us to provide a quotation.

Request a quote

Cookies

We use cookies to help make our site easier and better for you. We'd appreciate a quick Accept please, to help us continue these efforts.

You can check out the full details in the Privacy Policy.

Saving, please wait...

Your preferences are being saved. This page will reload with your chosen preference.