Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Project 1 - A Part 1 A: Creating Tables For this project, you have to create a database called Order Entry in ACCESS, which

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

Project 1 - A Part 1 A: Creating Tables For this project, you have to create a database called Order Entry in ACCESS, which has the following tables: Customer Order Tbl Employee OrdLine Product The descriptions of the tables together with the database background information are available in the file named Order Entry Database Background, which is posted in Project 1 folder. Pay special attention to the conversion of datatypes from Ole to Access when creating the tables. For each table, once you have created, click the table name and then take a screenshot of the table details as shown in the DESIGN VIEW. Paste the screenshot after the table in your file (see the first example (Customer) below). Do that for each of the five tables. You have to use the two methods I have shown you in class in creating these tables: Create three of them manually, and create the other two using the CREATE TABLE Statement. Part 1 has 5 points. Due date and time: September 28, 2022, 11:59pm

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

Financial Accounting Fundamentals

Authors: John Wild

3rd edition

978-0073527048, 0073527041, 978-0077544652

More Books

Students also viewed these Accounting questions