Homepage › IT, Computing, Telecommunications Courses › Database Administration Courses › Access Courses

Introduction to Microsoft Access Training Course

in Mouse Training (England)

Classes Course

Place:

London

Duration:

2 Days

Start:

consult dates and times
See course programme

Course objectives:

Access Course Objectives -To understand the concept and purpose of a database and to gain a good working knowledge of Access to be able to create and edit Access databases.

Mouse Training

Contact course provider

Request information

Contact directly and with no obligation with

Mouse Training

You must complete all fields on this form in order for us to send it to the course provider.
We have highlighted incomplete/ incorrect details in red.

* Compulsory fields

*Name *Surname

*E-mail

*Country/ region *Area/ County

*I would like more information on

By clicking "Email request / Telephone" you registering and accepting the Terms of Use and privacy policy of Emagister.

I wish to receive the personalised newsletter (during a maximum period of 15 days)

Availability?
How do I enrol?
Where can I get more information?

The person in charge of this course will receive your information request instantly.

Response time:

:| :) ;)

Average Fast Very fast

Course details

Type Course Duration 2 Days

Method / place Contact course provider Classes in London where

Course objectives Access Course Objectives -To understand the concept and purpose of a database and to gain a good working knowledge of Access to be able to create and edit Access databases.

Get direct information on how to enrol, venues and availability...

Access courses (from other course providers)

Access Database Design 2
Pass training
London - £220 + VAT

Introduction to Microsoft Access
Reed Learning
London - £495 + VAT

Access Introduction
Major Training Ltd
London - £220 + VAT

Access 2003 Specialised
2e2 Training
London - £450 + VAT

Microsoft Access 2007 Level 2
WWP Training Limited
London - £450 + VAT

Compare the selected courses

+ access Courses + Access Courses in London + Courses in London + Mouse Training Courses

Course programme

Introduction to Microsoft Access Training Course

Microsoft Access Training Course Levels and Course Contents

Duration - This is a 2 day course starting at 09:30 until 16:30 each day
Access Course Objectives -To understand the concept and purpose of a database and to gain a good working knowledge of Access to be able to create and edit Access databases.

Screen Layout

Navigating Microsoft Access

Access Overview

Database Container
Tables
Queries
Forms
Reports
Macros
Pages
Modules
Grouping Favourites

Planning a Database

Designing a Database
Normalisation
Relational Databases

Creating Tables

Create a Database
Designing a Table
Rules for entering Field Names
Enter data types, field descriptions
Setting a Primary Key
Setting Multiple Primary Keys
Removing a Primary Key

Table Properties and Structure

Defining Field Properties
Working with Input masks
The Input Mask Wizard
Validation Rule
Validation text
Other field Properties
Insert fields
Delete fields
Move Fields
Rename Fields
Table Wizards

Entering and Editing Data

Switching Views in Access
Enter data into a table
Modify data in a table
Working in Data Entry Mode
Sorting Data
Finding & Replacing Data
Hiding and Unhiding Fields

Importing and 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

Using Filters and Select Queries

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

see the full course programme

on request

get more information on the programme directly from Mouse Training.

Request information for free

Get direct information on how to enrol, venues and availability...

Venues and dates


Where	London, 7th Floor Crystal Gate 28-30 Worship Street see map
When	Start: Ask the course provider

Get direct information on how to enrol, venues and availability...

Ex-students

Opinions

Have you attended this course?

Voice your opinion and help thousands of other users

Get direct information on how to enrol, venues and availability...

On Mouse Training

Provider description

Mouse Training - London & the UK's Premier Training Course Provider
We are a London City based training company, providing instructor led, quality training either at our fully equipped training centre near Moorgate, Bank or Liverpool Street or at your offices. Our flexible approach to training means our comprehensive list of IT training courses can be tailored to suit your training needs. When booking, we will provide a full, free training needs analysis to ensure you get the most from your investment.