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

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.

View our full catalogue of Leadership, Personal Development, Systems, Office Applications and Project Management courses

Contact us

Do you have questions, suggestions, or feedback? We value your input and are here to assist you. Please don't hesitate to get in touch with us via email or phone:

• Email: [email protected]
• Phone: +44 (0)20 8152 6551

Our dedicated team is ready to respond to your enquiries and provide the support you need. Feel free to reach out, and we'll do our best to assist you.

Thank you for visiting our website, and we look forward to hearing from you!