Please click here to chat with a certified trainer
Microsoft Access courses logo

 

MS Access courses

 


 

 

  • Access Level 1 Course
  • Access Level 2 Course
  • Access Level 3 Course

Course Date  City Course Times    Cost  
September        
29 Sep Cardiff 9AM - 4PM    £195 Book
October        
03 Oct London Bridge 9AM - 4PM    £195 Book
09 Oct Glasgow 9AM - 4PM    £195 Book
11 Oct Bristol 9AM - 4PM    £195 Book
26 Oct Leeds - City Centre 9AM - 4PM    £195 Book
27 Oct Cardiff 9AM - 4PM    £195 Book
31 Oct London Bridge 9AM - 4PM    £195 Book
November        
14 Nov Bristol 9AM - 4PM    £195 Book
15 Nov Glasgow 9AM - 4PM    £195 Book
23 Nov Leeds - City Centre 9AM - 4PM    £195 Book
24 Nov Cardiff 9AM - 4PM    £195 Book
30 Nov London Bridge 9AM - 4PM    £195 Book
December        
13 Dec Bristol 9AM - 4PM    £195 Book
13 Dec Glasgow 9AM - 4PM    £195 Book
18 Dec Cardiff 9AM - 4PM    £195 Book

Course Date  City Course Times    Cost  
11 Oct Bristol 9AM - 4PM    £195 Book
 
14 Nov Bristol 9AM - 4PM    £195 Book
 
13 Dec Bristol 9AM - 4PM    £195 Book
 
29 Sep Cardiff 9AM - 4PM    £195 Book
 
27 Oct Cardiff 9AM - 4PM    £195 Book
 
24 Nov Cardiff 9AM - 4PM    £195 Book
 
18 Dec Cardiff 9AM - 4PM    £195 Book
 
09 Oct Glasgow 9AM - 4PM    £195 Book
 
15 Nov Glasgow 9AM - 4PM    £195 Book
 
13 Dec Glasgow 9AM - 4PM    £195 Book
 
26 Oct Leeds - City Centre 9AM - 4PM    £195 Book
 
23 Nov Leeds - City Centre 9AM - 4PM    £195 Book
 
03 Oct London Bridge 9AM - 4PM    £195 Book
 
31 Oct London Bridge 9AM - 4PM    £195 Book
 
30 Nov London Bridge 9AM - 4PM    £195 Book

Access Level 1 Course

Most organizations maintain and manage large amounts of information. One of the most efficient and powerful ways of managing date is by using relational databases. Information can be sorted, linked and managed using a single relational database application and its associated tools. In this course, you will examine the basic database concepts, and create and modify databases and their various object using the Microsoft Office Access relational database application

Access Level 1 Course

Unit 1 : Getting started

  • Topic A : Database concepts
  • A - 1 : Identifying database components
  • A - 2 : Identifying advantages of relational databases
  • Topic B : Exploring the Access environment
  • B - 1 : Starting Access and examining the Access window
  • B - 2 : Opening a database
  • B - 3 : Using the Navigation Pane
  • B - 4 : Examining a database table
  • Topic C : Getting help
  • C - 1 : Using Help

Unit 2 : Databases and tables

  • Topic A : Planning and designing databases
  • A - 1 : Planning a database
  • A - 2 : Creating a database from a template
  • A - 3 : Creating a blank database
  • Topic B : Exploring tables
  • B - 1 : Discussing views
  • B - 2 : Examining a table in Datasheet view
  • B - 3 : Navigating a table in Datasheet view
  • B - 4 : Examining a table in Design view
  • Topic C : Creating tables
  • C - 1 : Creating a table from a table template
  • C - 2 : Creating a table in Design view
  • C - 3 : Adding fields and descriptions to a table
  • C - 4 : Setting the primary key
  • C - 5 : Saving the table
  • C - 6 : Adding a record
  • C - 7 : Copying, modifying, and deleting a table
  • C - 8 : Creating a composite key
  • C - 9 : Using the Data Type gallery

