University of Leeds

IT

Introductory Exercises in Microsoft Access 2000

Introduction

View pages in this section

About Access

The aim of this document is to enable you to gain an insight into using the Microsoft Access database management system.

A database is a collection of information related to a particular subject or purpose, such as tracking customer orders, maintaining student records or monitoring patient activity. If your database is stored on a computer, it will be possible to perform tasks such as:

  • select subsets of records that meet specific criteria
  • create forms
  • create reports
  • carry out mail merge.

A computerised database is more than simply a repository for information. Its data can be analysed and presented graphically, or exported to another application such as Microsoft Excel.

The scope of this document is to introduce you to the Access user interface, to enable you to enter data, format data, set up simple queries, create forms and reports using the wizards, and export data. Since this is an introduction written for users with no experience of databases, it will only deal with a simple, single table database. There are other documents available which will enable you to understand the powerful relational aspects of Access. These cover relationships and design techniques, and take a more in-depth look at the objects (tables, queries, forms and reports) within Access.

The lessons have been designed in such a way that you are advised to complete a lesson and its exercise before proceeding to the next one.

Requirements

It is assumed that you already know how to login to the network and run the Microsoft Windows operating system. No prior knowledge of databases in general, or Access in particular, is assumed.

Contact us

Telephone: + 44 (0) 113 343 3333

Send your feedback or find key contact details.