• 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.

    Walcott's comments I have made the required changes. Final design I have to redesign the forms, I have made some adjustments after the comments of the user. Here are the changes from the initial design: Field name Data type description Membership id Auto number Unique primary key Title Text Title if member First name Text Game information Last

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

    It will then give you a drop down list offering you different options - select "validation." 2) It will then ask for the validation criteria, you then select or enter in your requirements, either using the drop down menus, or your results table to insert your data ranges.

  1. ICT BTEC UNIT 2 - REPORT

    The only disadvantage I know of is that the program crashes sometimes but I think that's due to having an old outdated screen. Xsite Pro CPU = 1 GHz processor HDD Space = 512 Mb Graphics Card= Inno3D GeForce 8800 GTX Monitor Resolution = 1280*1024 RAM = 256 Mb Xsite

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

    The main reason why I use solution 3: Computer based solution is much easier than the other two manual solutions, as we can just open the computer application and start working on it, on multiple tables in the databases. We can also do many calculations in the database.

  1. Project 1b; Film Database

    The following screen print is a result of typing in the word 'mixture' in the data field genre for a film: The next error message will demonstrate the result of typing in 'xy' in the data field certificate: There are two more questions that could have been asked by customers, which are harder to answer.

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

    Databases are programs that can store information into files. This sort of database is very useful and ideal for designing filing systems on hospitals, surgeries and at a dentist or Doctor, though for financial business data it will not be as appropriate.

  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

    to add new loans Appendix 21 Appendix 21 shows that the wizard asked me if I wanted to name the command button or I wanted to use a picture for the command button. I decided to use text instead of picture as this would be easier for the user to

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