Manchester Office Tel:  0161 408 0435

London OfficeTel: 0203 693 3945 

 

Microsoft Access Intermediate Training Course

Microsoft Access Training Courses

This Microsoft Access 2013 Intermediate training courses is intended to assist those who are familiar with the basics of Access to do more with their database. The course will also help more experienced users who have little to no experience with Access 2013 and the ribbon interface.  The Access 2013 Intermediate course will cover how to create and manage database files as well as how to link to additional database resources. It also covers tables, forms, reports, and queries in more depth. By the end of this Access 2013 intermediate training course, you will be able to create and manage small databases.

 
 

This course package includes free Training Needs Analysis (TNA) for Microsoft Access  using Gmetrix testing software to assess training  requirements. For more details, see our TNA page or call us 0161 408 0435.

 

 

Versions: 2007, 2010, 2013

 

Course Type: In- House, Instructor led.

 

Duration: 1 day

 

Certificate: Certificate of completion

 

 

Course Outline

 

1: Advanced File Tasks

Using Windows Explorer within Access

Navigating with Windows Explorer

Performing Basic Tasks with Windows Explorer

Changing Views in Windows Explorer

Using the Navigation Pane

Database Management

Compact and Repair a Database

Backing Up your Database

Editing Database Properties

Adding or Removing Database Passwords

Saving Your Files

Using the Save As Dialog

An Overview of Additional Database Formats

Packaging a Database

About AutoRecover

Exporting Files

Exporting to PDF or XPS

Exporting to Microsoft Office Word and Excel

Exporting to Other Destinations

Using Saved Exports

Packaging and Signing Data

Exporting to Older Versions of Access

Linking Files

Linking to a Microsoft Excel Spreadsheet

Linking to Another Database

Linking to a SharePoint Site

Other Types of Linked Documents

Creating Hyperlinks

 

2: Working with Tables

Customizing Tables

Understanding Field Properties

Adding a Primary Key

Indexing a Field

Inserting, Deleting, and Moving Fields

Adding Quick Start Elements

Importing a Table from another Source

Formatting Tables

Formatting Number Fields

Formatting Text Fields

Adding Field Descriptions

Changing Field Data Types

Adding Captions

Controlling Table Data Entry

Setting a Default Value

Setting a Required Value

Creating and Using Input Masks

Creating and Removing Table Relationships

Managing Table Data Entry

Using the Table Tools – Design Tab

Validating Data

Creating a Lookup Field

Modifying a Lookup Field

Creating a Value List

Modifying a Value List

 

3: Working with Forms

Basic Form Controls

Types of Forms

Types of Form Controls

Adding a Control

Using the Control Wizard

Cutting, Copying, Pasting, and Moving a Control

Formatting a Control

Advanced Form Controls

Modifying a Control’s Properties

Changing a Control’s Data Source

Changing a Control’s Default Value

Creating a Calculated Control

Using Form Properties

Formatting Your Form

Formatting Gridlines

Modifying the Font

Adding Logos

Changing the Layout

Formatting Controls

Changing the Color of a Control

Using Control Properties

Aligning and Sizing Controls

Applying Special Effects

Using Themes

Using Themes

Modifying Fonts

Modifying Colors

Saving Customized Themes

 

 4: Working with Reports

 Organizing Report Data

 Adding and Removing Fields

 Using Report Sections

 Changing Properties

 Grouping and Sorting in a Report

 Doing More with Grouping and Sorting

 Using Calculated Controls in a Report

 Formatting Reports

 Formatting Gridlines

 Modifying the Font

 Adding Logos

 Changing the Layout

 Using Themes

 Common Report Tasks

 Adding a Photo

 Adjusting Page Properties

 Adding Page Numbers

 Using the Label Wizard

 Adding Conditional Formatting

 

 5: Working with Queries

 Basic Queries

 Review of Queries

 Creating a Query

 Sorting a Query 

 Filtering a Query

 Showing and Hiding Fields

 Doing More with Queries

 Using AND/OR Operators

 About IIF Functions

 Creating Multiple Table Queries

 Creating a Calculated Field

 About the Expression Builder

 Using Queries to Summarize Data

 Creating Advanced Queries

 Creating a Parameter Query

 Using Parameter Queries

 Creating Crosstab Queries

 Using Crosstab Queries

 Using Make-Table Queries

 Creating Management (Action) Queries

 Append Queries

 Delete Queries

 Update Queries

 Exporting Queries

 

Related Courses

In House Training Courses

Microsoft Access Advanced Training Course

In this advanced Microsoft Access 2013 training course, will learn how to manage data by managing relationships and dependencies, enforce referential integrity. You will learn to insert application...

Microsoft Access Introduction Training Course

On this Microsoft Access training course you will learn basic functions and features of Microsoft Access . You will learn to create databases, work with tables, fields, and records, sort and filter...