Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please, show me the step-by-step OR link for the ACCESS that you use to answer. thank you OPEN ACCESS. CREATE A DATABASE. 1. ~ ~

Please, show me the step-by-step OR link for the ACCESS that you use to answer. thank you

OPEN ACCESS. CREATE A DATABASE.

1. ~ ~ ~ ~

A) Create a table based on the following criteria: (SEE THE PICTURE ATTACHED)

B) Filling the table with the following data: (SEE THE PICTURE ATTACHED)

2. Create a Table which contains the following information. Please consider, the Table have to setup properly in the Table design. The type field should be defined by a student.

3. Create an appropriate relationship between these two tables. Please consider the logic before making a relationship between them.

4. Please create a query that only shows the data for city Detroit. Save the Query as Detroit.

5. Please create a query that shows the description starts with P. Save the query as Description.

6. Please create a query that shows sales greater than 20$.

image text in transcribedimage text in transcribed

Open Aocess. Create a database. 1. . Craate a table hased on the followinn critarie: b. Fillina the table with the following data: 2. Create a Table which contains the following information. Please consider, the Table have to setup properly in the Table design. The type field should be defined by a student. 3. Create an appropriate relationship between these two tables. Please consider the logic betore making a relationship between them. 4. Please creaie a query that only shows the data for city Detrait. Save the Query as "Detroit". 5. Please create a query then shows the description starts with "P", Save the query as "Description". 6. Please create a query that shows sales greater than 20$. Open Aocess. Create a database. 1. . Craate a table hased on the followinn critarie: b. Fillina the table with the following data: 2. Create a Table which contains the following information. Please consider, the Table have to setup properly in the Table design. The type field should be defined by a student. 3. Create an appropriate relationship between these two tables. Please consider the logic betore making a relationship between them. 4. Please creaie a query that only shows the data for city Detrait. Save the Query as "Detroit". 5. Please create a query then shows the description starts with "P", Save the query as "Description". 6. Please create a query that shows sales greater than 20$

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

Management Planning Guide For Information Systems Security Auditing

Authors: National State Auditors Association And The U. S. General Accounting Office

1st Edition

1508456720, 978-1508456728

More Books

Students also viewed these Accounting questions

Question

Identify three ways to manage an intergenerational workforce.

Answered: 1 week ago

Question

Prepare a Porters Five Forces analysis.

Answered: 1 week ago

Question

Analyze the impact of mergers and acquisitions on employees.

Answered: 1 week ago