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

    How certain are you when using Excel? ----------------------------------------------------------------------- 16. What features and functions are you aware of in Excel? ---------------------------------------------------------------------- ---------------------------------------------------------------------- 17. How do you work out the percentage of your students' marks? ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- ------------------------------------------------------------------------------ 18. Do you keep all your records? -------------------------------------------------------------------------- -------------------------------------------------------------------------- 19. Do you need any security in your new system?

  2. GCSE Calculator Project

    * Get feedback from silver surfers. * Evaluate and suggest improvements. * Implement Screen shots of completed calculator Calculator in Design view Calculator in Form view Testing Arithmetic Functions Number Key Pad I pressed all the numbers on the number keypad, the numbers were then displayed on the screen.

  1. Designing a Car Mechanic's Database

    able to recommend the customer somewhere else where the correct requirements are fulfilled. Each of these different functions may be using a database. If so, I may link the tables, for example, I could link spare parts and vehicles so the mechanics could find the full specs of a car they need a spare for.

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

    this on the criteria: Like"*"&[enter DVD id]&"*" like"*"&[enter DVD title]&"*" like"*"&[enter director name]&"*" like"*"&[enter actor name]&"*" This in the interface that the user will see after the search for the query has been finish. > MEMBERS QUERY On the members query I have set up three different parameter to allow the use easier access to the information the may need.

  1. Computer project Alevels

    The entry must be 7 characters long. The first letter must be the letter M, the second letter must be C, and the third letter must be P followed by 4 numbers. E.g.: MCP1234 DATE Date/Time TIME Date/Time ILLNESS Text TREATMENT DESCRIPTION Text REMARKS Text Specification of Item Field Name Data type Validation Rule Validation Text ITEM_ID

  2. GCSE Database Project ICT

    If a patient wishes to edit a telephone number, or an address the receptionist scribbles out the previous information and fits it in above the scribble, if there is not enough room the secretary gets a white label, covers the incorrect/outdated part and writing on that.

  1. GCSE Excel Project ICT

    Mail Merge is also available but can be quite had to control and set up. Also with excel formulae can be inserted to control and manipulate the data inserted. Links and macros to other workbooks and sheets increase versatility of this program.

  2. 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?

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