Duration: 2 days (13 hours)

Cost: £640 +VAT per person (prices vary for bespoke courses – please enquire)

Our Access Database Design and reporting course looks at the key elements to building fully relational databases and entering and extracting information from them.

This course is designed for new users who need to build relational database systems.

By the end of the course you will be able to:

  • Create a new database
  • Create data tables
  • Set field validation and properties
  • Enter data and manage data
  • Create forms
  • Use queries to extract data
  • Create parameter queries
  • Create calculations in queries
  • Build relational databases
  • Use sub datasheets
  • Build multi table queries
  • Use advanced form and report design techniques

  • Creating a new database
  • Database elements

  • Setting field properties
  • Using input masks
  • Using input masks
  • Validation rules
  • Default values
  • Setting a primary key
  • Creating lookup fields

  • Adding data
  • Deleting data
  • Quick keys for data entry

  • Sorting data
  • Filtering data
  • Finding information
  • Navigation

  • Creating quick forms
  • The form wizard
  • Amending forms
  • Formatting
  • Setting the tab order
  • Entering data using forms

  • Creating a query
  • Setting criteria
  • Using the expression builder

  • Using wildcards
  • Using more than one parameter

  • Adding a totals row
  • Formatting results
  • Adding calculations

  • Printing tables and queries
  • Creating reports
  • Building and amending reports
  • Adding headers and footers

  • Relational database principles
  • Importing data from other sources
  • Linking information between tables
  • One-to-one and one-to-many links
  • Defining referential integrity
  • Amending links
  • Deleting links

  • Viewing a subdatasheet
  • Removing a subdatasheet
  • Connecting a subdatasheet

  • Deciding which tables to use
  • Adding tables to the query
  • Creating links between tables
  • Setting join properties

  • Field properties
  • Creating lookup fields
  • Adding calculated fields
  • Applying conditional formatting

  • Field properties
  • Report properties
  • Alternate colour bandings
  • Concatenating fields
  • Adding calculated fields
  • Sorting and grouping
  • Grouping settings
  • Adding headers and footers
  • Adding dates, times, page numbers

Cost: £640 +VAT per person (prices vary for bespoke courses – please enquire)

Click here to view next available dates and complete booking request.

Please email training@underscore-group.com if you would like to discuss the course before booking or to discuss bespoke programme options.

Excellent course and trainer.  Thank you Susan for doing the course. I had limited knowledge of Access but now I can make the use more, not only once a year for Christmas cards distribution. I am also going to modify the existing database. The small group was good. I know the max you can take 6 people, but this time it was much smaller and I feel less nervous in case I am holding back the others. I would recommend a virtual session, relaxed atmosphere from my own desk  Thank you.

Tokyo Electron logoYoko, Tokyo Electron Europe Limited
Back to all courses