Shelly Cashman Access 365 | Modules 1-3: SAM Critical Thinking Capstone Project C | скачать в хорошем качестве

Shelly Cashman Access 365 | Modules 1-3: SAM Critical Thinking Capstone Project C |

Please contact us if you need this project or any other projects in any subject to be completed. WhatsApp: +1-343-321-3276 Email: essayserviceusa@gmail.com WhatsApp Link: https://wa.me/13433213276 Shelly Cashman Access 365 | Modules 1-3: SAM Critical Thinking Capstone Project C PROJECT STEPS 1. Banner Consulting is a nationwide consulting firm with headquarters in Ann Arbor, Michigan. The firm hosts community fundraising events throughout the year and encourages employees and their families to participate. You work in the Human Resources Department and help coordinate the events, using an Access database to track data about participants, sponsors, fundraising booths, and registrations. Create a new table with the following options to store data about employees who supervise the fundraising events: a. Use EmployeeID as the name of the primary key field and assign it the Short Text data type. b. Add a new field with the name EmployeeFirst and the Short Text data type to store employee first names. c. Add a third field to the table with the name EmployeeLast and the Short Text data type to store employee last names. d. Add a fourth field to the table with the name Department and the Short Text data type to indicate the employee's department. Save the table using Employees as the name and close it. 2. Add data to the Employees table as follows: a. Import the data from the Excel workbook file Support_AC365_CT_CS1-3C_Employees.xlsx and append the data to the Employees table. Do not save the import steps. b. Confirm that the Employees table contains 15 records and then close the table. 3. Create a new table with the following options to store data about Banner departments and the funds they allocate to fundraising events: a. Add a field with the name DepartmentID and the Short Text data type. Use 4 as the field size. b. Set DepartmentID as the primary key for the table. c. Add a field with the name DepartmentName and the Short Text data type to store department names. d. Add a third field with the name Budget and the Currency data type to store budget amounts. e. Use Departments as the name of the new table. 4. Add the record shown in Table 1 to the Departments table. Resize the DepartmentName field to display the entire field value. Save the changes and close the Departments table. Table 1: New Record for the Departments Table DepartmentID DepartmentName Budget D100 Administration $15,000 5. In the Participants table, delete the record for the participant PA004 (Antoinette Pugh) since she is no longer involved in the fundraising programs. 6. Make the following changes to the Participants table to clarify the purpose of one field and add another: a. Change the name of the Street field using the more accurate Address as the new field name. b. Add a new field to the end of the table with the name Phone and the Short Text data type to store participants' phone numbers. Save the changes but do not close the table. 7. Add a new field to the Participants table as follows to indicate each participant's status: a. Add a field with the name Status to the end of the table. b. Use Lookup Wizard as the data type. c. Select the option to type in your own values. d. Type Employee, Guest, and Student (in the order shown) as the list of possible values for the field. Limit the field values to the items in the list and do not allow multiple values for the field. Save the changes to the table and close it. 8. Refine the fields in the Booths table as follows: a. Make the BoothID field the primary key of the table. b. Use 4 as the field size of the BoothID field. c. Change the data type of the BoothCost field to Currency with 0 decimal places. d. Use the text Basic cost for a 10 x 10 booth as the description for the BoothCost field. Save the changes to the table and then close it. (Hint: Although you reduced a field size, the data is still valid.) 9. Modify the Sponsors table datasheet to make the table display more meaningful information as follows: a. Sort the records in alphabetic order by the name of the sponsor. b. Add the Total row to the datasheet and calculate the sum of the sponsor amounts. c. Resize the Amount field to its best fit to display the entire total. Save the changes to the table and close it. 10. Improve data-entry accuracy in the Registrations table as follows: a. Enter a validation rule for the RegistrationFee field to ensure that its values are greater than or equal to 100. b. Use Must be greater than or equal to $100 as the validation text to display to users. Save the changes to the Registrations table and close it. (Hint: Although you added a validation rule, the data is still valid.) 11. Create a form based on the Employees table with the following options: a. Include the EmployeeID, EmployeeFirst, EmployeeLast, and Department fields. b. Select the Columnar layout. c. Assign the title EmployeeEntry to the form. View the form and then .***More