MS Access 2007 Introduction Training Course in London

Our MS Access 2007 Introduction course is aimed at novice users who are really complete beginners in using the Application. Our aim is to build a strong foundation in Access to provide new users with a good understanding of the basic concepts of Microsoft Access.

Our accessible but thorough approach to your training is designed to take you through the fundamentals principles of Access and leave you with a functional knowledge of the necessary skills for today’s workplace.

Unlike training companies offering scheduled courses, we offer the alternative of your Microsoft Access Training Course delivered in central London on a date of your choice, either onsite or at our offices near Moorgate, Bank or Liverpool Street either 1 to 1 or as part of a group.

Microsoft Access 2007 Introduction Course

Audience: This course is designed for new Access users, or self taught users. The course will cover all aspects of database design and objects.

Access 2007 Introduction Course Objectives: After the course, you will be able to:

Understand Database Concepts and Objects
Create, Edit and Maintain Tables
Create Queries
Create Forms
Create Reports
Create Relational Tables, Forms, Queries and Reports

Requirements: No previous experience of Access is required to attend this course. You must have good basic Windows skills, e.g. Mouse and Keyboard

Course Duration

This is a 2 day Access 2007 beginners training course. The course starts at 09:30 and runs until 16:30

Course Locations / Schedule

This Access 2007 introduction course can be run Onsite, at our Access training centre or any preferred location in the UK. The course is run on a date that suits you! We do not run public scheduled courses.

Access 2007 Introduction / Beginners Training Course Contents

Database Overview / Terms / Planning

An overview of databases, database objects and terminology
Tables, Queries, Forms, Reports, Macros, Pages and Modules
Planning a database structure and tables
Creating a new database

Working with Tables

Designing a Table, Rules for entering Field Names
Enter data types, field descriptions
Setting a Primary Key and Setting Multiple Primary Keys
Removing a Primary Key
Defining Field Properties(Default values, Input masks, Validation rules and text,
Insert, Delete, Move and Rename Fields
Table Wizards

Entering and Editing Data

Switching Views in Access
Entering and Editing Data
Working in Data Entry Mode
Sorting Data, Finding & Replacing Data
Hiding and Unhiding Fields

Importing & Linking Data

Importing from Access and Excel
Linking to an external Access Database Table
Linking to an Excel Workbook using the Wizard
Renaming and Copying Tables

Queries and Filters

Create a filter by selection
Create a filter by form
Save a filter by form as a select query
Running a Select Query
The Query Design Window
Creating a query from the query window
Adding fields to a query, Display/Suppress the display of a field
Removing fields from a query
Specifying Text, numeric, date, and logic criteria
Specifying sub string searches using wild Card Characters
Working with Conditions - BETWEEN, AND, OR, NOT, NULL
Calculated fields

Relationships

Why create relationships between tables?
Different types of relationships
Conditions for setting up a relationship
Referential Integrity
Cascade Update
Cascade Delete
Relationships Report
Inserting Subdatasheets
Removing Subdatasheets
Expanding and Contracting Subdatasheets

Multi Table Queries

Multiple Table Queries
Joining Tables for a query
Join Properties - Inner and Outer Joins
Find Unmatched Query Wizard
Find Duplicates Query Wizard

Creating Forms

Creating Forms using the Auto Form Tabular/Datasheet/Pivot Form wizard
Creating Forms Using the Form Wizard
Data Entry in Forms
Resizing and Moving Controls
Changing Text Attributes
Resizing Forms
The Field List Box
Selecting Controls
Formatting Controls
Format Painter and AutoFormat
Resizing and Moving Controls
Properties of an item

Reports

Standard Reports using Wizard
Inserting, Moving, Sizing, deleting controls
Customising Reports
Grouping Data
Using Expressions
Mailing Labels
Page setup