• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

DVDVG Database

Extracts from this document...

Introduction

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. ...read more.

Middle

from the tables tab in the database main window (Figure 1.2). 2.) Access will now load up a new window in which you will input the fields and fields' type of the table. 3.) In the Field Name Column enter in the name of each field as shown below, for each field select the related field type (Figure 2.1.1): Once you have done this, set the field CustomerID as the primary key. To do this, select the field, then click on "Primary Key" from the main toolbar at the top (). 4.) Now select the DOB Field and add the following validation rule exactly as shown below: >#01/01/1900# This will check to make sure that there is no person born before the year 1900. ...read more.

Conclusion

To do this, select the field, then click on "Primary Key" from the main toolbar at the top (). 4.) Now select the DOB Field and add the following validation rule exactly as shown below: >#01/01/1900# This will check to make sure that there is no person born before the year 1900. Now you need to enter a validation text so that the user is notified if they do enter a date before the year 1900. With the DOB Field still selected, add the following text in the in validation text box: "You can not enter a date of birth before the year 1900". 5.) For the TelephoneNo field, you need to enter the following input mask: 99999/000/000; ?? ?? ?? ?? Pedram Emrouznejad 11L 1 ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE Software section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related GCSE Software essays

  1. Database design for a games shop.

    name Text Game information Address Text Home address Town Text Town of residence postcode text Postcode of member Contact number text Phone number Field name Data type description validation Membership id Number A foreign key from the members table. This makes sure that no errors are made.

  2. Spreadsheet Technical report. My task was to produce a grade book for primary ...

    year to compare the two, and the percentage differences including the bonus amount depending on a positive percentage difference; charts showing the differences between the two years; and finally a table showing the school budget and the amount the school have left to spend after paying for bonuses and gift vouchers.

  1. ICT BTEC UNIT 2 - REPORT

    and fun to use and make work so much more pleasurable to do instead of having to wait a long time for everything to load up. There are significant differences in the two computer systems in the table below, the Dell Precision T7400 has an Intel Xeon processor Quad Core

  2. Database analysis of 'a video lending library'.

    We can also do many calculations in the database. We can store as much as we want in the single database, we don't require much space to store this information, as all this information is stored in the computer by the click of a button, unlike the manual way in which, we need to put all the files, cards,

  1. Project 1b; Film Database

    When I see the movie in the list I might remember it. * I need to find particular movies for my Media Studies class. I want movies with a rating between 6 and 10 that have either the genre action and were produced in the year 2006, or movies with

  2. Spreadsheet. This coursework is based on the work of a spreadsheet, which is ...

    of light that is reflected is measured and the corresponding price is brought up. This is a good method as it is quick and easy to use. But this is a small shop, and the machine along with its software is too expensive.

  1. IT Implementation

    reg number' field was set to 50 characters long: I changed the 'Field Size' to 10 characters long, as no registration number is more than that and it creates space on my database. Creating the Loans Table The way loan's table was created in basically the same way as the

  2. implementation report

    understand, if I used the picture the user might think that it would be something else. Appendix 22 Appendix 22 shows that the command button was added I resized the command button to an appropriate size so that it would look appealing to the user I then worked through the

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work