e-academy – IT training excellence in Cardiff, Newport, Bristol and South Wales

Course details
Fee £230
Days 2
Code AC1

There are currently no dates scheduled for this course.

However it can still be provided on a closed-company basis – or we may schedule it on demand. Please contact us for further information.

e-mail us
or call us on
0845 650 6500

Access Introduction

The Access Introduction training course is available at our Cardiff training centre in Wales, which is also within easy reach of Newport, Bristol and South WalesMicrosoft Certified Gold Partner for Learning Solutions

Overview

This course introduces the skills necessary for setting up and using database tables in Access. It includes tasks to get started; create, edit, and work with tables; and set field properties. Students will also learn how to find, filter, and print data and use the Office Assistant

Examination information

  • This course helps prepare delegates for the ECDL Module 5 - Databases examination and the Microsoft Office Specialist Access Proficient examination

Prerequisites

Before attending this course, students must have:

  • Knowledge and experience of using a Windows environment

Course outline

Module 1 - Exploring Access

  • Starting Access
  • Using the Interface
  • Opening an Existing Database
  • Using Database Objects

Module 2 - Creating Tables

  • Creating a New Database
  • Designing Tables
  • Adding Field Names
  • Assigning Data Types
  • Setting a Primary Key

Module 3 - Working with Tables

  • Navigating Fields in Tables
  • Adding Records
  • Editing Records
  • Saving Records

Module 4 - Editing Tables

  • Changing the Row/Column Height
  • Hiding a Column
  • Freezing a Column

Module 5 - Finding and Filtering Data

  • Finding Specific Records
  • Using Replace
  • Using Filter By Selection
  • Applying/Removing a Filter

Module 6 - Printing Data

  • Printing Table Data
  • Changing the Page Setup
  • Using Print Preview

Module 7 - Creating Relationships

  • Using Related Tables
  • Creating a Relationship between Tables
  • Setting Referential Integrity
  • Viewing Subdatasheets

Module 8 - Using Simple Queries

  • Creating a Query in Design View
  • Opening a Query
  • Adding a Table to a Query
  • Joining Tables in a Query
  • Running a Query

Module 9 - Modifying Query Results

  • Sorting a Query
  • Adding Criteria to a Query

Module 10 - Analysing Tables

  • Analysing a Table
  • Using Relationships in Splits
  • Using the Table Analyser Wizard

Module 11 - Creating Basic Forms

  • Viewing Records in a Form
  • Printing Records in a Form
  • Basing a Form on a Query
  • Using AutoForm

Module 12 - Creating Basic Reports

  • Using the Report Wizard
  • Using Print Preview - Reports
  • Grouping and Summarizing Report Data
  • Using AutoReport

Module 13 - Modifying Tables

  • Inserting a Column into a Table
  • Inserting a Lookup Column
  • Inserting a Hyperlink Column

Module 14 - Setting Field Properties

  • Using Field Properties
  • Limiting Field Size
  • Setting Formats
  • Setting Validation Rules
  • Creating an Input Mask - Wizard

Module 15 - Using Operators in Queries

  • Using Comparison Operators
  • Using the Between And Operator
  • Using the Expression Builder

Module 16 - Designing Advanced Queries

  • Creating a Calculated Field
  • Creating a Function Query
  • Creating a Parameter Query
  • Creating a Concatenation in a Query

Module 17 - Creating Action Queries

  • Creating a Make-table Query
  • Creating an Update Query
  • Creating an Append Query
  • Creating a Delete Query

Module 18 - Using Advanced Query Wizards

  • Using the Crosstab Query Wizard
  • Using the Find Duplicates Query Wizard

Module 19 - Using Advanced Database Features

  • Importing Data
  • Linking Data to an Access Table
  • Exporting Data
  • Creating a Data Access Page - Page Wizard
  • Compacting a Database

Module 20 - Manipulating Controls

  • Using Controls
  • Moving Controls
  • Viewing the Properties of an Object
  • Changing a Control Property

Module 21 - Using Design View

  • Adding a Field
  • Moving Part of a Paired Control
  • Using the Toolbox
  • Adding a Label
  • Adding an Image

Module 22 - Using Advanced Form Design

  • Using Forms in Design View
  • Creating a Combo Box
  • Creating an Option Group
  • Adding a Logic Control

Module 23 - Using Advanced Report Design

  • Adding Report Sections in Design View
  • Creating a Calculated Control
  • Grouping Data in a Report
  • Creating Group Headers and Footers
  • Creating a Running Summary

Module 24 - Using Editing Tools

  • Selecting Objects with the Toolbar
  • Changing the Font
  • Applying Special Effects
  • Using Error Checking
  • Using Smart Tags