1-For cutomer table, there should be columns for: ID, first name, last name , Ad

Question

1-For cutomer table, there should be columns for: ID, first name, last name , Add, city, state and zipcode

2- For product table, there should columns for: Product ID, Description, price,

3-For Invoice, there should a form that has the Customer and product info info in it.

4- For Invoice Line Item, there should be Line ID, Order ID, Product ID, quantity, and Sales Total.

then Queries Ivoice and Sales and Report Invoice and Sales. in the last export the database.

For data just put anything it is not important to put some exact data. just there should be tables for customer, product, Invoice and Invoice Line Item, and for each of theses shouls a few columns and the data you can just pust anything you want. the main task is to build a database in Microsoft Access that i can submit. thanks

there should be one table for each : customer, product, invoice, and invoice line item, and for customer there should be five columns for product there should be three to four columns, for invoice there should be four and for inoice line item there should four to five. then query invoice and sales and also Report invoice and sales as the instruction are written in the picture that i have attached here. and this is due due today, so i kindly request to finished it to for me please.

Category Tables: Create and populate Customer Product Invoice Invoice Line Item Salesperson support Queries Invoice Sales Report Invoice Sales Exported database

Explanation / Answer

Creating Database

1. Open Access
2. Select Blank Database template
3. Enter name for your Database - 'Sales'
4. Browse and select the folder where you want to keep it.
5. Click Create.

Creating Tables.

1.Click on the Create tab, under the Tables group.
2.click Table.

Access will add a new blak table to your database.

3.Double-click the first cell in the header row and type the name of the field in the Customer table - 'Customer ID'

Note: 'Column' here are referred to as 'fields'.

4. By default, Access denotes blank fields in the header row with the text Add New Field.Type second field name - First Name

5. Continue same step 4 for remaining fields and name them -
Last Name
Address
City
State
Zipcode
Phone Number

6. Repeat the same process from step 1 to 4 for other 3 tables.

7. Table 2 - Product

Field Names -
Product ID
Product Name
Description
Price

Table 3 - Invoice

Field names -
Customer Name
Customer ID
Product ID
Product Name
Date of Purchase
Price

Table 4 - Invoice Line Item

Field names -
Line ID
Product ID
Order ID
Quantity
Sales Total

Queries Invoice and Sales:

Invoice Query:

1. Select query wizard
2. Select table name - invoice
3. Select fields you want - Customer Name, Customer ID, Product ID, Product Name, Date of Purchase, Price
4. Name the query - Invoice
5. Click Finish

Query in SQL:

SELECT Invoice.[Customer Name], Invoice.[Customer ID], Invoice.[Product ID], Invoice.[Product Name], Invoice.[Date of Purchase], Invoice.[Price] FROM Invoice;

Report Invoice and sales:

1. Open the Navigation Panel.
2. Click the table or query - here click invoice query
3. Click Create
4. Click on Report button in Reports group.Report will be created.
5. Click Save.-> ENter report name to be saved - Invoice report.
6. Okay. You can now access the report in navigation panel.

Export the Database - 'sales'

1. Click File
2. Click Export or External Data (whichever option is available based on your Access version)
3. File type Menu select XML or CSV in which ever format you want to export.
4. Enter Name of your Database -'sales'
5. Click Ok on the pop up window.
6. The file will be saved with your exported database.

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.