START
 

Access - Level 2 (In-House)

SquareOne Training
Course summary
Length: Can be customised to 1 or 2 days
Language: English
Location: Nationwide
Next available date: Enquire for more information - Nationwide

Course Description

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.

For more information on suitability, please send an enquiry here

Training Course Content

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 & rules
  • Data structure principles
  • Types of relationship
  • Referential integrity

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 & 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 & parameters

Advanced Reports

  • Working with multiple tables
  • Concatenating fields
  • Date & time functions
  • String functions
  • Custom styles

Expenses

This training course will be delivered in the form of a closed course at your company's premises and can be custom tailored to meet the needs and requirements of your particular organisation.

SquareOne can come to you no matter where you are based throughout the UK or Europe. The cost of this training course is available upon request.

Please send an enquiry here

Provider: SquareOne Training

SquareOne Training

SquareOne Training

SquareOne Training is an internationally renowned IT Training company who create inspiring, motivational and cost effective training services which bring about tangible improvements in productivity. They specialise in providing classroom courses, Microsoft upgrade training, IT consultancy and large-scale rollout support...


Read more and show all courses with Provider: SquareOne Training

Request information - obligation free

Fill out your details to find out more about Access - Level 2 (In-House).

  Contact the provider

  Get more information

  Register your interest

Errors
Optional
Optional
Optional

Contact information for SquareOne Training

SquareOne Training


2 Tower Road
CH41 1FN Birkenhead

 Show phone number
www.squareonetraining.com

Contact SquareOne Training
Enter & win £50 voucher

 
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

 
Request information

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

 
Similar courses

With Activia, IT User training comes the way you want it: at your place or ours; off-the-shelf or bespoke; scheduled public classes or closed private courses matched to your requirements.

 
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
 
Find more courses here