In this video we will create a simple access database example and a report.
In the last video we created the tables for this:
tblEmployees
tblDepartments
tblHR
Remember: tblHR serves as our relationship table or "junction table".
In this video we will create a query to base our report on a single query and a simple report.
Our simple query will inform you about concatenating fields in access.
You will learn how to use the access report wizard to create a basic report with grouping and sorting.
Leave any questions you may have in the comments below.
You can get the database at http://loeblcomservices/blog