Show findcourses.co.uk as: Mobile

Our annual L&D survey is now OPEN. Have your say in our short survey and receive exclusive pre-access to the report.

Access: Intermediate (Level 2)

SquareOne Training
Course summary
1 day
English
Full time
Birkenhead, Online courses
Next available date: Enquire for more information - Online courses
Professional Training

Course description


Access - Level 2 (Online Training)

This course is designed for people who want to discover more about the features and operations in Microsoft Access so that they become more efficient when manipulating and analysing data. The course quickly takes you from beginner level to more advanced topics.

Suitability - Who should attend?

This course is suitable for existing users of Microsoft Access who wish to build on their knowledge, or for those who have completed our Level 1 course and wish to progress further.

Course Pre-Requisites

Delegates should have previous experience with Microsoft Access and basic knowledge within the package.

Training Course Content

Overview of Access

  • Recap and Overview of Access Level 1

Advanced Table Design

  • Attachment Fields
  • Multiple Value Fields
  • Lookup Fields
  • Advanced Field Properties Including Input Masks
  • Multiple Field Primary Keys
  • Multiple Field Indexes
  • Using the Access Documenter

Relational Concepts

  • Relational Concepts and Rules
  • Data Structure Principles
  • Types of Relationship
  • Referential Integrity
  • Relating Tables

Multiple Tables and Forms

  • Using a Combo Box In Forms
  • Combo Box Properties
  • Lookup Properties
  • Creating Forms with Subforms
  • Editing Sub Forms
  • Tabbed Sub Forms
  • Embedding Sub Forms Using Drag and Drop

Advanced Select Queries

  • Filter By Form
  • Advanced Filter/Sort
  • Convert Filter to Select Query
  • Duplicate Records Query
  • Unmatched Records Query
  • Working with Multiple Tables
  • Understanding Query Join Types
  • Concatenating Fields
  • Calculations in Queries
  • Using String Functions
  • Using Date Functions
  • Using the Immediate If Function
  • Using Wildcards and Parameters

Advanced Reports

  • Working with Multiple Tables
  • Concatenating Fields
  • Date and Time Functions
  • String Functions
  • Custom Styles

Why choose SquareOne Training

25 years' experience of delivering quality IT Training Services

All trainers Certified Microsoft Office Trainer (MOS) or higher

Public and in-house training throughout the UK

Expenses

This course is delivered online live through Microsoft Teams or WebEx. To access the training, you will require a PC/Laptop with Internet connection and audio.

About provider

SquareOne Training

SquareOne believe that no two people are the same, therefore all our courses are unique just like you. SquareOne will work with you and your company to tailor a course that is suitable for your business needs, development and future...


Read more and show all courses with this provider

Request info

Fill out your details to find out more about Access: Intermediate (Level 2).

  Contact the provider

  Get more information

  Register your interest

Country *

Contact info

SquareOne Training

2 Tower Road
CH41 1FN Birkenhead

 Show phone number
www.squareonetraining.com

Reviews

Average rating 4.8

Based on 13 reviews.

Max
Mark was very helpful and knowledgeable on Access. I have learnt a lot in the training session.
Max Hanson
Mark was very helpful and knowledgeable on Access. I have learnt a lot in the training session.
Request Information

Find out more about this Access: Intermediate (Level 2) course - simply fill out your details:

Reviews
Course rating
(4.8)
Based on 13 reviews.
Not sure where to start?
Case Study
SquareOne Deliver IT Rollout Pro...

Read about SquareOne's global projects in New Hardware and Software Refresh and Microsoft Lync/Skype Rollout.

Read more
Excel Templates For Mexichem
SquareOne Training

At SquareOne Training we take pride in designing Spreadsheets for our customers, so we were delighted to be asked to design a solution to track staff courses and KPI alerts. This spreadsheet was implemented in 2018, but completely changed the way the company worked and made the data not only accurate but trackable.

Read more