Access - Database Design and Reporting

Course overview

Duration: 2 days (13 hours)

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.

Objectives 

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

Content

Creating a database

• Creating a new database
• Database elements

Creating a data table

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

Data entry 

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

Working with data

• Sorting data
• Filtering data
• Finding information
• Navigation

Creating data form

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

Creating queries

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

Creating parameter queries

• Using wildcards
• Using more than one parameter

Using calculations in queries

• Adding a totals row
• Formatting results
• Adding calculations

Printing and reporting

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

Working with relational databases

• 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

Sub datasheets

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

Multiple table queries

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

Advanced form design

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

Advanced report design

• 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

Still have questions about this course?

Click Enquire Now and our team will share full details on content, dates, and pricing — and help you decide if it’s the right fit for you or your organisation.

Public Training Programme

Explore our current selection of public courses, available as convenient and cost-effective virtual sessions.

Engage with expert instructors and a diverse peer group in an interactive, online learning environment.

Ideal for those valuing flexibility and affordability, our public courses are ideal where you only have small numbers requiring training and offer training from the comfort of your home or office.

Full Training Catalogue

We deliver a wide range of training across Leadership, Personal Development, Project Management, and IT applications. Many organisations choose us because they can source both technical and people-focused training from one trusted provider.

Courses can be tailored to your organisation’s needs, making it easier to upskill teams consistently across different areas. Whether you want to build management capability, strengthen project delivery, or boost everyday software skills, you’ll find relevant options in our catalogue.