Woodthorpe IT Solutions Ltd

header-access-small

How we deliver Access courses

Onsite Courses

  • We come to you
  • We bring all the equipment needed
  • The outline can be customised

From £500 per day
(additional expenses may be payable)

Open Course Dates

  • You come to our venue
  • Suitable for individuals

From £125 per day per person

Online Courses

  • Self paced
  • Budget Friendly
  • 24/7 Learning

From £29 per person


Access Basic

Our Microsoft Access Basic course gives you a grounding in access and will enable you to build simple database systems that can benefit your business.  It is expected that you will have a certain basic knowledge of using a computers but no prior experience with Microsoft Access.

Getting started

Database concepts
Exploring the Microsoft Access environment
Getting help
Closing a database and Access

Databases and tables

Planning and designing an Access databases
Exploring Database tables
Creating Database tables

Fields and records

Changing the design of a database table
Finding and editing Database records
Organizing Database records

Data entry rules

Setting database field properties
Working with input masks
Setting validation rules
Using indexes

Simple database queries

Creating and using queries
Modifying query results and queries
Performing operations in queries

Access forms

Creating forms
Using the Form Wizard
Using Design view
Finding, sorting, and filtering records

Access reports

Creating reports
Modifying and printing reports

Access Intermediate

Our Microsoft Access Intermediate course builds on your prior knowledge and enables you to create a more flexible and robust database system making it much easier for the user to operate.  It is expected that you will have experience or training within Microsoft Access. 

Relational databases

Database normalization
Relating MS Access tables
Implementing referential integrity

Working with related tables

Lookup fields
Modifying Lookup fields
Subdatasheets

Complex queries

Joining tables in MS Access queries
Creating calculated fields
Summarizing and grouping values

Advanced form design

Adding unbound controls
Graphics
Adding calculated values
Adding combo boxes

Advanced reports

Customized headers and footers
Adding calculated values
Sub-reports

Charts

Charts in forms
Charts in reports

PivotTables and PivotCharts

MS Access PivotTables
Modifying PivotTables
PivotCharts

Internet integration

Hyperlink fields

Access Advanced

Our Microsoft Access Advanced course introduces techniques employed by professional application developers providing you with the skills to build feature rich database systems.  It is expected that you will have experience or training within Microsoft Access. 

Querying with SQL

SQL and Access
Writing SQL statements
Attaching SQL queries to controls

Advanced queries

Creating crosstab queries
Creating parameter queries
Using action queries

Macros

Creating, running, and modifying macros
Attaching macros to the events of database objects

Advanced Macros

Creating macros to provide user interaction
Creating macros that require user input
Creating the AutoKeys and AutoExec macros
Creating macros for data transfer

Importing, exporting, and linking objects

Importing objects
Exporting objects
Interacting with the XML documents
Linking Access objects
Working with Windows SharePoint Services

Database management

Optimizing resources
Replicating and synchronizing databases

Security fundamentals

Protecting databases
Encrypting and decrypting databases
User-level security


What our customers say

North West Office

Woodthorpe IT Solutions Ltd
4 Haycroft Close
Great Sutton
Ellesmere Port
Cheshire
CH66 2GY

Registered No. 05572129

VAT No. 936 2824 09

North East Office

Woodthorpe IT Solutions Ltd
13 Queensway House
Middlesbrough
Cleveland
TS3 8TF

Telephone

0800 044 3779

Email

contactus@woodthorpeitsolutions.co.uk

top
© Woodthorpe IT Solutions Site by Ben Timney Business vector designed by Freepik
All prices on this site are excluding VAT unless otherwise stated.
Performing arts school database Video

No flash installed

×
IFA Practice Manager

No flash installed

×
Production Scheduling Tool

No flash installed

×
Format As Table Part 1

No flash installed

×
Format as a table part 2

No flash installed

×
Subtotalling a list

No flash installed

×
Sorting basics

No flash installed

×
Cell Styles

No flash installed

×
Remove Duplicates In List

No flash installed

×