7Shawtys
Explain the how to do the following “access exam” for test out:…
Explain the how to do the following “access exam” for test out: Exam: access test sample
QUESTION 1 OF 2
In this scenario, you’re working for Paul’s Power Tools. You want to make an Access database to keep track of products, customers, and sales. You’ve already created some tables with records, and you’ve designed a couple of queries. Now you need to create forms and reports. Perform the following tasks in order:
Forms:
Make an autoform based on the Customers table. Save the form and give it the name Customers
On the Products form, do the following:
1. Delete the primary key eld and label.
2. Change the productName label to Product Name and the productType label to Product Type.
3. Add a button to the Products form that creates a new record.
Save the Products form when you’re done.
Reports:
Use the Report Wizard to make a report based on the List of Sales query. Add all four elds to the report. Group the data by productName. Use the default values for everything else. Name the report Sales by Product and save it.
On the Customers report, do the following:
1. Remove the dark outlines from the names.
2. Change the rstName and lastName labels to First Name and Last Name. 3. Change the theme of the report.
Save the Customers report when you’re done.
?
If you do not SAVE forms and reports after altering them, you will not receive points for this lab.
QUESTION 2 OF 2
In this scenario, you’re working for Paul’s Power Tools. You want to make an Access database to keep track of products, customers, and sales. Perform the following tasks in order:
Tables:
Make a new table called Customers. This table should have, in order, the following three elds:
1. An AutoNumber, Primary Key eld called CustomerID 2. A short text eld called rstName
3. A short text eld called lastName
Save the table when you’re done.
Append customers.xlsx to the new Customers table.
Use a formula to make the purchaseDate eld of the Purchases table return today’s date by default for all new records. Save the table when you’re done.
Table Relationships:
Relate the primary key of the Customers table to its corresponding foreign key eld in the Purchases table. Enforce referential integrity for this relationship.
Relate the primary key of the Products table to its corresponding foreign key eld in the Purchases table. Enforce referential integrity for this relationship.
Queries:
Make a query called Revenue by Tool Type that contains the product type and cost elds from the Products table and the PurchaseID eld from the Purchases table. Show the sum of the cost, the count of PurchaseID, and group by productType. Save the query when you’re done.
Make a query called List of Sales that contains the rstName and lastName elds from the Customers table, the productName eld from the Products table, and the purchaseDate eld from the Purchases table. Save the query when you’re done.
I CAN”T DO ANY STEP WITH FORM OR REPORT WIZARD
