Shelly Cashman Access 365/2021 | Modules1-3 Sam Capstone Project 1a #shellycashman #modules1-3
If you directly want to get the project from us then contact us on our Whatsapp. Link is given here,
Whatsapp Contact Link:
[ Ссылка ]
Whatsapp Contact Number:
+91 8114420233
Email ID:
excelprojectshelp@gmail.com
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_AC365_2021_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.
9. Use the Report Wizard to create a report for the Attendees table with the following options:
a. Include the LastName, FirstName, City, and State fields.
b. Do not add any grouping levels.
c. Sort the records in ascending order by LastName.
d. Select the Tabular layout and the Portrait orientation.
e. Assign the title AttendeeLocations to the report.
View the report and then close it.
10. Create a query in Design View for the Attendees table with the following options:
a. Include the LastName, FirstName, City, and State fields in the query design grid.
b. Sort the records in ascending order by LastName.
c. Add criteria to select only those records where Philadelphia is the City.
d. Save the query using PhiladelphiaAttendees as the query name.
Open the query in Datasheet View and then close it
shelly cashman excel 2019 | module 1: sam project 1b,new perspectives word 2019 | module 10: sam project 1a,new perspectives excel 2019 | module 2: sam project 1a,new perspectives excel 2019 module 1 sam project 1a,new perspectives excel 2019 | module 10: sam project 1b,module 5 sam project 1a,modules 1-4: sam capstone project 1a,new perspectives excel 2019 | module 1: end of module project 2,module 1: sam project 1a,#shelly cashman excel 2019 | module 1: sam project 1b
