Question: TRANSACTIONAL APPLICATION-DATABASE Students will create a simple Point-of-Sale application using Microsoft Access. The application will demonstrate the ability of an application to capture, store,

TRANSACTIONAL APPLICATION-DATABASE Students will create a simple Point-of-Sale application using Microsoft Access.

TRANSACTIONAL APPLICATION-DATABASE Students will create a simple Point-of-Sale application using Microsoft Access. The application will demonstrate the ability of an application to capture, store, and report on business transactional information in the course of its daily operations to support business management for decision making. Operational Management Information System (Microsoft Access) - 100 points Your final Microsoft Access project file will include the following components. Specific instructions, concepts, expectations, and demonstration will be provided during scheduled class lecture time as stated in the syllabus. It is highly recommended that you attend all scheduled class sessions to obtain all the necessary skills and understanding to complete this assignment. Database Tables & Attributes Required: OrdersRecord Table - Database table capturing and storing Order transaction data with the following attributes o OrderNumber - Primary Key (Required Field - Auto Increment - Number) 0 OrderDate - Date/Time (Required Field with Date Picker) 0 OrderTotal - Currency (Required Field with Decimal Format) Products Table - Database table capturing and storing Product information 0 ProductID - Primary Key (Required Field - Auto Increment) Product Title - Text (Required Field) 0 o Product Description - Text (Required Field) 0 ProductUnitPrice - Currency (Required Field with Decimal Format) 0 OrdersDetailTable - Database table capturing and storing Orders transaction details ID - Primary Key (Required Field - Auto Increment) OrderNumber - Numbers (Required Field) ProductID-Numbers (Required Field) Quantity - Numbers (Required Field) SubTotal - Currency (Required Field with Decimal Format) DODO

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Course No Location Instructor ID Class Size Seminar End Date Question 1 PS Attendance Question 2 Att... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Excel file Icon

628c6d75de8b3_19184.xlsx

300 KBs Excel File

Students Have Also Explored These Related Computer Network Questions!