database
implementation in access
creating the 'CD' entity
In this section I will show you how I implemented my database design in Microsoft Access. First I had to start up the program and create a new database. I did this and named it 'CD Sales'. I then created the CD entity in design view. Below is a screen dump of the CD entity in design view after I had finished entering the field names and details:
I then needed to make the CD Number the primary key, I did this by highlighting the field and pressing the key icon button on the table design menu. Below is a screenshot of the table after it had been applied:
Click next to continue...