Access 2013 - Level 1 - Introduction and Basics

About the course

The Access 2013 - Introduction and Basics course is part of the MOS exam 77-424 range. You will learn about database fundamentals, screen components and templates. You will also preview and print database objects and Export data to other file formats.

Modules

There are 6 modules in this course

  • Starting Access and Help
  • Screen Components
  • Database Basics
  • Using Templates
  • Previewing and Printing
  • Exporting Data

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

Introducing Access 2013
Starting Access and Help

  • Understand Databases;
  • Start Access;
  • Preview Templates;
  • Create a Blank Database;
  • Navigate Help;
  • Use Help Tools;
  • Search On-line Help;
  • Quit Access;

Screen Components

  • Identify Screen Components;
  • List Database Objects;
  • Open Database Objects;
  • Open Backstage View;
  • Pin Databases to the List;
  • Understand Ribbons;
  • Use Dialog Box Launchers;
  • Open Task Panes;
  • Modify the Quick Access Toolbar;

Database Fundamentals
Database Basics

  • Open and View Tables;
  • Set Data Types;
  • Use Primary Keys;
  • Index Fields;
  • Utilise Table Relationships;
  • Understand Referential Integrity;
  • Open Queries;
  • Open and View Forms;
  • Open and View Reports;

Using Templates

  • Search for Templates;
  • Apply Filters;
  • Remove Filters;
  • Perform Keyword Searches;
  • Preview Templates;
  • Create Databases;
  • View Database Objects;
  • Enter Data in Tables;
  • Delete Databases;

Printing and Exporting
Previewing and Printing

  • Preview Datasheets;
  • Print Datasheets;
  • Print Subdatasheets;
  • Print Selected Records;
  • Preview Reports;
  • Change the Page Setup;
  • Print Reports;
  • Print Query Output;
  • Print Forms;

Exporting Data

  • Export Database Objects;
  • Use Export Options;
  • Export to Access Database;
  • Export to Excel;
  • Save Exported Files;
  • Export to XML;
  • Export to PDF;
  • Export to Text File;
  • View Exported Files;