Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

hi, I need a database made in Acees for the following Invoice : I will attach the picture of the assignment too. image text in transcribed

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Put Your Data To Work 52 Tips And Techniques For Effectively Managing Your Database

Authors: Wes Trochlil

1st Edition

0880343079, 978-0880343077

More Books

Students also viewed these Databases questions

Question

3. What might you have done differently

Answered: 1 week ago

Question

Why do HCMSs exist? Do they change over time?

Answered: 1 week ago