Being more selective in an Access query
One of the incredibly powerful features of SQL-based databases is the ability to write queries with very specific criteria to…
Adjusting the width of an Access report
This short tutorial demonstrates the method to fix the common "Report width is greater than page width" error in Access.
Creating an Access Report
A Report can be based on a table or tables, or a query or queries. Reports are used to create…
Creating Labels in Access
Labels are designed to be printed on the variety of self-adhesive label sheets that can be purchased at your stationary…
IGCSE Paper 3 June 2022 Task 3 – Database
This walkthrough is for Task 3 of the Cambridge IGCSE Practical Exam Paper 3 from June 2022. This database question…
Calculated field in an Access query
In Excel, calculations are performed on values contained in cells or cell ranges using cell or range references. In the…
Importing data into Access
This tutorial covers different methods of importing data into a Microsoft Access database.
Access’ Import Text file function
Text file formats are more secure when transferring data than, for example, spreadsheet files like Excel’s .xlsx. Comma-Separated Values (“CSV”)…
Text Delimiters & Qualifiers
We are probably most comfortable seeing data in a structure such as a table; tabulated data is easy to follow…
Database concepts you should know
A good deal of this post deals with concepts that are outside of the DBE CAPS CAT curriculum, however, understanding…