The current database section found through the office button

Assignment Help Database Management System

Reference no: EM13756961

Creating and Using DatabasesContext:

Your company wants you to create a call messaging database application. The operator will record the received calls directly into your application. The recipients will be able to find out about their calls from their workstation.

Use the Access Final Project 1 database to carry out this project.

PART 1:

Add the Windows User field (text, maximum of 20 characters) to the Recipients table.

1. Clear the existing recipients from the Recipients table.

2. Enter your name and Windows user code in the Recipients table.

3. Enter two other names and Windows user codes into the Recipients table.

4. In the Current Database section found through the Office Button, add Add Messages-Operator's Version as the application title.

5. Make the start-up form Unread Messages open automatically when the application starts.

6. Split the table in two using the Access Database button, and name the Back-end database Message Data.

7. Close your database.

8. In Windows, rename the file Access Final Project 1.accdb as Messages-Operator's Version.accdb.

9. Copy the Messages-Operator's Version.accdb file, and name the copy Messages-Recipient Version.accdb. Take note that these files contain the programs, the first file is for the operator and the renamed version is for the recipients (users).

PART 2:

Now open the Messages-Recipient's Version.accdb file in programming mode by pressing the Shift key as you open it.

Change the Unread Messages query to Recipient Messages.

10. Remove the criteria from the Status Code column, allowing all the messages to be displayed.

11. Add ReadUser() as the criteria for the Windows User field so that users can read only their own messages.

12. Add a descending sort on the Degree of Urgency Code field for the more urgent messages to be shown first. This is based on the fact that a 3 is the most urgent while a 0 is the least urgent.

13. Change the Call Number sort order to ascending for the messages to be displayed in chronological order. Also, make sure that the Degree of Urgency Code field has priority in the multiple sort.

14. Close the query.
Attachment:- Access_Final_Project.rar

Reference no: EM13756961

Questions Cloud

Write appropriate connectivities and cardinalities in erd : Use the following business rules to create a Crow's Foot ERD. Write all appropriate connectivities and cardinalities in the ERD. For each rule below

Understanding of the major differences in reported financial : Demonstrate an understanding of the major differences in reported financial results when using US GAAP vs. IFRS and the impact on analysis.

Decision making be the same as for mass merchandising : Describe how what was learned in this mass merchandising industry could be applied to the logistics challenges in some other industry.

Translate business requirements into systems : Perform modelling to assist with analysis and decision making, Translate business requirements into systems by applying appropriate SDLC methodologies and incorporating industry best practices

The current database section found through the office button : In the Current Database section found through the Office Button, add Add Messages-Operator's Version as the application title. Make the start-up form Unread Messages open automatically when the application starts.

Executing strategies in a global environment : Analyze Federal Express's value creation frontier, and determine which of the four building blocks of competitive advantage the company needs in order to continue to maintain above-average profitability. Provide a rationale to support the response

Intentional misrepresentation of financial statements : Research the Sarbanes-Oxley Act and prepare a presentation that pertains to intentional misrepresentation of financial statements, and describe the maximum penalty that the chief executive officer (CEO) and the chief financial officer (CFO) could ..

How did southern states try and reestablish conditions : How did southern states try and reestablish conditions before the Civil War?

Write an essay on effect of civilization and science fiction : Write an essay on Effect of civilization and science fiction. Fix the following points in essy- Your introduction is good, though you repeat/overuse the "many authors" phrase. Still, nice and clear. Good.

User Account

All Pages