Answering Questions about the data
How Many Fields are there?
There are 2 fields.
How many Records are there?
There are 21 many records
What Identifier represents the year 1983?
A identifier goes to with 1983.
What year is represented by the identifier ‘T’?
1998 represented by the identifier ‘T’
Sorting Data
I used this button to sort out the Data
Editing Data
I changed the data from R
To 1997
Adding New Data
My teacher asked me where 2007 is.
I added some new data from 2001 to 2007.
Working with New Data
Creating a Data Capture Form
I used Microsoft Excel for Creating a Data capture form.
Collecting Data with a Data Capture Form
I opened the Microsoft Excel to create a data capture form to collect my data.
Creating a New Table in the Cars Database
I used Microsoft Access to create table to put in my car data. I used design view for table field Name and data type.
Setting a Validation Rule
I used validation rule for number of door data because the number of the car doors can not be less than 2 and bigger than 5.
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.
My own simple query
How many cars are BMW?
There are 22 BMW cars.
My own simple query is how many BMW cars I have in my car database.
My simple query was about BMW and this table shows the BMW cars number.
Queries on Queries
How many blue cars have 4 doors?
There are 2 blue cars have 4 doors.
In query about it shows how many blue cars have got 4 doors. I wrote blue in colours =4 in number of doors.
This table shows 2 blue cars have 4 doors.
How many Fords have 5 doors?
There are 11 Fords cars have 5 doors.
In this simple query I wrote blue in colour and 5 in number of doors.
So this table all so shows blue cars and have 5 doors.
My own Query on a Query
How many BMW cars are having 5 doors?
There are 19 BMW cars have 5 doors
My own simple query was about the make of BMW and have 5 doors.
Complex Queries
How many blue Fords with 4 doors?
None
How many Fords are either red or blue?
I entered ford twice in the same column and blue and red in the colour column. 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?