Unit 11 : Databases : Worksheet 1

Creating a database about Skiing Holidays


Your task is to create a database. You will need to follow these instructions carefully.

1. Open Microsoft Access

2. Select Blank Access Database then OK

3. Save the blank database in your Database folder and call it Skiing.

4. Select Create table in Design View

5. Type in the following field names in the correct order:

6. Once you have typed in all of the fields, close the table and save it. Call it Skiing.


7. Click ‘Yes’ when the following box appears:


8. Open your table called Skiing by double clicking on it and type in the data from the other side of this worksheet.