Create the Car Database as shown below
Design View
Car Records
Use the car database to find the answers to the following questions
Use the table design view to find the following information
1 Which field is the primary key?
2 Which field has the data type ‘number’?
3 Which field has the data type ‘currency’?
4 Which field will only allow you to put yes/no into?
5 Which field will only allow 8 characters to be typed?
Use the table view to find the following information
6 How many records are in the database?
7 Sort the database on ‘price’ in ascending order. Which is the cheapest car?
8 Sort the database on ‘price’ in descending order. Which make would be the most expensive car?
9 Sort the database on ‘year’ in ascending order. Which is the oldest car?
10 Sort the database on ‘Make’ in descending order. Which make would be displayed first?
Create a query to answer the following questions
11 How many ‘Ford’ cars are in the database?
12 How many ‘Ford Ka’ are in the database?
13 How many different ‘Rover’ models are in the database?
14 How many cars were registered in 1999?
15 How many cars do NOT have tax?
16 How many cars cost less than £1000?
17 How many cars cost more than £4000?
18 How many cars cost less than £2000 AND do not have tax?
19 How many Red cars are there?
20 How many Vauxhall cars are White
21 How many Red cars cost more than £5000?
22 How many Silver cars were there in 1999?
23 What colour is the Renault Clio 2002?
24 What is the make of two cars that are Black and built in 1997?
25 How many cars are there between 2000 and 2003?
26 How many cars for 1999 are there which are NOT red?
27 How many cars are there in 1996 which are NOT silver and NOT a 406?
No comments:
Post a Comment