Course not currently available

Access Training for New Users

Course

In London ()

£ 749 VAT inc.

Description

  • Type

    Workshop

  • Class hours

    8h

  • Duration

    2 Days

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. 

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Access
  • Database Design
  • Database Management
  • Database
  • Database training
  • Design
  • Microsoft Access
  • Database performance
  • Access training
  • Microsoft Access Training

Teachers and trainers (1)

Taylor Mason

Taylor Mason

Very Experienced Trainers

All our trainers are experts in their field, most of which have worked for us for some time. From 1-1 coaching to complex change programmes we have the skills and experinece. We cover, Human Resouces, Communicaton Skills, Leadership and Supervision, Microsoft & IT, Sales & Marketing, Personal Development, Health & Safety, Project Management, PA & Office Skills,

Course programme

What you learn:

  • 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:

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

Access Training for New Users

£ 749 VAT inc.