Welcome, Guest

Access 2019 - Level 2 - Tables and Managing Access

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.