Access 2013 - Level 2 - Tables and Managing Access

About the course

The Access 2013 - Tables and Managing Access course is part of the MOS exam 77-424 range. 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

Modules

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;