ACCT 3060 – AIS accounting information system
Homework #2 – Databases
We’ve discussed the purpose and general structure of a database. You should be familiar with this information and its application to an accounting information system (AIS). We’ve also identified how a database would be central to an AIS.
Your assignment is to identify one commercially available database and describe the key features and functions of it. Your description should be one page in length and provide a full description of the database product and what its functions provide to the user.
A database is a collection of information that is organized in tables and stored on a computer system. This information can be updated or modified as required. We can also say it’s like a room in an office which has files in it. If we don’t have a defined process we will not know how to get that data from the room.
MS- Access
MS- Access was developed by miscrosoft and it is a computer based application that is used to create and maintain computer based database on desktop computers. This can be used for personal use and for small business that needs a database. It stores information in its own format that is based on jet database engine and it used a graphical user interface that makes it easier to work.
Key Features:
String Functions | |
Asc | LTrim |
Chr | Mid |
Concat with & | Replace |
CurDir | Right |
Format (with Strings) | RTrim |
InStr | Space |
InstrRev | Split |
LCase | Str |
Left | StrComp |
Len | StrConv |
Trim | StrReverse |
Numeric/Math Functions | |
Abs | Int |
Atn | Max |
Avg | Min |
Cos | Randomize |
Count | Rnd (random number) |
Exp | Round |
Fix | Sgn |
Format (with Numbers) | Sqr |
Val | Sum |
Date/Time Functions | |
Date | Hour |
DateAdd | Minute |
DateDiff | Month |
DatePart | MonthName |
DateSerial | Now |
DateValue | Second |
Day | Time |
Format (with Dates) | TimeSerial |
WeekdayName | TimeValue |
Year | Weekday |
Domain Functions | |
DAvg | DLast |
DCount | DLookup |
DFirst | DMax |
Information Functions | |
CurrentUser | IsDate |
Environ | IsNull |
ACCT 3060 – AIS accounting information system Homework #2 – Databases We’ve discussed the purpose and...
Name and explain the purpose of the three major subsystems of the accounting information system (AIS): SAMSUNG
Describe the types of decision-making and strategic information should the Accounting Information System (AIS) provide in the expenditure cycle. [10 marks] b) Analyze the function of QR codes that can companies use them to improve interactions with their customers.
Name Wannarat Natilerdsak Student ID6101139 IAC 326 Accounting Information System Homework Chapter 4 Relational Databases Explain the importance and advantages of databases. Essay Questions 1). Explain the importance and advantages of databases? Answer: Chapter 5: Computer Fraud Explain the threats faced by modern information systems. Explain the fraud triangle. Define computer fraud and discuss the different computer fraud classifications. Essay Questions 2). What are the common threats to a computerized accounting system and explain examples? Answer: 3). What are components...
Create a working proof of concept of one of the following applications which meets all of the minimum requirements. The application may be written in any programming language(s). The application should be sent with the following: ● All of the source code required for building ● A completed binary of the application (if applicable) ● Any required database files (if applicable) Each application requires a README. Please ensure the README includes the following components: ● Which application you choose to...
The purpose of this homework is to practice OOP programming covering Inheritance in java. The scenario is to design an online shopping system for a local supermarket (e.g., Europa Foods Supermarket or Wang Long Oriental Supermarket) and is mostly concentrated on the product registration system. Design and draw a UML diagram, and write the code for the following classes: ID: The identification number must start with 1 and follows with 6 numbers, e.g., “1123456”. Description, e.g. “Banana” Recommended Price per...
A test specification provides designers with what needs to be known in order to perform a specific test, and to validate and verify the requirement to be tested. The test script is divided into the test script, which is the generic condition to be tested, and one or more test cases within the test script. Provide a test script and test case for at least 3 of your requirements identified in your requirements specification. Provide the following format for an...
Please do not delete the questions. 1. What is the purpose of a database? 2. What is the reason to use a database over a spreadsheet? 3. Based on the previous answers (#1 & #2), there is a simple rule of thumb. A spread sheet is used when there is _________________________. A database is used when there are _________________________. 4. Please answer followings. a) A group of 8 bits is called a ____________ (from Chapter 4). b) The answers of...
Java project: A Bank Transaction System For A Regional Bank User Story A regional rural bank CEO wants to modernize banking experience for his customers by providing a computer solution for them to post the bank transactions in their savings and checking accounts from the comfort of their home. He has a vision of a system, which begins by displaying the starting balances for checking and savings account for a customer. The application first prompts the user to enter the...
Select one of the following users:small accounting business owner, accountant, office manager, or secretary. Use the Word Wide Web and your textbook to research and suggest a computer configuration for your selected user. Click the Reply link below to start a new post. Describe a suggested computer configuration for your selected user in your post. Identify all the system components along with examples justifying your choices. Examples should explain why a specific processor was chosen, why a specific amount of...
For this course project, you will use various database management and programming techniques to design and develop an online sales and distribution system for a fictitious organization. There are two phases—you will complete the first phase this week and the second phase in W5 Assignment 2. Rationale The focus of the project is to develop your database programming skills. This project will help you get a fair idea of the sales and distribution system in any organization that has a...