Unit 3 : Fields and records

  • Topic A : Changing the design of a table
  • A - 1 : Modifying field names
  • A - 2 : Deleting and inserting fields
  • A - 3 : Moving a field
  • A - 4 : Using the Attachment data type
  • A - 5 : Adding a Totals row
  • Topic B : Finding and editing records
  • B - 1 : Finding and replacing a value
  • B - 2 : Undoing changes
  • Topic C : Organizing records
  • C - 1 : Sorting records by a single field
  • C - 2 : Sorting records by multiple fields
  • C - 3 : Using Filter By Selection
  • C - 4 : Using Filter By Form
  • C - 5 : Using Filter Excluding Selection
  • C - 6 : Using Advanced Filter/Sort
  • C - 7 : Deleting a record

Unit 4 : Data entry rules

  • Topic A : Setting field properties
  • A - 1 : Setting the Required property
  • A - 2 : Using the Allow Zero Length property
  • A - 3 : Setting the Field Size property
  • A - 4 : Setting the Append Only property
  • Topic B : Working with input masks
  • B - 1 : Creating an input mask
  • B - 2 : Working with the Input Mask Wizard
  • Topic C : Setting validation rules
  • C - 1 : Creating validation rules
  • C - 2 : Setting validation text

 

Unit 5 : Basic queries

  • Topic A : Creating and using queries
  • A - 1 : Planning a query
  • A - 2 : Using the Query Wizard
  • A - 3 : Creating a query in Design view
  • A - 4 : Saving and running the query
  • A - 5 : Sorting query results
  • A - 6 : Filtering a query by adding criteria
  • A - 7 : Creating a query from a filter
  • Topic B : Modifying query results and queries
  • B - 1 : Editing query results
  • B - 2 : Adding fields to a query
  • B - 3 : Finding records with empty fields
  • Topic C : Performing operations in queries
  • C - 1 : Using comparison operators
  • C - 2 : Using the OR condition
  • C - 3 : Using the AND condition
  • C - 4 : Using the * wildcard
  • C - 5 : Using calculations in a query
  • C - 6 : Totalling a group of records
  • C - 7 : Using the Avg and Count functions
  • C - 8 : Using the Min and Max functions

Unit 6 : Using forms

  • Topic A : Creating forms
  • A - 1 : Examining a form
  • A - 2 : Creating a basic form
  • A - 3 : Creating a form by using the Form Wizard
  • Topic B : Using Design view
  • B - 1 : Creating a form in Design view
  • B - 2 : Adding controls
  • B - 3 : Modifying properties
  • B - 4 : Applying conditional formatting
  • Topic C : Sorting and filtering records
  • C - 1 : Using a form to sort records
  • C - 2 : Using a form to filter records

Unit 7 : Working with reports

  • Topic A : Creating reports
  • A - 1 : Examining a report
  • A - 2 : Creating a basic report
  • A - 3 : Creating a report by using the Report Wizard
  • A - 4 : Creating a report in Design view
  • Topic B : Modifying and printing reports
  • B - 1 : Modifying a report in Design view
  • B - 2 : Modifying a report in Layout view
  • B - 3 : Grouping, sorting, and filtering a report
  • B - 4 : Adding summary fields by using the Report Wizard
  • B - 5 : Modifying the layout and style of a report
  • B - 6 : Printing a report

Sorry, we currently do not have any public courses scheduled for the Access level 2 course. Please contact us to see if we can put one on the schedule for you

Sorry, we currently do not have any public courses scheduled for the Access level 2 course. Please contact us to see if we can put one on the schedule for you

Access Level 2 Course

You have the basic skills needed to work with Microsoft Office Access database, including creating and working with Access tables, relationships, queries, forms and reports. But so far you have been focusing only on essentials database user skills. In this course, you will consider how to maintain data consistency, how to customize databse components and how to share Access data with other applications

Access Level 2 Course

