HOME
 

Microsoft Access Intermediate

AJ Training
Course summary
1 day
135 GBP excl. VAT
Nationwide
Next available date: - United Kingdom
Corporate Training for Teams
Microsoft Access Intermediate

Course description

Access, the Microsoft Office database management program, provides a powerful set of tools that are sophisticated enough for professional developers, yet easy for new users to learn. Now everyone in your organization can create or use powerful database solutions that make organizing, accessing and sharing information easier than ever.

An improved user experience, automatic error checking, automatic property updating, and the capability to view object dependencies help you work more productively.

AJ Training offer a range of beginner to advanced Access hands on training courses and workshops delivered online, at our Rotherham training suite or on site at your location.

Training Course Content

A 2 Day Intermediate Course, aimed at users that have been on the previous stages or an experienced user. This course aims to give users further knowledge and tools to create Access databases. By the end of the 2 days, users will be able use the Access Action queries, produce enhanced forms and reports and create relationships.

Refresh on Previous Stages

Quick refresh over key features of Access.

• Flat File Databases
• Database specifications

Designing Tables

Creating and modifying the Tables with more advanced properties.

• Naming Conventions
• Data Types
• Data Validation
• Combo Boxes
• Linking Tables
• Primary and Foreign Keys

Creating and Modifying Forms

Create/ Edit User friendly input forms.

• Modifying Form Properties
• Sub Forms
• Tab Controllers
• Search Forms
• Relational Forms
• Welcome Forms
• Query Based Forms

Queries

Manipulate the data and find specific records.

• Select Queries
• Parameter Queries

Quick refresh over key features of Access.

• Flat File Databases
• Database specifications
• Temporary Fields
• Cross Tab Quires
• Update Queries
• Delete Queries

Reports

Presentable way of printing your data.

• Printing Custom Reports
• Creating Query Based Reports
• Custom Report Creators
• Sub Reports

Macros

A brief introduction to macros.

About provider

AJ Training

AJ Training

AJ Training are a leading business to business training provider, established in 2006 with a national service and a comprehensive range of IT and soft skills courses we have helped up-skill tens of thousands of delegates. All our courses are...


Read more and show all courses with this provider

Request info

Fill out your details to find out more about Microsoft Access Intermediate.

  Contact the provider

  Get more information

  Register your interest

Contact info

AJ Training

Moorgate Crofts Business Center
S60 2DH Rotherham

 Show phone number

Reviews

Average rating 4.8

Based on 11 reviews

Antonia Lowe
(5)
Really well explained and broken down to help individuals understand
George Bonar
(5)
very informative and well structured
Andrea Pettigrew
(4)
This was purely intended as a refresher session for me, having attended the intermediate course 5 years ago.
Request information

Find out more about this Microsoft Access Intermediate course - simply fill out your details:

U.K. L&D Report: 2018 - Benchmark Your Workplace Learning Strategy

Are you curious about the L&D strategies of some of the U.K.'s top companies?

Find out what they're up to in findcourses.co.uk's second annual U.K. L&D Report!

uk-ld-report-2019

Learn more

Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

Find more courses here