Access 2016 – Level 1 – Introduction and Basics – LearnOnline

Access 2016 – Level 1 – Introduction and Basics – LearnOnline

Category:
Business/ Computing/ IT Training/ Online Course/ Part-time/ Self Study/
£20.00
Microsoft_Access_2013_logo.svg_-850×400

£20.00

About the Course

The Access 2016 – Introduction and Basics course covers topics included in the Microsoft Office Specialist (MOS) exam 77-730. 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

Learning Core

Starting Access and Help

  • Understand Databases;
  • Start Access;
  • Preview Templates;
  • Create a Blank Database;
  • Navigate Help;
  • Use Help Tools;
  • Search Online 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 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.

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.

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

Entry Requirements

There are no entry requirements for this online course.

Equipment

To access this course, we recommend that you use a Windows PC running Windows 7, 8,10 and use Internet Explorer 10 or 11 as your web browser.

This course will not work on Apple Macintosh computer.

Fees & Duration

Course fees are £20.00

Enrolment duration is 6 months

Hours of training is 4 hours and 30 minutes

Please contact the Pembrokeshire College Online Team on 01437 753 191 for more details on this course.