phone 020 8798 3474 / 01670 732139
Email steve@itseasy.co.uk

Access Training

 

Venue & Duration: Newcastle Training Room. 1 Day Duration. Free sandwich lunch is provided and parking is available.

 

Costs: Between £125 for a group book and £225 for a single delegate. Ask about One to One prices.

 

Objectives: Microsoft Access is a powerful database package – yet many people find it difficult to master. Whether you are a beginner looking to learn the basics or a regular user looking to develop your skills, our courses will equip you with the skills you need to master Access databases.

 

Benefits: We help users of Microsoft Access to learn and develop their skills with our range of Access Training courses. This helps people to be more productive at work and feel much more confident when using Access. We offer three courses: Beginners, Intermediate and Advanced; we can also customised training to suit your needs. We can help individuals who would like to attend an open course or we can provide bespoke training for a business or organisation. 1-2-1 and private tuition is also available. If you are unsure as to what level or format will suit your needs, simply contact us and we can find the best solution for you.

 

Suitable For: This course is suitable for all skill levels and will be made appropriate to attendees.  We offer three levels: Introduction, Intermediate and Advanced.  Check what level is best for you by using our Check Skill Level.

 

 

COURSE OUTLINE:

 

Introduction

Learn about the key Objects in Microsoft Access, such as Tables, Queries, Reports and Forms.
Learn about Data type and properties.
Learn how to create a Table using the wizard options and in design view.
Learn how to import data from other programs such as Microsoft Excel
Learn how to use Microsoft Access to mail Merge in to Word.
Learn how to create simple select Queries to filter records.
Learn how to create simple Forms and their relationship with Tables and Queries.
Learn how to Create Reports and how they work with Tables and Queries
Learn how to Sort and filter table records.
Learn how to set default properties and create Lookup lists and Tables

 

Intermediate

Learn how to create Table relationships in Microsoft Access, linking two tables together using a One to Many link
Learn how and when to use the Join Type feature.
Learn how to create Update, Delete, Make Table, Cross Tab and Duplicate Queries
Learn how to create and use Parameter Queries and how they work with Reports in Microsoft Access
Learn how to use the Pivot Tables and Pivot Chart features
Learn to create a Sub Form and Sub Report.
Learn how to use option groups and Tab controls in Forms.
Learn how to use Command buttons and the wizard to create a Main Menu Form.
Learn how to create an Automated Start Up in Microsoft Access.
Learn how to use the Totals feature in Queries and how to create calculations at Query level in Microsoft Access

 

Advanced

Learn how to use the Expression Builder.
Learn how to create macros and attach them to command button and Form controls
Learn how to create calculations across multiple tables
Learn how to use the IIF and DataDiff functions in Microsoft Access
Learn to use Macros to run commands and export data.
Learn how to use the Where feature in Macros.
Learn how to use the AutoExec Macro.
Learn how to create calculations in Forms and Reports.
Learn how to use Conditional formatting in Forms.
Learn how to create and use a Switchboard in Microsoft Access
Some examples
Relationships access
Find Out More
To find out more, discuss your needs or book a place, call 01670 732139 / e-mail info@itseasy.co.uk or use the enquiry form on the top right hand side of this page.

Make An Enquiry


If you have any questions
or would like to request a call back,
please use the form below:


Request a Call Back


excel

  • Beginners, Intermediate & Advanced courses
  • Open, bespoke & 1-2-1 training
  • Newcastle Training Room or your premises
  • from just £90 per delegate per day

readmore



  • Learn new skills and develop existing skills
  • Feel much more confident when using the computer program
  • Be more productive at work and be able to take on new roles

readmore

excel

  • Training in small groups (max 6)
  • FREE and UNLIMITED support after the course
  • Free buffet lunch & refreshments
  • Complete notes and manuals

readmore