START
 

Access - Level 3 (In-House)

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

Access - Level 3 (In-House)

Microsoft Access Level 3 In-House CourseAccess Level 3 Advanced (2003; 2007; 2010; 2013 & 2016) - 2 day In-House Training course for your company

This training programme in Microsoft Access Level 3 is specifically designed for teams, companies and organisations and is delivered in-house. All course content is tailored and delivered within the contexts of each organisation.

Throughout the course, delegates will gain an understanding of Microsft Access and how to use its higher functions. Delegates will build skills to advance their querying abilities and learn to use SQL statements in their queries. Participants will also discover how to work with objects, and the fundamentals of database management and how to protect your valuable data sources.

Content typically covered is in the following key areas:

  • PivotTables and PivotCharts
  • Creating Advanced Forms
  • Subforms
  • Macros
  • Managing Databases

Suitability - Who should attend?

This Access - Level 3 in-house training programme is designed for teams, companies and organisations whose members are users of Microsoft Access and wish to gain an understanding of its higher functions. of Microsoft Access.

Course Pre-Requisites

Delegates should of previously attended a Microsoft Access course, or have extensive experience within the package.

For more information on suitability, please send an enquiry here.

Training Course Content

This Access - Level 3 in-house training covers the following topics:

PivotTables and PivotCharts

  • Create a PivotTable
  • Modify a PivotTable
  • Working with a PivotChart

Creating Advanced Forms

  • Designing a form based on joined tables
  • Automating data entry
  • Grouped control
  • How to improve the user interface

Subforms

  • Creating, designing and adding subforms

Macros

  • Create and run macros
  • Attach macros to events of database objects
  • Creating Advanced Macros
  • Create macros to provide user interaction
  • Create macros requiring user decision
  • Use AutoKeys and AutoExec macros
  • Exploring Access SQL
  • How to identify different clauses in an SQL statement
  • Writing SQL statements
  • Attach an SQL statement to database objects Integrating the Internet
  • Work with hyperlink fields

Managing Databases

  • Work with database utilities to optimise resources
  • Secure data by database replication Security Fundamentals
  • Protect databases

Expenses

This Access - Level 3 in-house training programme is offered on an in-house basis and offer companies the opportunity to train their staff in an effective, cost-efficient and convenient way. For a custom training quote for your team, please send an enquiry here.

Provider: SquareOne Training

SquareOne Training - In-House IT & Computer Training

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


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 3 (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
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 3 (In-House) course - simply fill out your details:

 
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

 
Have your say:

apprenticeships