Access Data Management

Training

In London

£ 220 + VAT

Description

  • Type

    Training

  • Location

    London

  • Duration

    1 Day

To give users an introduction to Access. Delegates will gain an understanding of some of the major features and functions within Access and the advantages of using a relational database running under Windows. Suitable for: This course is suitable for new, recent or intending users of Access who have little or no existing database knowledge.

Facilities

Location

Start date

London
See map
100a Chalk Farm Road, NW1 8EH

Start date

On request

About this course

A basic understanding of Windows is required, gained either by previous experience or by attendance on an Windows/Internet - Easy Start course.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

Delegate numbers are restricted to 8, to ensure personal attention from the trainer.
Access data management (introduction)

Course outlines

Introduction To Databasees

What is a Database?
Computerising a Database
Designing an Access Database
Defining a Data Store
Populating a Database
Extracting Information Form a Database
Reporting Data
Getting Started with Access
Starting Access
Access Opening Screen
The Title Bar
The Menu Bar
Toolbars
Menus and Submenus
Speedkeys
The Database Window
The Database Window Toolbar
Scroll Bars
Exciting Access
Getting Assistance with Access

Using the Office Assistant
Getting Help without the Office Assistant
Manipulating the Help Window
Help for Screen Objects – Screentips
Creating Tables and Adding Records
Creating a Table Using the Table Wizard
Datasheet View
Adding a Record
Saving Changes
Moving Around the Datasheet
Finding a Record
Modifying Records
Deleting a Record

Designing Table Structures
Table Design – Hints and Tips
Creating Tables
Switching Between Views
Saving Tables
Field Properties
Field Size Property

Working With Data
Sorting Data
Filtering Data
Simple Select Queries

What is a Query?
Creating a Query
Modifying a Query
Restricting Records Returned by a Query
Summary Queries
Forms

What is a Form?
Using Autoform to Design Forms
Using Wizards to Design Forms
Entering Data Using a Form
Simple Reports

Printing Form Datasheet View
Autoreports
Designing a Report Using Report
Wizards
Label Reports
Modifying Reports
Access Tools

Backing up and Restoring a Database
Compacting And Reparing A Database
Price: £220+VAT

Additional information

Support: Pass training may be able to help pay for individuals booking alone, or people on income support or other similar benefits. Discounts are also available to companies.
Payment options: All Courses can be held privately at our premises or otherwise.

Access Data Management

£ 220 + VAT