|
Step one:
|
Design a database with a single table with the following criteria:
-
The table will contain an inventory of a personal collection
(books, audio CD's or anything else that you might want
to keep track of in your database.)
-
You must use a minimum of six and a
maximum of eight fields in your table.
-
In addition to a unique ID field, your table must include at least two text
fields; two numeric fields and one date field.
-
Use a New blank database, save it on your student data disk and give it an
appropriate name (such as MyMusic). Create the table using Design View.
|
|
Step two:
|
After you have created the table's structure and saved it,Use the Acess Form
interface to create a data entry form for your database.
-
Your form should allow you to enter data for every field in your database.
-
Your form should have labels for each entry field so the user know what type
of data goes into each field.
-
When you are done, save the form giving it an appropriate name.
|
|
Step three:
|
After saving the form, switch from Layout View to Form View.
Use the input form to enter between 5 and 10 records of your inventory.
|
|
Step four:
|
Use the Access query interface to design the following 2 queries:
-
Design a query that allows you to print all the fields
for all the records in your database.
Assign an appropriate title to this query (e.g. "Books Collection").
-
Create a second query that selects only certain records from the inventory that meet a
particular criteria (such as, all items costing more than $10.00.) Include only three
or four pertinent fields in this query, rather than all the fields available.
Include the criteria used for the query in the query's title (e.g. "Books Priced Over $10").
|
Run your first query, take a screenshot of it and submit your screenshot as an
attachment in an email sent to me. Cut and paste the SQL statements for both
queries separated by the title for each query into the body of the email as well.