DVDVG Database

Authors Avatar

Pedram Emrouznejad 11L

Implementation

Setting up the Database

To start creating the DVDVG Database, open the application Microsoft Access 2003. Once the program has loaded create a new database by clicking on the “Create new file…’ link, on the “Getting Started” Panel.

 Alternatively, if you cannot see the Getting Started Panel, you can go to File > New…

Then Select “Blank Database” from the panel.

Microsoft Access will then open a file dialog, in which you should select a location on your local hard disk to store the database.

Once you select a valid location, Access will automatically create the database for you, and then it will open up the database main window as shown in Figure 1.2.

Join now!


Creating the Tables

Next will we create four tables to store information about the customers, products and rentals. The three tables will be called:

  • tblCustDetails: Information about the customers
  • tblDVDDetails: Information on the products which are DVDs
  • tblVGDetails: Information on the products which are Video Games
  • tblRentals: Information on the products which have been rented out to customers

Notice that all the tables have been prefixed with “tbl”. This is so that when we refer to “tblCustDetails” for example, we know that it is a table, as opposed to just “CustDetails” which could be ...

This is a preview of the whole essay