Logo Picture

Tel: 0330 333 9 230 (Local Land Line Call Rate)

access intro

Access Introduction

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.

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

Course content

• 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

• 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

access intro2 Booking Form Online Enquiry

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)

ONSITE TRAINING

FROM

£650 + VAT