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

Shelly Cashman Access 365 | Modules 1-3: SAM Capstone Project A | Banner Consulting |

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 Capstone Project A 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 in Datasheet View with the following options to store data about employees who supervise the fundraising events: a. Rename the default primary key ID field to EmployeeID and change the data type to Short Text. (Hint: EmployeeID should remain the primary key.) 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 with the name Employees and close the table. 2. Add data to the Employees table as follows: a. Use the Import Spreadsheet Wizard to import the data from the Support_AC365_CS1-3A_Employees.xlsx file and append it to the Employees table. Do not save the import steps. b. Open the Employees table in Datasheet View to confirm that it contains 15 records and then close the table. 3. Create a new table in Design View 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. Change the field size to 4. 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. Save the table with the name Departments and switch to Datasheet View. 4. With the Departments table open in Datasheet View, add the record shown in Table 1. 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. Open the Participants table in Datasheet View and delete the record for the participant with a ParticipantID of PA004 (Antoinette Pugh) since that participant is no longer involved in the fundraising programs. 6. Switch to Design View for the Participants table and make the following changes 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. With the Participants table still open in Design View, add a new field as follows to indicate each participant's status: a. Add a field with the name Status to the end of the table. b. Select Lookup Wizard at the data type. c. Select the option to type in your own values. d. Type the following three values (in the order shown) as the list of possible values for the field: Employee, Guest, and Student. Limit the field values to only the items in the list and do not allow multiple values for the field. Save the changes to the table and close it. 8. Open the Booths table in Design View and perform the following tasks to refine the fields in the table: a. Make the BoothID field the primary key of the table. b. Change the field size of the BoothID field to 4. c. Change the data type of the BoothCost field to Currency with 0 decimal places. d. Add 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: Because a field size was reduced, a warning message appears asking if you want to test the data. The data is valid, so ignore this message and continue saving the table.) 9. Open the Sponsors table in Datasheet View and make the table display more meaningful information as follows: a. Sort the records in ascending order by SponsorName. b. Add the Total row to the datasheet and calculate the Sum for the Amount field. c. Resize the Amount field to its best fit to display the entire total. **More