Can you please help me on Microsoft Access? Can you please send me the file? Thanks in advance!

• You have just begun working at the head office of Bob's Maintenance.Currently, when tools or material are ordered, they use a paper based Purchase Order system.
• A purchase order (PO) is a document issued by a buyer to a seller, indicating the product, quantities and agreed prices for products or services that the seller will provide to the buyer.POs also usually specify additional conditions such as terms of payment and required delivery date.
• Another benefit of using PO's, is that when the selling company delivers their invoice to the purchasing company, they include the PO number on the invoice.This allows the purchasing company to verify invoices against their own PO system, ensuring invoices reflect what was ordered.
• Your task is to automate this process, by creating a system in Access.Create the application on your Desktop.Name the Access file as your last name.You will create the system using tables, forms, queries and reports.
• You can useAlt-Tab to easy jumpbetween these questions and your Access file.
• The system will use tworelated tables described below.Create the tables according to the following data dictionary.

You will have to modify the information below to account for the relationship you'll be setting up.Each Product could be on many Purchase Orders.

Products

Field

Data Type

Other Criteria

ProductID

Short Text, 2

Set as a Primary Key.

Description

ShortText 15

Set as Required.

Price

Currency, 2 decimals.

PO

Field

Data Type

Other Criteria

PO

Autonumber

Set as a Primary Key.

Supplier

ShortText, 10

Phone

ShortText, 15

Use an Input Mask.

Quantity

Number, 0 decimals

Don't allow negative values.

PaymentTerms

ShortText, 15

Lookup, see #3 below.

OrderDate

Date

Set default to today's date and

don't allow entry of future dates.

Received

Yes/No

1.Create the tables as above.You will add records in questions 4 and 5below...........................__/15

2. Create the proper relationship between the two tables. Enforce Referential Integrity..............__/15

3. Create Lookup for the four options of terms for PaymentTerms, with the values as

Net 30,

3/10, Net 30,

2/10, Net 30

1/10, Net 45..............................................................................................................................__/10

Forms:

4.Create columnar form allowing entry of data into the Products table.

Name itProduct Update.Add 4 products into the table. (Make them upyourself)....................__/10

5.Create form with a subform allowing entry of new Purchase Orders.Use all fields from both tables.

Name itAdd Purchase Orders.Create 10 or more purchase orders.Set three of them as received.

Enter reasonable values for the other information.Use your namein the Supplier

field in the first record.................................................................................................................__/10

Queries:

6.Create Query that will use all fields in both tables, but only return purchase orders

that have not been received.Name itNot Received.................................................................__/10

7.Create Query namedOlderthat will return the PO, Supplier, Description, Price and OrderDate

for orders older than a certain date.You pick the date...............................................................__/10

8.Create parameter Query that will return all the fields from the PO table and the Description from

the Products table, but only for a certain ProductID.

You should be prompted for the ProductID when it runs.Name this queryParameter............. __/10

Report:

9.Create report calledNot Receivedthat will display purchase orders that have not been received.

It should list the Supplier, Description, Price, Quantity, Phone and OrderDate.

Group it on Description and include group totals........................................................................__/10