Unit 1 : Relational databases

  • Topic A : Database normalisation
  • A - 1 : Discussing the first normal form
  • A - 2 : Discussing the second and third normal forms
  • A - 3 : Using the Table Analyser
  • A - 4 : Identifying object dependencies
  • Topic B : Table relationships
  • B - 1 : Establishing a one-to-one table relationship
  • B - 2 : Establishing a one-to-many table relationship
  • B - 3 : Establishing a many-to-many table relationship
  • B - 4 : Printing table relationships
  • Topic C : Referential integrity
  • C - 1 : Planning table relationships
  • C - 2 : Working with orphan records
  • C - 3 : Setting cascading deletes
  • C - 4 : Testing cascading deletes
  • C - 5 : Using cascading updates

Unit 2 : Related tables

  • Topic A : Creating lookup fields
  • A - 1 : Creating a lookup field
  • A - 2 : Creating a multi-valued lookup field
  • Topic B : Modifying lookup fields
  • B - 1 : Modifying lookup field properties
  • B - 2 : Changing a text box to a combo box
  • Topic C : Using subdatasheets
  • C - 1 : Using a subdatasheet

Unit 3 : Complex queries

  • Topic A : Joining tables in queries
  • A - 1 : Creating a query with the Simple Query Wizard
  • A - 2 : Creating a join in Design view
  • A - 3 : Creating an outer join
  • A - 4 : Creating a join with an intermediate table
  • A - 5 : Creating a self-join query
  • A - 6 : Finding records that do not match between tables
  • A - 7 : Finding duplicate records
  • A - 8 : Deleting tables from a query
  • Topic B : Using calculated fields
  • B - 1 : Creating a calculated field
  • B - 2 : Changing the format of a displayed value
  • B - 3 : Using the Expression Builder
  • Topic C : Summarising and grouping values
  • C - 1 : Creating a query to display summary values
  • C - 2 : Using queries to concatenate values

Unit 4 : Advanced form design

  • Topic A : Adding unbound controls
  • A - 1 : Drawing a rectangle around a control
  • A - 2 : Changing the tab order
  • A - 3 : Grouping controls
  • Topic B : Adding graphics
  • B - 1 : Adding a graphic to a form
  • B - 2 : Embedding a graphic in an unbound object frame
  • Topic C : Adding calculated values
  • C - 1 : Binding a control to a calculated field
  • C - 2 : Creating a calculated control
  • Topic D : Adding combo boxes
  • D - 1 : Adding a combo box to a form
  • D - 2 : Modifying the properties of a combo box
  • Topic E : Advanced form types
  • E - 1 : Creating a multiple-item form
  • E - 2 : Creating a split form
  • E - 3 : Creating a datasheet form
  • E - 4 : Creating a subform

Unit 5 : Reports and printing

  • Topic A : Customised headers and footers
  • A - 1 : Adding a report header
  • A - 2 : Adding a report footer
  • A - 3 : Applying conditional formatting
  • A - 4 : Keeping parts of a report on the same page
  • A - 5 : Adding controls to group footers
  • A - 6 : Forcing a new page
  • Topic B : Calculated values
  • B - 1 : Working with the DateDiff function
  • B - 2 : Using the IIf function
  • Topic C : Printing
  • C - 1 : Printing a table
  • C - 2 : Printing a database document
  • Topic D : Labels
  • D - 1 : Creating labels

Unit 6 : Charts

  • Topic A : Charts in forms
  • A - 1 : Creating a chart in a form
  • A - 2 : Modifying a chart in a form
  • Topic B : Charts in reports
  • B - 1 : Adding a chart to a report
  • B - 2 : Modifying a chart in a report

Unit 7 : PivotTables and PivotCharts

  • Topic A : PivotTables
  • A - 1 : Examining PivotTable view
  • A - 2 : Adding fields to a PivotTable
  • Topic B : Modifying PivotTables
  • B - 1 : Creating totals
  • B - 2 : Moving fields in a PivotTable
  • B - 3 : Showing and hiding details in a PivotTable
  • B - 4 : Formatting fields
  • Topic C : PivotCharts
  • C - 1 : Creating a PivotChart
  • Topic D : PivotTable forms
  • D - 1 : Creating a PivotTable form

Sorry, we currently do not have any public courses scheduled for the Access level 3 course. Please contact us to see if we can put one on the schedule for you

