Access 2003 Level 1

Course

In Washington and Newcastle Upon Tyne

£ 295 + VAT

Description

  • Type

    Course

  • Level

    Beginner

This course is aimed at those who want to start making use of Access, to move from one level databases associated with holding data in Excel into the realms of multiple table relational databases. The course will cover all the basics of multiple table databases including the advantages and disadvantages. This course is a perfect starting point for a future in data manipulation.

Facilities

Location

Start date

Newcastle Upon Tyne (Tyne and Wear)
See map
Cuthbert House, City Road, Newcastle Upon Tyne, NE1 2ET

Start date

On request
Washington (Tyne and Wear)
See map
Suite 13, Vermont, House Concorde, NE37 2SQ

Start date

On request

Start date

On request

About this course

Delegates should have some working knowledge of Windows or should have completed the Introduction to Windows course. Delegates should feel at ease performing tasks such as arranging, sizing and switching between Windows. Previous use of a mouse is assumed on this 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

Course Overview

This course is aimed at those who want to start making use of Access, to move from one level databases associated with holding data in Excel into the realms of multiple table relational databases. The course will cover all the basics of multiple table databases including the advantages and disadvantages. This course is a perfect starting point for a future in data manipulation.

Prerequisites

  • Delegates should have some working knowledge of Windows or should have completed the Introduction to Windows course.
  • Delegates should feel at ease performing tasks such as arranging, sizing and switching between Windows.
  • Previous use of a mouse is assumed on this course.

Objectives

    Delegates will be able to :
  • Create, save and open existing databases on their systems.
  • Understand the principles around database design and why it is important to plan and prepare your database before entering any information.
  • Explain the advantages of using different data types within their database to change the way data can be input.
  • Create a form (on the pc) for users to enter data more easily.
  • Access information from the database by creating and saving queries within their database.
  • Produce accurate and informative as well as nicely presented formal reports for presentation purposes.

Follow on Courses

  • Access Level 2
  • Access Level 3

Training Options

  • Bespoke course (a course written to your specific needs) at your company office throughout the UK, at our training venue or at an independent location, convenient to you
  • Private course at your company office throughout the UK, at our training room or at an independent location, convenient to you
  • Scheduled public course at one of our training venues

Whats Included

  • 12 Months telephone and email support
  • Comprehensive colour course manual and exercises
  • Use of a Modern Training suite with 19 inch flat screen monitors
  • 1 delegate per computer
  • Relaxed refreshment area at our training room
  • Lunch (When at our training venue)
  • Refreshments (When at our training venue)

Course Content
Database theory

  • Explanation of the components that make up a database e.g. Tables, records, fields
  • What is a relational database?
  • Creating a database using the Database Wizards

Tables

  • Creating a single table database
  • Using data types, field properties, validation rules, captions, default values, fields required, field size, zero length and input masks using the wizard
  • Primary keys
  • Creating a multi-table database (relational database)
  • Creating links between tables
  • Working with referential integrity
  • Preventing data in one table being deleted when it has links to data in another table
  • Viewing and editing related data in a sub datasheet

Queries

  • Using queries in a database
  • Extracting information from a database using queries
  • Creating a query from single and multiple tables
  • Sorting the results of a query
  • Hiding fields in a query
  • Producing totals using a query
  • Producing calculations using a query

Forms

  • Using forms in a database
  • Viewing and changing data in a database using forms
  • Creating a form using the wizard
  • Modifying the layout of a form
  • Creating a form that refers to two or more tables

Reports

  • Extracting information and presenting it in a readable format
  • Creating reports from your database using the Report Wizard

Database normalisation

  • Designing tables in an efficient form to minimise data replication and ensure good database design. This section is not always covered due to time limitations. It is included as An introduction to the intermediate course. This section will be covered if time permits.

Access 2003 Level 1

£ 295 + VAT