Introductory Exercises in Microsoft Access 2000
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.
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.
Pages in Introductory Exercises in Microsoft Access 2000
- 1. You are here: Introduction
- 2. Task 1 Getting Started
- 3. Task 2 The Access Screen
- 4. Task 3 Designing a Table
- 5. Task 4 Entering and Editing Data
- 6. Task 5 Creating a Query
- 7. Task 6 Creating a New Form
- 8. Task 7 Creating a Report
- 9. Task 8 Printing
- 10. Task 9 Exporting Data
- 11. Task 10 Finishing Access