Setup Menus in Admin Panel

Woodthorpe IT Solutions Ltd

Setup Menus in Admin Panel

Setup Menus in Admin Panel


How we deliver Access courses

Onsite Courses

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


Open Course Dates

  • You come to our venue
  • Suitable for individuals

Online Courses

  • Self paced
  • Budget Friendly
  • 24/7 Learning

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

Complex queries

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

Advanced form design

Adding unbound controls
Adding calculated values
Adding combo boxes

Advanced reports

Customized headers and footers
Adding calculated values


Charts in forms
Charts in reports

PivotTables and PivotCharts

MS Access PivotTables
Modifying PivotTables

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


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

© Woodthorpe IT Solutions Business vector designed by Freepik
All prices on this site are excluding VAT unless otherwise stated.