Access 2016 – Level 1 – Introduction and Basics – LearnOnline

Category:

Business/ Computing/ IT Training/ Online Course/ Part-time/ Self Study/

£20.00

Price £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.

Price £20.00