|
Use Access to complete the following steps:
|
a)
|
Open
BOOKS, which is an
Access data file.
|
|
|
|
|
b)
|
Create a simple form for the Suppliers table and
apply the Foundry predefined format.
|
| |
|
|
c)
|
Update the Books Unlimited contact name to be
Jane Leahman instead of Susan Wang.
|
| |
|
|
d)
|
Sort the Suppliers table by Supplier Name in
descending order.
|
| |
|
|
e)
|
|
| |
|
|
f)
|
Create an
Orders table for
storing information on books ordered from suppliers:
|
|
|
|
|
|
Field Name
|
Data Type
|
Description
|
Size
|
Decimals
|
|
|
Order ID
|
Text
|
ID number for the order
|
2
|
|
|
|
Supplier Name
|
Text
|
Supplier company name
|
25
|
|
|
|
Order Total
|
Currency
|
Amount of the order
|
|
2
|
|
|
|
|
g)
|
Modify the Orders table so that the Supplier
Name field is a lookup field that looks up values in the
Supplier Name field of the Suppliers table.
|
|
|
|
|
h)
|
Create a simple form for the Orders table and
apply the Foundry predefined format. Enter the following four
records:
B1; Books Unlimited; 739.35
B2; Book Depot; 40.32
B3; Tons of Books; 286.22
B4; Books Unlimited; 94.10
|
| |
|
|
i)
|
|
| |
|
|
j)
|
|
| |
|
|
k)
|
Format the Orders table datasheet appropriately
.
|
Print the following:
- Snippet of the Relationships window.
- Snippet of the 1st record of the Orders form.
------------------------------------------------------------------------------------------------------------------------------
Ch 9 Practice Application Test (yes, this will be worth 10 pts)
Use Access to complete the following steps:
|
a)
|
Open
TOYS,
which is an Access data file.
|
|
|
|
|
b)
|
Create a simple form for the
Suppliers table and apply the Foundry predefined format.
|
| |
|
|
c)
|
Update the Daisy Dolls contact
name to be Tina Juarez instead of Scott Hankins.
|
| |
|
|
d)
|
Sort the Suppliers table by
Supplier Name in descending order.
|
| |
|
|
e)
|
Print preview and then print a
copy of the Suppliers table using the appropriate orientation.
|
| |
|
|
f)
|
Create an
Orders table for
storing information on toys ordered from suppliers:
|
|
|
|
|
|
Field Name
|
Data Type
|
Description
|
Size
|
Decimals
|
|
|
Order ID
|
Text
|
ID number for the order
|
2
|
|
|
|
Supplier Name
|
Text
|
Supplier company name
|
25
|
|
|
|
Order Total
|
Currency
|
Amount of the order
|
|
2
|
|
|
|
|
g)
|
Modify the Orders table so that
the Supplier Name field is a lookup field that looks up values
in the Supplier Name field of the Suppliers table.
|
|
|
|
|
h)
|
Create a simple form for the Orders table and
apply the Foundry predefined format. Enter the following four
records:
T1; Pop Games; 189.45
T2; Daisy Dolls; 88.76
T3; Tons of Toys; 246.93
T4; Daisy Dolls; 60.85
|
| |
|
|
i)
|
Modify the Orders form to include the
TOYS LOGO, which is a data file.
|
| |
|
|
j)
|
Print preview and then print the
first record only in the Orders form.
|
| |
|
|
k)
|
Format the Orders table
datasheet appropriately and then print a copy of the Orders
table.
|
Print the following:
- Snippet of the Relationships window.
- Snippet of the 1st record of the Orders form.
|