Access Introduction

ONSITE TRAINING

FROM
£650 + VAT

access intro

Duration: 1 day course

Venues: At your own offices or our luxury training venues in Cardiff, Newport (Nr Celtic Manor), Bristol or Swindon (Please state your choice of venue when booking)

This comprehensive course in Access teaches participants how to create and format a database. The course also looks into the planning and design considerations of creating a database. This 1-day Access Introduction course will assist delegates to develop their skills in designing, planning and creating a database from scratch.

access intro2

Who Should Attend

This course is designed for any delegates who want to improve their skills in creating, planning and designing a simple database from scratch.

Course content

• Input Masks and Validation Rules

• Lookup Fields

• Finding and replacing data

• Sorting and Filtering Table data

• Customising colours fonts and styles

• Creating a simple query

• Using criteria and multiple criteria in queries

• Sorting query results

• Changing print orientation

• Printing an individual record from a table

• What is a database

• Planning a database

• Creating and saving a new database

• Database Templates

• Creating and opening a Table

• Renaming a Table

• Formatting fields and attributes

• Saving a table

• Setting the primary key

• Add new fields and deleting fields

• Navigating a table in data view

• Entering data

• Editing and deleting records

• Resizing & changing the order of columns