About the course

The Access 2021 - Tables and Managing Access course covers topics included in the Microsoft Office Specialist (MOS) exam. 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

• Managing a Database;
• Opening Databases;
• Navigation Pane;
• Save Object As Command;
• Adding Table Descriptions;
• Renaming Objects;
• Deleting Objects;
• Navigation Pane Options;
• Compact and Repair Databases;
• Protect Databases.

Application Parts

• Application Parts;
• Saving Database as a Template;
• Creating Application Parts;
• Using Application Parts;
• Quick Start options;
• Blank Forms;
• Saving Databases.

Backup and Splitting Databases

• Database Backup;
• Saving to OneDrive;
• Restoring Backups;
• Importing Database Objects;
• Saving for Backward Compatibility;
• Splitting Databases;
• Linking to Databases.

Building Tables
Table Basics

• Creating Tables in Design View;
• Adding Fields;
• Editing Fields;
• Deleting Fields;
• Viewing Field Properties;
• Setting Field Properties;
• Adding Table Data;
• Adding New Records;
• Deleting Records;
• Modify Table Data;
• Deleting Table Data;
• Navigation Buttons;
• Hiding/Unhiding Fields;
• Freezing Fields;
• Adding Total Rows;
• Deleting Tables.

Table Design

• Modifying the Table Design;
• Field Names;
• Field Size Property;
• Number Property;
• Decimal Places Property;
• Format Property;
• Smart Tags;
• Show Date Picker;
• Input Mask Property;
• Caption Property;
• Validation Rules;
• Required and Allow Zero Length;
• Indexing Fields
• Setting a Primary Key;
• Changing Field Order;
• Saving Design Changes;
• Adjusting Column Widths.

Table Relationships

• Table Relationships;
• Selecting the Tables;
• Creating Relationships;
• Referential Integrity;
• Relationship Line;
• Editing Relationships;
• One to One Relationships;
• Removing Relationships;
• Hiding/Showing Tables;
• Many-to-Many Relationships;
• Creating Link Tables

Importing Data

• Importing Data into Access;
• Import Options;
• Importing from Access Database;
• Appending Imported Data;
• Importing from Excel Spreadsheet;
• Creating Linked Tables;
• Updating Linked Tables

Access Options
Modifying Options

• Access Options;
• General Options;
• Current Database Options;
• Datasheet Options;
• Object Designer Options;
• Proofing Options;
• Language Options;
• Client Settings Options;
• Customize Ribbon Options;
• Quick Access Toolbar Options.