Access Practice Test
Winter 2011
Todd's Car Sheet
|
Model
|
Car Company
|
Reliability
|
Cost
|
RX 330
|
Lexus
|
Exceptional
|
$35,000
|
RX 400h
|
Lexus
|
Exceptional
|
$42,000
|
Highlander
|
Toyota
|
Exceptional
|
$29,000
|
4Runner
|
Toyota
|
Exceptional
|
$32,000
|
X5
|
BMW
|
Good
|
$60,000
|
X3
|
BMW
|
Unknown
|
$38,000
|
A4
|
Audi
|
Good
|
$34,000
|
A6
|
Audi
|
Good
|
$48,000
|
Create a Table, Query, and Form. The Query should find all cars over $40000 that are Exceptional. Do not show the "Reliability Field". The Form is from the Table.
|
Sports Equipment
|
Item
|
Cost
|
Skis
|
$600
|
Golf Clubs
|
$1,200
|
Basketball
|
$30
|
Tennis Rachet
|
$80
|
Create a Table, Query, and Form. The Query should find all items over $600. The Form is from the Table.
| |