Access 2016 - Level 2 - Tables and Managing Access

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

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