Microsoft Office Tutorials and References
In Depth Information
ASSIGNMENT 2: CREATING THE DATABASE, QUERIES, AND REPORTS
￿
Keep in mind that all customers are known only by ID numbers for security and privacy reasons.
￿
Document your tables using the table feature of your word processor. Your tables should
resemble the format shown in Figure 5-1.
￿
You must mark the appropriate key field(s) by entering an asterisk (*) next to the field name.
Keep in mind that some tables might need a compound primary key to uniquely identify a
record within a table.
￿
Print the database design.
Table Name
Field Name
Data Type (text, numeric, currency, etc.)
FIGURE 5-1
Table design
NOTE
Have your design approved before beginning Assignment 2; otherwise, you may need to redo Assignment 2.
ASSIGNMENT 2: CREATING THE DATABASE, QUERIES, AND REPORTS
In this assignment, you will first create database tables in Access and populate them with data. You will
create a table that records delivery data and another that records withdrawal data. Next, you will create two
forms, nine queries, and two reports.
Assignment 2A: Creating Tables in Access
In this part of the assignment, you will create your tables in Access. Use the following guidelines:
￿
Enter 10 records for guards in the tables. Use the names and addresses of your friends and
relatives to create records for the guards.
￿
Assume that PMD holds four precious metals: gold, silver, platinum, and palladium. Each type
comes in either bullion or coins.
￿
Create a large number of transactions for metals being delivered and withdrawn. Consider using
Excel to generate data for some of the tables. You might choose to use the =randbetween
function in Excel to generate random numbers within a range you specify. You then
can import the Excel-generated data into a new Access table. (For details, see the section on
importing data in Tutorial B.)
￿
Create a large number of hours worked for the guards. Again, consider generating plenty of data
in Excel.
￿
Appropriately limit the size of the text fields; for example, a zip code does not need the default
length of 255 characters.
￿
Print all tables if your instructor requires it.
Assignment 2B: Creating Forms, Queries, and Reports
You will create two forms, nine queries, and two reports, as outlined in the Background section of this case.
Form 1
Create a form based on your table that records delivery data. Use all the fields in your table to create the
form. Name the form Deliveries. Your data will vary, but the output should resemble that in Figure 5-2.
Search JabSto ::




Custom Search