TRANSACTIONAL APPLICATION-DATABASE Students will create a simple Point-of-Sale application using Microsoft Access. The application will demonstrate...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 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
Expert Answer:
Answer rating: 100% (QA)
Course No Location Instructor ID Class Size Seminar End Date Question 1 PS Attendance Question 2 Att... View the full answer
Related Book For
Core Concepts Of Accounting Information Systems
ISBN: 9780470507025
11th Edition
Authors: Nancy A. Bagranoff, Mark G. Simkin, Carolyn Strand Norman
Posted Date:
Students also viewed these computer network questions
-
It is highly recommended that reviews the seminar presentation located in the seminar area before beginning the task. According to the law of demand, if price increases, quantity demanded of a good...
-
Data for CW Corporation (for the year 2021): Marketable Securities = PHP 100,000, Net Fixed Assets = PHP 2,000,000, Long-term Debt = PHP 1,000,000, Common Stock = PHP 100,000, Retained Earnings = PHP...
-
Capture lessons learned from your project to date using questions from Exhibit or other questions of your choice. Show how you will use these lessons both to improve the remainder of your project and...
-
Calculate and compare the efficiency of the two turbines of Prob. 14123. They should be the same since we are assuming dynamic similarity. However, the larger turbine will actually be slightly more...
-
Damerly Company (a California employer) wants to give a holiday bonus check of $250 to each employee. Since it wants the check amount to be $250, it will need to gross-up the amount of the bonus....
-
Sometimes a square grid is desired even for a circular system. Consider the quadrant of a circle shown in Figure P3-77 with r = 10 cm. x = y = 3 cm and k = 10W/m· ºC. Write the...
-
On April 14, 2006, The Wall Street Journal carried an article headlined Research in Motion Skeptics Pipe Up. The article concerned Research in Motion Ltd. (RIM), the manufacturer of the BlackBerry....
-
Continental Insurance Co. issued a policy to cover shipments by Oakley Fertilizer, Inc. Oakley agreed to ship three thousand tons of fertilizer by barge to Ameropa North America in Caruthersville,...
-
The ______ Account was an errors account that Leeson set up near the beginning of his employment at BFS. He used the account to make unauthorized trades in futures and options, falsify reports to...
-
As an investment advisor for MREAF (Momentum Real Estate Advisory Fund), you are about to make a presentation to the portfolio manager of the ET&T pension fund. You would like to show what would have...
-
he extent to which a sample statistic incorrectly estimates a population parameter is The extent to which a sample statistic incorrectly estimates a population parameter is sampling skewedness...
-
On 1 January 2022, S Aravena commenced business with bank $5000, GST receivable $1000 and computer $10 000. By the end of May 2022 the business had expanded and S Aravena found it necessary to put in...
-
The financial report from a small college shows the following expenses: Draw a circle graph showing this income. Salaries Academic Plant operations Student activities Athletic programs TOTAL...
-
The authors of the study cited in the preceding exercise go on to consider what would have to happen for nominal stock prices to again equal real stock prices. What is the correct answer? Preceding...
-
The Congressional Research Service estimates that at least $45 million of counterfeit U.S. $100 notes produced by the North Korean government are in circulation. a. Why do U.S. taxpayers lose because...
-
The real risk-free rate is 2.05%. Inflation is expected to be 3.05% this year, 4.75% next year, and 2.3% thereafter. The maturity risk premium is estimated to be 0.05 (t - 1)%, where t = number of...
-
Question 3 (20 pts) Consider an example where we assign cameras at different locations. Each location covers some areas of stadiums, and the cost of putting a camera is $150. We have stadium areas...
-
a) Show that (a, b) := {{a}, {b}} does not satisfy the ordered pair axiom. b) Determine whether each of the following statements is true or false. (Give a reason in each case): (i) {a, b} C (a, b)....
-
Why are calculated fields created with database queries? Why not create them directly with reports?
-
MailMed Inc. (MMI), a pharmaceutical firm, provides discounted prescription drugs through direct mail. MMI has a small systems staff that designs and writes MMIs customized software. Until recently,...
-
Now, assume that you work in the internal audit function at a company that is considering a software package to help automate the process of complying with the requirements of the Sarbanes-Oxley Act...
-
Marginal costs are the _________ costs associated with the last unit of output produced.
-
The reason for high average total costs when a firm is producing a very small amount of output is the high _________ costs.
-
When LRATC falls as output expands, _______ of scale occur. When LRATC does not vary with output, the firm faces ___________________to scale. When LRATC rises as output expands, __________________ of...
Study smarter with the SolutionInn App