Microsoft Access 97 Databases

My CD Collection Data Base

Creating the new Database

1. Click on Microsoft Access from the Start – Programs.
2. Click Blank Database.
3. In the window, choose the users on F: drive chssrv.

4. In the file name box: name the database cdcollection.
5. Click Create.

Creating and Setting up a table for the database

6. Click on the Tables tab.
7. Click New.
8. Click Data Sheet View and then click OK.
9. Rename the Fields by right clicking to on the field name (i.e. Field 1), right click and choose Rename Column.

10. Rename Field 1, Field 2 & Field 3 to: Title, Artist, Year Released.
11. Click the lower X to close the tables window.
12. Click yes to save the table.
13. Name the table tblcds.
14. Click OK.

15. Click yes to assign a primary key.

Creating a Form to access the database

16. Click the Forms tab.
17. Click New.
18. Choose AutoForm: Columnar.
19. On the down arrow, choose tblcds (the table name) in the drop down list.

20. Click the X to close the Forms window.
21. Click yes to save the form.
22. Name the form frmcds.

Changing the form background

23. Close the form if it is open. Click on the Form tab.
24. Click on the frmcds form.
25. Click Design.
26. Click on Format from the top menu.
27. Click on AutoFormat.
28. Choose your background you wish to use for this form.