Sorry, we currently do not have any public courses scheduled for the Access level 3 course. Please contact us to see if we can put one on the schedule for you

Access Level 3 Course

Your training in and use of Microsoft Office Access has provided you with a solid foundation in the basic and intermediate skills of working in Microsoft Office Access . You have worked with the various Access objects, such as tables, queries, forms and reports. In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Access by structuring existing data, writing advanced queries, working with macros, enhancing forms and reports and maintaining a database

Access Level 3 Course

Unit 1 : Querying with SQL

  • Topic A : SQL and Access
  • A - 1 : Discussing Structured Query Language
  • A - 2 : Examining a SQL statement in Access
  • Topic B : Writing SQL statements
  • B - 1 : Writing a SQL SELECT statement
  • B - 2 : Using the WHERE clause
  • B - 3 : Creating aliases
  • B - 4 : Displaying matching records from related tables
  • B - 5 : Finding unmatched records
  • B - 6 : Getting context-sensitive help on SQL
  • Topic C : Attaching SQL queries to controls
  • C - 1 : Assigning a SQL query to a command button

Unit 2 : Advanced queries

  • Topic A : Creating crosstab queries
  • A - 1 : Viewing a crosstab query
  • A - 2 : Using the crosstab Query Wizard
  • Topic B : Creating parameter queries
  • B - 1 : Creating a single-criterion parameter query
  • B - 2 : Creating a query with multiple parameters
  • B - 3 : Using a wildcard in a parameter query
  • Topic C : Using action queries
  • C - 1 : Adding records to a table with an Append query
  • C - 2 : Deleting records with a Delete query
  • C - 3 : Modifying records with an Update query
  • C - 4 : Creating a Make Table query

Unit 3 : Macros

  • Topic A : Creating, running, and modifying macros
  • A - 1 : Creating and running a macro
  • A - 2 : Modifying a macro
  • Topic B : Attaching macros to the events of database objects
  • B - 1 : Attaching a macro to the Open event of a form
  • B - 2 : Attaching a macro to a command button

Unit 4 : Advanced macros

  • Topic A : Creating macros to provide user interaction
  • A - 1 : Creating a data validation macro
  • A - 2 : Creating a data entry macro
  • Topic B : Creating macros that require user input
  • B - 1 : Creating a macro that runs a parameter query
  • Topic C : Creating AutoKeys and AutoExec macros
  • C - 1 : Creating an AutoKeys macro
  • C - 2 : Creating an AutoExec macro
  • Topic D : Creating macros for data transfer
  • D - 1 : Importing a database object by using a macro
  • D - 2 : Exporting data to a spreadsheet by using a macro

Unit 5 : Importing, exporting, and linking

  • Topic A : Importing objects
  • A - 1 : Importing multiple objects
  • A - 2 : Importing an object from Excel
  • A - 3 : Using a Saved Import specification
  • A - 4 : Importing a CSV file
  • Topic B : Exporting objects
  • B - 1 : Exporting an object
  • B - 2 : Using a Saved Export specification
  • Topic C : Working with XML documents
  • C - 1 : Exporting and importing XML documents
  • C - 2 : Exporting to an XML document with an XSL file
  • C - 3 : Saving a table as an XPS file
  • Topic D : Linking Access objects
  • D - 1 : Linking to an Access table
  • D - 2 : Updating links
  • D - 3 : Linking to an Excel workbook
  • Topic E : Using hyperlink fields
  • E - 1 : Creating a hyperlink field
  • E - 2 : Inserting data in a hyperlink field
  • E - 3 : Modifying data in a hyperlink field

Unit 6 : Database management

  • Topic A : Optimising resources
  • A - 1 : Converting a database to a prior version
  • A - 2 : Analysing performance
  • A - 3 : Splitting a database
  • A - 4 : Using the Compact and Repair Database utility
  • A - 5 : Backing up a database
  • Topic B : Protecting databases
  • B - 1 : Encrypting a database with a password
  • B - 2 : Removing a password and encryption
  • Topic C : Setting options and properties
  • C - 1 : Setting Access Options
  • C - 2 : Creating and populating database properties