Spring 1997 Tsai
Spring 2007 Tsai
CALIFORNIA STATE UNIVERSITY, SACRAMENTO
School of Business Administration
MIS 101 – Computer Information System Management
Access Practice
1. Create a new Microsoft Access database named MIS101.MDB.
2. Within the database MIS101.MDB, create a table named Customer by importing the data from the worksheet named Customer in the Excel workbook file named MIS101AccessPracticeData.xls. Create a second table named Agent by importing the data from the worksheet named Agent in the same Excel workbook file.
3. Create a one-to-many relationship between Customer table and Agent table. Save the relationship diagram as a report named CustomerAgentRelationship.
4. Create a query named All having the following information: Agent’s LastName, Customer’s SSN, Customer’s AccountType, TotalAmount, and Agent’s DateHired. The TotalAmount is equal to UnitPrice times Share. Sort records according to the Agent’s LastName.
5. Create a query named Deluxe having the following information: Agent’s LastName, Customer’s SSN, Customer’s AccountType, TotalAmount, and Agent’s DateHired. The TotalAmount is equal to UnitPrice times Share. The Deluxe query contains the information of Deluxe or Corporate account types for those agents hired before year 2001. Sort records according to the DateHired in descending order.
6. Create a report named AllRep that is based on the data in the All query. The report header should have a title as “Agent Account Analysis” in the center, date in the upper left corner, and your group number in the upper right corner. The group header of each group contains Agent’s LastName and DateHired. The detail section contains Customer’s SSN, Customer’s AccountType, and TotalAmount. Sort records according to the Account type in the detail section. Each group footer contains average and sum of the TotalAmount for each agent. The report footer contains the average and sum of the TotalAmount for every agent.
7. Create a report named DeluxelRep that is based on the data in the Deluxe query. The report header should have a title as “Senior Agent Account Analysis” in the center, date in the upper left corner, and your group number in the upper right corner. The group header of each group contains Agent’s LastName and DateHired. The detail section contains Customer’s SSN, Customer’s AccountType, and TotalAmount. Sort records according to the Account type in the detail section. Each group footer contains minmum and maximum of the TotalAmount for each agent. The report footer contains the minimum and maximum of the TotalAmount for every agent.
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- intermediate access maine
- spring 1997 tsai
- powerpoint practice actvities weebly
- microsoft access lab
- hspd 12 logical access authentication and microsoft active
- introduction to access maine
- programming tutorials exercises tips questions
- atg 383 excel access project spring 2002
- lab 2 introduction to ms access ken goldberg
Related searches
- 1997 f150 4.6 engine diagram
- 1997 f150 4.6 vacuum diagram
- 1997 aston martin db7 reliability
- 1997 f150 4 6 engine diagram
- 1997 f150 4 6 motor
- 1997 f150 4 6 engine specs
- playhouse disney 1997 games
- 1997 f150 repair manual pdf
- conspiracy theory 1997 free online
- 1997 f150 4 6 engine
- 1997 princess diana beanie baby price guide
- 1997 f150 parts diagrams