Shelly Cashman Access 2019 | Modules 1-3: SAM Capstone Project 1a | Instructions_SC_AC19_CS1-3a | Economic Development Conference
#ShellyCashmanAccess2019 #Modules1-3SAMCapstoneProject1a #Modules1-3 #SAMCapstoneProject1a #EconomicDevelopmentConference #Instructions_SC_AC19_CS1-3a
Contact Me:
WhatsApp : +92 3706149511
Email : mylab2342@gmail.com
Direct WhatsApp Link:
[ Ссылка ]
#Shelly Cashman Access 2019 | Modules 1-3: SAM Capstone Project 1a
#Shelly Cashman Access 2019
#Cashman Access 2019
#Access 2019
#Modules 1-3: SAM Capstone Project 1a
#Modules 1-3
#SAM Capstone Project 1a
#Capstone Project 1a
#Project 1a
#Modules 1-3: SAM Capstone Project
#SAM Capstone Project
#Capstone Project
#Project
#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 to AdvertiserID and change the data type to Short Text. (Hint: AdvertiserID should remain the primary key.)
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. Use the Import Spreadsheet Wizard to import the data from the Support_AC19_CS1-3a_Advertisers.xlsx file and append 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 and the Short Text data type. Change the field size to 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 and switch to Datasheet View.
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 Sponsors 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 delete the record for the attendee with an AttendeeID of TL001.
6. Switch to Design View for the Attendees table and make the following changes:
a. Change the name of the Street field using Address as the new field name.
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. Use the Simple Query Wizard to 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. Use the Form Wizard to 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.
