Access Modules 1-3: SAM Capstone Project 1b | Shelly Cashman Access 2019 | SC_AC19_CS1-3b скачать в хорошем качестве

Access Modules 1-3: SAM Capstone Project 1b | Shelly Cashman Access 2019 | SC_AC19_CS1-3b

To Get this Solution Contact us on WhatsApp or Email WhatsApp: +1 209 345 9376 Email address: schoolworkhelper664@gmail.com Whatsapp link : https://wa.link/t4mgjz The Preserve is an outdoor space with walking trails, vegetable gardens, trees, plants, and flowers. Create a new table in with the following options (I suggest you use “Design View”). Save the table with the name MemberTypes. a. Rename the default primary key ID field as MemTypeID and change the data type to Short Text. (Hint: The MemTypeID field should remain the primary key.) b. Add a new field with the name Description and the Short Text data type. c. Add a third field to the table with the name AnnualFee and the Currency data type. d. Add a fourth field to the table with the name GuestPasses and the Number data type. 2. Import the data from the Support_AC19_CS1-3b_MemberTypes.xlsx file a. Append the data to the MemberTypes table. b. Do not save the import steps. c. View the MemberTypes table to ensure you have 6 records 3. Create a new table in Design View. Save the table with the name Supporters. Add with the following options: a. Add a field with the name SupporterID and the Short Text data type. Change the field size to 4. b. Set SupporterID as the primary key for the table. c. Add a field with the name SupporterName and the Short Text data type. d. Add a third field with the name Amount and the Currency data type and switch to Datasheet View. 4. With the Supporters table open in Datasheet View, add the record shown in Table 1. SupporterID SupporterName Amount S012 Prime Sports Medicine $3,000 a. Resize the SupporterName field so that the field value is completely visible. b. Save the changes and close the Supporters table.Table 1: 5. Open the Members table in Datasheet View and delete the record for the 6. Switch to Design View for the Members table and make the following changes: a. Change the name of the ZIP field using PostalCode as the new field name. b. Add a new field to the end of the table with the name Mobile and the Short Text data type. Save the changes and close the table. 12. Create a query in Design View based on the Members and Registration tables with the following options: a. Add the Members and Registration tables to the design window. b. From the Members table: Add the LastName and FirstName fields c. From the Registration table: Add the RegistrationID, NumChild, and NumAdults fields d. If necessary, join the Members and Registration tables. MemberID is the common field in both tables. e. Open the query in Datasheet View (you should see LastName, FirstName,Registration, NumChild, NumAdults records) f. Save the query using MemberRegistration as the query name. 13. Open the OrStates query in Design View and make the following changes to the query: a. Move the State field so that it is the first field in the query grid. b. Add criteria to select only those records where the value in the State field is DE or MD. c. Sort the records in ascending order by the State field and then by the LastName field. Run the query - it should matche Figure 1. Save and Close the query Shelly Cashman Access 2019 | Module 1-3: SAM Project 1b # ShellyCashmanAccess2019 #module1-3 #samproject1b #Module1-3 #SAMProject1b #Module8SAMProject1b #SC_AC19_CS1-3b #ExcelModule8 #ShellyCashmanAccess2019ModuleCs1_3 #SAM #CENGAGE #FINALEXAM #Access Module CS1_3 SAM Project 1b #AccessModule1_3SAMProject1b #Access_Module_1-3_SAM_Project_1b #Access Module 1_3 Project 1b #AccessModule1_3Project1b #Access_Module_1_3_Project_1b #Access Module Cs1-3 SAM Project 1a #AccessModule1-3SAMEndofModuleProject1a #Access_Module_1-3_SAM_Project_1a #Illustrated Excel 2019 Module 1_3 Project 1a #IllustratedExcel2019Module11Project1a #Illustrated_Excel_2019_Module_1-3_Project_1a #shelly cashman excel 2019 module 1-3 end of module project 1a #shelly_cashman_excel_2019_module_1-3_end_of_module_project_1a #shellycashmanexcel2019module7endofmoduleproject1 #cengage #NP #Module1SAMProject1a #Module2SAMProject1a #Module3SAMProject1a #Module4SAMProject1a #Module5SAMProject1a #Module6SAMProject1a #Module7SAMProject1a #Module8SAMProject1a #Module9SAMProject1a #Module10SAMProject1a #Module11SAMProject1a #Module12SAMProject1a #Module_1_SAM_Project-1a #Module_2_SAM_Project-1a #Module_3_SAM_Project-1a #Module_4_SAM_Project-1a #Module_5_SAM_Project-1a #Module_6_SAM_Project-1a #Module_7_SAM_Project-1a #Module_8_SAM_Project-1a #Module_9_SAM_Project-1a #Module_10_SAM_Project-1a #Module_11_SAM_Project-1a #Module_12_SAM_Project-1a