Microsoft Access 2010
These exercises start from basics and are suitable for people with no previous database experience, though they are recommended for people who are competent with other Windows applications such as Word and Excel. Experienced users may be able to skim over the first few exercises but it is recommended that they be completed in order. I've found from teaching experience that people who skips steps invariably have to come back later to pick up what they missed. All of the following documents are in PDF format. The numbers in brackets indicate file size. Larger files may take a long time to open in slower internet connections.
Note: These exercises have recently been completed. If you discover mistakes or have any suggestions, send them to Steve.
- Getting Started (1.2Mb)
- Queries (657kb)
- Advanced Queries (837kb)
- Forms Reports (932kb)
- Relational Databases (992kb)
- Relational Queries, Forms & Reports (1mb)
- Interfaces & Finishing Touches (1.4Mb)
These exercises were created for users of Microsoft Access version 2010. They should be suitable for users of other versions though some minor differences may exist. Note that databases created in some versions of Access may not work in other versions of Access.
It is recommended that the files below are saved to your own computer. Right-click the file you need and then choose the Save Target As option. You can then select a location to save the file to.