About the course

The Access 2019 - 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

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