Microsoft Access Introduction (Level 1) 2003 2007 2010 2013 2016 & 365

Training

In Newcastle Upon Tyne

£ 165 VAT exempt

Description

  • Type

    Training

  • Level

    Beginner

  • Location

    Newcastle upon tyne

  • Duration

    1 Day

Individuals are introduced to the concepts of Microsoft Access by completing this one day course. Topics include tables, queries, forms and reports in a Microsoft Access Database.

Important information

Documents

  • Course content

Facilities

Location

Start date

Newcastle Upon Tyne (Tyne and Wear)
See map
The Quadrus Centre, Woodstock Way, Boldon, NE35 9PF

Start date

On request

About this course

Learn all the functions that Microsoft Access has to offer at introductory level.

The course is intended for individuals who have a basic knowledge of Windows but very little or no experience of Microsoft Access.

A basic knowledge of Windows is required but no experience of the Microsoft Access database application is necessary.

Certificate of participation can be obtained if required.

On receiving your request we will contact you to explain course content, including course dates and payment options.

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

Subjects

  • Access
  • Database
  • Database training
  • Design
  • Microsoft Access
  • Edit Data
  • Create database
  • Table design
  • Datasheet
  • Access Toolbar

Teachers and trainers (1)

Chris Edmondson

Chris Edmondson

IT Trainer

Course programme

Course review:

1 Navigating and Controlling Microsoft Access

2 Database Creation

  • Database Terminology Explained
  • Designing a Table
  • The Table Design Window
  • Field Properties and Data Types
  • Setting a Primary Key
  • Saving the Table Design

3 Adding and Editing Data

  • Working in a Datasheet
  • Adding new records
  • Deleting existing records
  • How the application saves data
  • Explanation of the Undo feature

4 Working with Access

  • Creating a new Database
  • Opening a Database
  • Switching between objects

5 Altering the Table Design

  • Rearranging Fields
  • Inserting & Deleting Fields
  • Changing Field length
  • Changing Field type

6 Working in a Datasheet

  • Font and Cell effects
  • Column Width & Row Height
  • Hiding & Freezing Columns

7 Simple Queries

  • Designing a Query
  • The Query Design Window
  • Placing Fields in the Grid
  • Selecting Records with criteria
  • Saving and Running the Query

8 More Query Features

  • Calculating Data during a Query
  • Sorting into various orders
  • Totalling in a Query

9 Forms Design

  • Creating Forms with a Wizard
  • The Forms Design Window
  • Moving Controls and Labels
  • Formatting and Aligning Objects
  • Saving and Using the Form

10 Report Design

  • Creating Reports with a Wizard
  • The Report Design Window
  • Understanding Report Sections
  • Saving and Running Reports

Microsoft Access Introduction (Level 1) 2003 2007 2010 2013 2016 & 365

£ 165 VAT exempt