• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
Page
  1. 1
    1
  2. 2
    2
  3. 3
    3
  4. 4
    4
  5. 5
    5
  6. 6
    6
  7. 7
    7
  8. 8
    8
  9. 9
    9
  10. 10
    10
  11. 11
    11
  12. 12
    12
  13. 13
    13
  14. 14
    14
  15. 15
    15
  16. 16
    16
  17. 17
    17
  18. 18
    18
  19. 19
    19
  20. 20
    20
  21. 21
    21
  • Level: GCSE
  • Subject: ICT
  • Word count: 939

project 1B - Handling Data. Setting up my car database.

Extracts from this document...

Introduction

Project 1B - Handling Data PROJECT 1B - HANDLING DATA 1 WORKING WITH EXISTING DATA 2 COPYING A DATABASE INTO MY AREA 2 ANSWERING QUESTIONS ABOUT THE DATA 2 SORTING DATA 3 EDITING DATA 3 ADDING NEW DATA 5 WORKING WITH NEW DATA 5 CREATING A DATA CAPTURE FORM 6 COLLECTING DATA WITH A DATA CAPTURE FORM 7 CREATING A NEW TABLE IN THE CARS DATABASE 8 SETTING A VALIDATION RULE 9 TRANSFERRING DATA INTO THE TABLE 10 TESTING THE VALIDATION RULE 10 CHECKING FOR ERRORS AND EDITING THEM 11 QUERIES - ASKING QUESTIONS ABOUT THE DATA 12 REASONS FOR CHOICE OF SOFTWARE 20 REASONS FOR CHOICE OF FIELDS, DATA TYPES & LENGTHS 21 A TASK 21 IS THERE A TREND TOWARDS CARS WITH BOOTS OR CARS WITH HATCHBACKS? 21 Working with Existing Data Copying a Database into My Area First I opened a new Database in Microsoft access I name it cars then I save it in my user area. I also copy and paste project 1B to a new folder in my area. ...read more.

Middle

Transferring Data into the Table This is the table shows the whole cars database I create table in Microsoft Access. Testing the Validation Rule In my car database table all car have 3, 4 and 5 doors, when I typed '8' in database, a warning popped up on the screen. It means that validation rule is working properly. Checking for Errors and Editing them In this table I did spelling mistake like 'Rovear' but the right spelling is 'Rover' so I did the correction. In this table it shows the correct spelling of Rover. Queries - Asking Questions a About the data Simple Queries How many cars are blue? There are 13 blue cars. In this query my question was how many cars are blue. This table shows the number of Blue cars. How many cars are Fords? There are 2 Fords. In this Query how many cars are ford (So I found out all of ford cars in my car database) Now I fund out all ford cars in my car database. ...read more.

Conclusion

The results came back showing no Ford cars that were red or blue. My own Complex Query How many BMWs are either silver or black? There are 17 BMWS are silver or black. The result shows 17 BMW cars silver and black. Reasons for Choice of Software I have chosen Microsoft Access for my project 1B which is about car database. Spreadsheets can be used as a database. In Excel you can add a filter that will help you to sort data more quickly. The biggest advantage of using a database instead of a spreadsheet is the ability to search and sort information contained in the database. Microsfot Access provides means to perform not only the simple search needed but also complicated searches based on an unlimited number of search criteria. For example I created simple and complex Queries to search information from my car database. A Task Is there a trend towards cars with boots or cars with hatchbacks? Reasons for Choice of Fields, Data Types & Lengths Software Required Output Required Fields Format Doing the task? How easy or difficult was it? ?? ?? ?? ?? Page 1 of 21 Last printed 18/07/2007 10:49:00 ...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 ICT Systems and Application 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 ICT Systems and Application essays

  1. GCSE Database Project ICT

    The system is primarily a database function, which links together using tables. Once data is inserted to the tables, they can be checked with data Validation and edited easily input forms can be created to enable to user to insert data easier.

  2. ICT Project 1A

    Firstly there was the lack of webpage's actually available about them. When I started I was quite lost and was just looking for general information. When I typed in Tokio Hotel Band Google found little over 350,000 websites. Though this seems like quite a lot when I searched for other

  1. ICT PROJECT

    Do you need any security in your new system? ------------------------------------------------------------------------- ------------------------------------------------------------------------ 20. Do you have any additional questions ------------------------------------------------------------------------ ------------------------------------------------------------------------- ------------------------------------------------------------------------- Statement of User Requirements Ms Gammon feels a computerised system will solve some of her current problems as she thinks she has some knowledge about Excel. She feels I will be able to create an effective, fast, and

  2. GCSE Excel Project ICT

    Choice of output method justified The output method I have the preposition to use is the printed method, as it the most effective system as it prevents confusion between sold products, it also safeguards against errors as the customer takes the copy to Alex, which he then rings up to

  1. Database Analysis and Database Design Project - DVD library for moving images.

    On the joining date I used as default value Date() which means the actual day that is set in the computer, it will change as soon as the date on the computer changes.

  2. Computer project Alevels

    Please enter either Male or Female. NIC NO Text PICTURE OLE Object NOTES Text Table - Daily Treatment Field Name Data type Validation Rule Validation Text PATIENT_ID Text Like "MCP####" Text you entered is invalid in the field PATIENT_ID. The entry must be 7 characters long.

  1. ICT - making a database of used cars.

    Have you got any cars that are diesel? 3. Which four door cars do you have? 4. Which cars do you have that are below �5,000? 5. Which cars do you have that have done less than 7,000 miles? 6. Can you show me a list of black cars?

  2. Database project

    A list of all the customers and their contact details. 2. A list of all planes that are currently rented out and who by. 3. A list of all the planes that are overdue and who by. 4. A list of all rentals for a particular day.

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