Microsoft Office Tutorials and References
In Depth Information
ASSIGNMENT 1: CREATING THE DATABASE DESIGN
mistakes. Then I put the date at the top and usually include an order number that I have created.
Afterthatheading,Ilisttheitemthecustomerwants,includingsize,color,andquantity.
YOU: What other information would you like to get out of the database?
SUSAN: I would like to be able to take orders quickly, because certain times are very busy for me. In
addition, my market is college students, who are often on a limited budget. I would like to be
able to show them which items are cheaper than $20. I would also like a way to change prices
easily, because the cost of textiles is rising fast.
YOU: I can create a form for you to enter the orders quickly, and queries will help you with the other
two tasks. I can also help you analyze your sales with specific queries that might help you sell
more in the future. Can you think of some marketing analysis that would be helpful?
SUSAN: I would love to see a listing of the best-selling products, the best-selling colors, and a list of who
my best customers have been. That way, I can send them coupons for future work and hope to
increase sales.
YOU: How about creating the bills to send out to customers?
I would like to have a list of all my customers with their orders individually noted, and a
summary of what they owe me. I could pass the list on to my collection agency, which handles all
my unpaid bills. In addition, I often give a 10% discount to customers in the next city, Glendale,
to create more repeat business.
SUSAN:
ASSIGNMENT 1: CREATING THE DATABASE DESIGN
In this assignment, you will design your database tables using a word-processing program. Pay close attention to
the tables
logic and structure. Do not start developing your Access code in Assignment 2 before getting
feedback from your instructor on Assignment 1. Keep in mind that you will need to examine the requirements in
Assignment 2 to design your fields and tables properly. It is good programming practice to look at the required
outputs before beginning your design. When designing the database, observe the following guidelines:
￿
First, determine the tables you will need by listing the name of each table and the fields it
should contain. Avoid data redundancy. Do not create a field if it can be created by a
calculated field
in a query.
￿
You will need transaction tables. Think about what business events occur with each customer
s
actions. Avoid duplicating data.
￿
Document your tables using the table feature of your word processor. Your tables should
resemble the format shown in Figure 4-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 4-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 REPORT
In this assignment, you will first create database tables in Access and populate them with data. Next, you will
create a form, six queries, and two reports.
Search JabSto ::




Custom Search