Скачать или смотреть Shelly Cashman Access 2019 | Modules 1-3: SAM Critical Thinking Capstone Project 1c | AC19_CT_CS1-3c

Shelly Cashman Access 2019 | Modules 1-3: SAM Critical Thinking Capstone Project 1c | Economic Development Conference | SC_AC19_CT_CS1-3c_FirstLastName_1


#ShellyCashmanAccess 2019 #Access 2019 #Modules 1-3 #Modules1-3:SAMCriticalThinkingCapstoneProject1c #SAMCriticalThinkingCapstoneProject1c #CapstoneProject1c #Project1c #SC_AC19_CT_CS1-3c_FirstLastName_1 #EconomicDevelopmentConference


Contact us:'

Gmail: [email protected]


WhatsApp : +923137134857


WhatsApp Link: https://tinyurl.com/3evzy692





#Shelly Cashman Access 2019 | Modules 1-3: SAM Critical Thinking Capstone Project 1c
#Shelly Cashman Access 2019
#Cashman Access 2019
#Access 2019
#Modules 1-3: SAM Critical Thinking Capstone Project 1c
#Modules 1-3
#SAM Critical Thinking Capstone Project 1c
#Critical Thinking Capstone Project 1c
#Thinking Capstone Project 1c
#Capstone Project 1c
#Project 1c
#SC_AC19_CT_CS1-3c
#AC19_CT_CS1-3c
#CT_CS1-3c
#CS1-3c
#Economic Development Conference


PROJECT STEPS
1. The Economic Development Professional Organization hosts an annual conference for its members, college students, and other interested persons to share new ideas, discuss problems, and brainstorm solutions. You are a conference coordinator responsible for registration. Create a new table in Datasheet View with the following options:
a. Rename the default primary key ID field as AdvertiserID and change the data type to Short Text.
b. Add a new field with the name AdvertiserName and the Short Text data type.
c. Add a third field to the table with the name ContactLName and the Short Text data type.
d. Add a fourth field to the table with the name ContactFName and the Short Text data type.
e. Add a fifth field to the table with the name Cost and the Currency data type. Save the table with the name Advertisers and close the table.
2. Import the data from the Support_AC19_CT_CS1-3c_Advertisers.xlsx file and append it to the Advertisers table. Do not save the import steps.
3. Create a new table in Design View with the following options:
a. Add a field with the name SponsorID, the Short Text data type, and a field size of 4.
b. Set SponsorID as the primary key for the table.
c. Add a field with the name SponsorName and the Short Text data type.
d. Add a third field with the name Amount and the Currency data type. Save the table with the name Sponsors.
4. With the Sponsors table open in Datasheet View, add the record shown in Table 1. Resize the SponsorName field so that the field value is completely visible. Save the changes and close the table.
Table 1: New Record for Sponsors Table

SponsorID SponsorName Amount
S020 Dynamic Growth $5,000

5. Open the Attendees table in Datasheet View, and then delete the record for the attendee with AttendeeID TL001.
6. Switch to Design View for the Attendees table and make the following changes:
a. Change the name of the Street field to Address.
b. Add a new field to the end of the table with the name CellPhone and the Short Text data type. Save the changes and close the table.
7. Create a query based on the Attendees table with the following options:
a. Include the AttendeeID, FirstName, LastName, and CellPhone fields in that order.
b. Save the query using AttendeeContactInfo as the query name. View the query results, and then close the query.
8. Create a form for the Advertisers table with the following options:
a. Include the AdvertiserID, AdvertiserName, and Cost fields.
b. Select the Columnar layout.
c. Assign the title AdvertiserCostData to the form. View the form and then close it.