Shelly Cashman Access 365 | Module 2: Sam Project A Connect Marketing Group

If you directly want to get the project from us then contact us on Whatsapp. Click on link below👇👇
https://wa.me/message/PPXGSJS2TLWUA1

Whatsapp Contact Number:
+91 8114420233

Email ID:
[email protected]

PROJECT STEPS
1. Connect Marketing Group is a national company that provides marketing services such as contact research, brand building, and merchandising to retail stores. As a sales analyst, you need to query the database to help make decisions and to answer questions from other employees.

Create a query based on the Contacts table in Query Design View with the following options to list contacts and their birthdates:
a. Add the ContactID, FirstName, LastName, and DateOfBirth fields to the design grid in that order.
b. Sort the records in Ascending order by LastName.
c. Save the query using ContactLastNameSorted as the name.
Open the query in Datasheet View, then close it, saving if necessary.
2. Open the AccountBillings query in Design View and make the following changes to the query to select accounts with monthly billings over $500:
a. Delete the ContactID column from the design grid.
b. Add criteria to select only those records where the MonthlyBill field value is greater than 500.
c. Save the changes to the AccountBillings query.
Open the query in Datasheet View, then close it, saving if necessary.
3. Open the HighBillOrContract query in Design View and add criteria to select only those records where the MonthlyBill field values are greater than 1000 or the ContractTotal field values are greater than 2000000. Save the changes to the query. Open the query in Datasheet View, confirm that 6 records appear in the HighBillOrContract query results, then close the query, saving if necessary.
4. Open the ContactBirth query in Design View and make the following changes to the query to list contacts with birthdates before January 1, 1990:
a. Add the FirstName field to the query design grid. The FirstName field should immediately follow the ContactID field.
b. Add criteria to select only those records where the DateOfBirth field value is less than 1/1/1990.
c. Set the format to Medium Date for the DateOfBirth field.
d. Set the caption to BirthDate for the DateOfBirth field.
e. Save the changes to the ContactBirth query.
Open the query in Datasheet View, confirm that the results match Figure 1, then close it, saving if necessary.
Figure 1: ContactBirth Query Results



5. Open the StateCitySort query in Design View and make the following changes to organize contacts first by state and then by cities within each state:
a. Move the State field to the beginning of the design grid so that the order of the fields in the grid is State, City, FirstName, and LastName.
b. Sort the records in Descending order by the State field and in Ascending order by City.
Save the changes to the query. View the query in Datasheet View, then close it, saving if necessary.
6. Open the HighBillAndContract query in Design View and add criteria to select only those records where the MonthlyBill field values are greater than 1000 and the ContractTotal field values are greater than 2000000. Save the changes to the query. Open the HighBillAndContract query in Datasheet View, confirm that 1 record appears in the query results, then close the query, saving if necessary.
7. Open the FloridaContacts query in Design View and change the criteria to select only those records where the State field value is FL. Save the changes to the query. Open the query in Datasheet View, confirm that 4 records appear in the query results, then close the query, saving if necessary.
8. You need to find a contact from a particular city, but you know only that the city name begins with "Ba". Open the ContactCity query in Design View and add criteria to select only those records where the City field value begins with the letters Ba. Save the changes to the query. Open the query in Datasheet View, confirm that 3 records appear in the query results, then close the query, saving if necessary.
9. You want a query that displays the contact name rather than the contact ID for each account. Create a query in Design View based on the Contacts and Accounts tables with the following options:
a. Add the Contacts table and the Accounts table to the design window.
b. Add the LastName field from the Contacts table to the design grid.
c. Add the AccountNumber and ContractTotal field from the Accounts table to the design grid.
d. If necessary, join the Contacts table and the Accounts table by drawing a line from the ContactID field in the Contacts table to the ContactID field in the Accounts table. (Hint: Because the field names are identical in both tables, the join line may already appear in Design View. Do not attempt to recreate the line if it is already present.)
e. Save the query using Contact-Account as the name.
Open the query in Datasheet View, then close it, saving if necessary.