Access Courses – LearnOnline

Access Courses – LearnOnline

Category:
Business / Computing / Microsoft Office Courses / Part-time / Self Study /
From: £20.00
Microsoft Office Access Business Training courses

From: £20.00

Overview

A range of Access courses varying from Level 1 – Level 5. Choose from either 2016 or 2019 versions.

Level 1 – Introduction & Basics (2 hours 30 minutes)
Level 2 – Tables & Managing Access (3 hours)
Level 3 – Queries & Records (2 hours 45 minutes)
Level 4 – Building Forms (3 hours 15 minutes)
Level 5 – Designing Reports (3 hours 30 minutes)

Level 1

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.

There are 6 modules in this course:

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.

Level 2

About the Course

The Access 2016 – 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.

There are 8 modules in this course:

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.

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.

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.

Level 3

About the Course

The Access 2016 – Queries and Records course covers topics included in the Microsoft Office Specialist (MOS) exam 77-730. You will learn how to create Select, Action, Crosstab, Parameter and Multiple table queries. You will also find records using various methods, apply filters and sort data.

There are 6 modules in this course:

Finding and Filtering Data

  • Find Text in Records;
  • Find Numbers in Records;
  • Find Dates in Records;
  • Replace Data;
  • Apply Filters;
  • Remove Filters;
  • Filter By Selection;
  • Use Filter By Form;
  • Close Forms

Sorting Records

  • Sort Records;
  • Sort Data in Tables;
  • Sort Data in Queries;
  • Sort Data in Forms.

Creating Basic Queries

  • Create Queries;
  • Add Fields to Queries;
  • Clear the Query Grid;
  • Show and Hide Fields;
  • Sort Fields in Queries;
  • Move Fields in Queries;
  • Run Queries;
  • Rename Queries;
  • Delete Queries.

Multiple Table Queries

  • Use Multiple Table Queries;
  • Join Tables in Queries;
  • Add Selection Criteria;
  • Use Logical Operators;
  • Modify Criteria;
  • Delete Criteria;
  • Create Parameter Queries;
  • Use Or and Like Operators;
  • Use Wildcards.

Additional Query Options

  • Use Grouping in Queries;
  • Remove Tables;
  • Join Tables in Queries;
  • Use the Expression Builder;
  • Enter Expressions Manually;
  • Create Top Values Queries;
  • Format Calculated Fields;
  • Rename Expressions;
  • Create Crosstab Queries.

Action Queries

  • Understand Action Queries;
  • Create Make Table Queries;
  • Create Update Queries;
  • Create Append Queries;
  • Modify Queries;
  • Create Delete Queries.

Level 4

About the Course

The Access 2016 – Building Forms course covers topics included in the Microsoft Office Specialist (MOS) exam 77-730. You will learn how to create and design forms by adding controls. You will also use navigation forms, sort records, apply filters, and set printing options.

There are 6 modules in this course:

Creating and Using Forms

  • Open Forms;
  • Create New Forms;
  • Add Fields to Forms;
  • Choose the Form Layout;
  • Navigate Forms;
  • Add New Records;
  • Enter and Modify Data;
  • Delete Records;
  • View Table Data

Modifying Forms and Controls

  • Use Form Design Tools;
  • Adjust the Size of Sections;
  • Work with Controls in Forms;
  • Change Label Names;
  • Add Existing Fields;
  • Insert Hyperlinks;
  • Change the Tab Order;
  • Save and Close Forms;
  • Delete Forms.

Creating Navigation Forms

  • Create Navigation Forms;
  • Edit the Header;
  • Add the Date and Time;
  • Add Images;
  • Save Navigation Forms;
  • Display Form as Default;
  • Modify Navigation Options;
  • Hide the Navigation Pane

Form Design and Formatting

  • Create Blank Forms;
  • Apply Themes;
  • Change Layouts;
  • Change the Field Order;
  • Add Margins to Controls;
  • Add Padding to Controls
  • Show and Hide Gridlines;
  • Format Controls;
  • Add Background Images.

Adding Controls to Forms

  • Create Combo Boxes;
  • Create List Boxes;
  • Modify Control Properties;
  • Create Option Group Controls;
  • Add Check Boxes;
  • Modify Data Sources;
  • Add Unbound Controls;
  • Add Images;
  • Delete Bound Controls.

Sorting, Filters and Printing

  • Sort Records;
  • Apply Filters;
  • Filter By Selection;
  • Apply Multiple Criteria;
  • Toggle Filters;
  • Print Preview Forms;
  • Change Page Orientation;
  • Adjust Margins;
  • Change the Paper Size

Level 5

About the Course

The Access 2016 – Designing Reports course covers topics included in the Microsoft Office Specialist (MOS) exam 77-730. You will learn how to create, design and modify controls in reports. You will also use calculated controls, use Find to locate data, sort records, and apply filters.

There are 6 modules in this course:

Using the Report Wizard

  • Generate Reports;
  • Add Fields to Reports;
  • Group Report Records;
  • Use Sort and Summary Options;
  • Modify Layout and Orientation;
  • Use Title and Display Options;
  • Create Automatic Reports;
  • Save and Close Reports;
  • Delete Reports.

Modifying Reports

  • Preview Reports;
  • Work with Layouts;
  • Move Controls;
  • Edit and Format Labels;
  • Apply Numeric Formatting;
  • Use Headers and Footers;
  • Add Images;
  • Add Subforms;
  • Add/Remove Sections.

Creating Reports in Design View

  • Create Reports in Design View;
  • Create Group Headers;
  • Concatenate Text Strings;
  • Manage Labels;
  • Sort and Group Controls;
  • Create Running Sums;
  • Add Date/Time Fields;
  • Add Page Numbers;
  • Print Preview Reports.

Using Calculated Controls

  • Use Calculated Controls;
  • Use the Count Function;
  • Join Queries;
  • Suppress Page Headers;
  • Use Mathematical Controls;
  • Use Percentage Controls;
  • Understand Logical Controls;
  • Apply Conditional Formatting;
  • View Conditional Formatting.

Blank Reports and Formatting Tools

  • Create Blank Reports;
  • Resize Controls;
  • Apply Themes;
  • Show/Hide Gridlines;
  • Change Padding and Margins;
  • Add Background Images;
  • Add Background Colours;
  • Use Page Setup;
  • Use Sizing & Ordering Controls.

Finding, Sorting and Filtering

  • Find Data in Reports;
  • Apply Filters;
  • Apply Sorting.

Course Features

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.

Entry Requirements

There are no entry requirements for this online course.

Equipment

Computer

Pentium-class PC or equivalent

Operating System

Windows 7, 8 or 10

Internet Browser

  • Internet Explorer 10, 11 or Microsoft Edge
  • Firefox
  • Chrome

Fees & Duration

Course fees are £20.00 per level

Enrolment duration is 6 months.

Please contact the LearnOnline team for more details

Phone: 01437 753 490

Email: online@pembrokeshire.ac.uk 

LearnOnline logo. Two shades of blue and the 'o' is the design of a globe
person smiling wearing a headset looking at a laptop