Computer Tutoring Logo
Est. 2002
Menu Button

Cost Calculator

Training Delivery
Number Students?
Laptop hire?
Offsite training?

Course Price: £ *
Price Per Head:
£ .

Duration:
1 Day

* Price is exclusive of VAT.

Tell Me More

Live Online Face-to-Face
First Name:

Last Name:

Email:

Tel:

Location:

Num Students:
First NumberPlusSecond Number  = 
Please enter the answer to prove that you are human and not a machine.
I would like to receive software tips and special offers

Testimonials

Handelsbanken

I am very impressed with the training. My access skills are very much self taught and I was unsure about whether the level of the course would be right. The training was delivered in a really clear manner and at the right pace. Thank you very much to Richard for the course. I would thoroughly recommend it.

Blaby District Council

"I found the training session really interesting as I use Access daily and had no idea on how much it actually can do. Simon is a fantastic trainer and takes his time explaining all the background so you get to understand better, he is thorough and has the patience of a saint. I would highly recommend anyone considering this training to consider going booking Simon and his team."

British Antarctic Survey

"Our bespoke training was really good and invaluable. We learnt a great deal about Microsoft Access and databasing techniques. Both aspects are so important to our work. Simon, our trainer, was a real expert and he made the two days interesting and enjoyable. Thank you so much"

Pepsico

"Only a small group so really great training interaction. Well prepared and friendly, made what could of been a slightly dull topic enjoyable."

"Very good. I have never used Access before but feel confident that I will be able to set up and manage databases going forward."

Microsoft Access 2013 Training Course Intermediate

Microsoft Access 2013 Overview

In this course, you will expand your knowledge of relational database design, write advanced queries, structure existing data, share data across applications, and customize reports. Extending your knowledge of Microsoft Access 2013 will result in a robust, functional database for your users.

Course Duration: 1 Day

Course Outline

Designing a Relational Database Access 2013

  • Relational Database Design
  • Create a Table
  • Create Table Relationships

Use Microsoft Access to Join Tables

  • Create Query Joins
  • Join Tables That Have No Common Fields with Access 2013
  • Relate Data within a Table
  • Work with Subdatasheets
  • Create Subqueries

Organising a Database for Efficiency

  • Data Normalization
  • Create a Junction Table
  • Improve Table Structure

Sharing Data Across Applications

  • Import Data into Access
  • Export Data to Text File Formats
  • Export Access Data to a Spreadsheet
  • Create a Mail Merge

Advanced Reporting

  • Organize Report Information
  • Format Reports
  • Include Control Formatting in a Report
  • Add a Calculated Field to a Report
  • Add a Subreport to an Existing Report


Microsoft Access 2013 Training Course Intermediate

At Computer Tutoring, we prioritise your privacy and only collect the necessary information to provide our services. We will only share the personal data you provide in a form if you have opted in for those services. Our website also uses Google Analytics. You have the right to access, amend, or request deletion of your personal data by contacting us at info@computertutoring.co.uk.

For more details, please read our full Privacy Policy.