Steve

Steve's PC Tutorials

Microsoft Access LogoMicrosoft Access Tutorials

Microsoft Access is a database management system (DBMS) that is widely used in small businesses and organisations. 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. All of the following documents are in PDF format.

Microsoft Access 2016 Exercises (click to show / hide)

    These exercises were created for users of Microsoft Access version 2016. 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.

  1. Getting Started (1.4Mb)
  2. Queries (905kb)
  3. Advanced Queries (1057kb)
  4. Forms & Reports (1097kb)
  5. Relational Databases (1419kb)
  6. Relational Queries, Forms & Reports (1.4Mb)
  7. Interfaces & Finishing Touches (1.6Mb)

Microsoft Access 2010 Exercises (click to show / hide)

    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.

  1. Getting Started (1.2Mb)
  2. Queries (657kb)
  3. Advanced Queries (837kb)
  4. Forms Reports (932kb)
  5. Relational Databases (992kb)
  6. Relational Queries, Forms & Reports (1Mb)
  7. Interfaces & Finishing Touches (1.4Mb)

Microsoft Access 2003 Exercises (click to show / hide)

    These exercises were created for users of Microsoft Access version 2002 (XP). 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.

  1. Getting Started (903kb)
  2. Queries (319kb)
  3. Advanced Queries (282kb)
  4. Forms Reports (744kb)
  5. Relational Databases (738kb)
  6. Relational Queries, Forms & Reports (1.4Mb)
  7. Interfaces & Finishing Touches (1.3Mbkb)
  8. Database Use - An overview of Databases for people who only need to know the basics (316kb)

Exercise files for Access Tutorials

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.

2016 Exercise Files 3.6Mb

2010 Exercise Files

All 2003 Exercise Files (2.2Mb)