>

Access Training for New Users

microsoft access training from taylor mason trainingAccess Training

New Users

This 2 day Access training enables you to create a fully workable database for your organisation.Taking you through the application step by step the course teaches you to create the database, add fields, import data in to the database and create queries and reports to use the data in your database succesfully. 

Once you are able to utilise the application you can follow on the advanced access course, enahcing and improving your skills and your database.

Please let us know which version of Microsoft Office you are using when booking, we can train 2000 / 2003 / 2007 / 2010 applications. We also have 10 v2007/10 laptops available if you require them, no charge for their use.

What you learn:

The current outline for the access training for new users course enables you to:

  • Have a good working knowledge of Microsoft Access.
  • Be able to create a database from scratch.
  • Understanding and use tables, fields and records and the rules for entering data
  • Create simple queries, use forms and, ultimately create reports
  • Understand relational databases and be able to work with related tables

During the course you cover:

During this access training course, you learn about:

Database Concepts:

  • Database concepts and terminology
  • Exploring the Access environment
  • Planning and designing databases
  • Getting help
  • Closing a database and Access

Access Basics:

  • Exploring tables
  • Examining queries
  • Exploring reports

Creating Databases:

  • Creating a database
  • Using the table wizard
  • Working in design view

Working with Fields and Records:

  • Changing the design of a table
  • Adding and deleting records
  • Finding and editing records
  • Sorting and filtering records

Querying Tables:

  • Creating and using queries
  • Modifying query results and queries
  • Using calculations in queries

Creating and Using Forms:

  • Creating forms by using AutoForm
  • Using the form wizard
  • Using design view
  • Finding, sorting and filtering records

Creating and Using Reports:

  • Using the report wizard and queries
  • Creating, modifying and printing reports

Importing, Exporting and Linking Objects:

  • Importing Access objects
  • Exporting Access objects
  • Linking Access objects

Day 2

Creating relational databases:access database training

  • Database normalising
  • Introducing relating tables
  • Adding referential integrity

Working with related tables:

  • The lookup wizard
  • Changing lookup fields
  • Inputting data to related tables

Defining data entry rules;

  • Using input masks
  • Setting a property
  • Setting a validation rule

Using advanced query features:

  • How to join a table in queries
  • Creating a calculated field
  • Using an action query

Creating advanced queries:

  • Summarise and group values
  • Create a crosstab query
  • Using a parameter query

Creating advanced form design:

  • Working with graphics
  • Working with calculations
  • Working with combo boxes
  • Working with unbound controls

Using advanced report features:

  • Create customized headers and footers
  • Add a calculated value
  • Work with sub-reports

 

Delivery Formats:

All our in house training course are available tailored to your and your companies/delegates needs with our CTP (customised training programme) solution. Designed to meet any challenge or level required. Ask for a full proposal for your training, tailored to suit you.

inhouse enquiry

 

In house training at your premises – £749.00 for a group of up to 10 (ex travel charged at 45 pence per mile)

 

X

Send this to a friend