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