Access – Database Design and Reporting
Learn how to design and build relational databases in Microsoft Access, then extract and report data with confidence. This hands-on course shows you how to structure data properly, create queries, and produce clear, usable reports.
In this course, you will learn how to:
- Create and structure relational databases in Access
- Build tables, forms and queries to manage data accurately
- Extract information using queries and calculations
- Create clear, professional reports for sharing data
- Design databases that grow and remain reliable over time
Who is this course for?
People who need to manage structured data more effectively using Microsoft Access. Ideal for new Access users or those who work with data in Excel and want to move beyond spreadsheets.
Enquire NowFrequently Asked Questions
What database skills will I learn using Microsoft Access?
Is this Microsoft Access course suitable for beginners?
Do I need any prior knowledge before attending?
How is the training delivered?
What practical skills will I be able to apply after the course?
What support is available after the training?
Course Outline
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
Why Choose Underscore for Microsoft Access Training?
Underscore Group delivers practical, instructor-led digital skills training that helps teams use everyday workplace tools with confidence and accuracy. Based in Sussex and supporting organisations across the UK, we specialise in hands-on learning that improves productivity and makes complex software feel simpler and more intuitive.
We tailor every session to your organisation’s systems, workflows and real-world use cases, ensuring people can apply what they learn immediately. Our software training is trusted by organisations across finance, aviation, healthcare, construction and professional services.
- Trusted by leading UK organisations
- Expert trainers with real business experience
- Small-group sessions (6–8 people)
- Practical, hands-on learning approach
- Virtual & onsite delivery across the UK
- Six months of post-course support
Get in Touch
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.
Enquire NowLooking for training in a different area?
Browse all our Corporate Training Courses across Leadership, Project Management and Microsoft 365.
Browse All Courses →Related Courses
Excel Module 1 – Key Skills and Formula Creation
Start from the ground up and learn tips, tricks, shortcuts and build confidence in using Excel.
Power BI – Introduction
Learn how to use this powerful tool to import and clean data and create some amazing visuals.
Excel Power Query and Power Pivot
Learn how to work with and connect multiple data sets to effectively analyse and report on data.
Explore More Training Options
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.
Check Public DatesFull 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.
