AIS || QUESTIONS WITH ACTUAL ANSWERS!!
What is an accounting information system? correct answers An accounting information
system is a structure of interrelated components that collect, store, and process data arising
from business events.
What are the components of an accounting information system? correct answers Procedures
and instructions, internal controls, data, people, software, and information technology
infrastructure
Why is it important for accountants to know about accounting information systems? correct
answers Because accountants use them every day.
What is the main benefit of an accounting information system? correct answers The main
benefit AISs provide is that they efficiently gather and store all relevant business event data
for the purpose of extracting information for decision making. Scope of data, financial/non-
financial. Breadth and depth of data. All of this helps for better decision making.
What is the main disadvantage of an accounting information system? correct answers Cost
(implentation, updates, maintenance)
How do accounting information systems differ from traditional double-entry systems? correct
answers AISs gather and store all relevant business event data, whereas traditional double-
entry systems gather and store only financial details.
What is a relational database? And why are they useful in building an AIS? correct answers
Tables made up of rows and columns linked to other tables. Each table has one focus which is
why relationships are created. Reduces storage costs-data redundancy, analytical abilities-
model real world entities.
How are internal controls relevant to an accounting information system? correct answers
Internal controls help maintain the integrity of the accounting information system and the
accounting information system is the platform with which many of the internal controls are
implemented.
What is the purpose of the REA Matrix? correct answers To identify and organize the events
and their related agents and resources
What is the purpose of the REA Diagram? correct answers It is given to the user to show how
the tables in the database are linked together, in their applicable business cycles, so that the
user can perform updates or maintenance.
What is the purpose of the Schema? correct answers The Schema identifies all of the primary
keys, foreign keys, and other attributes that will be found in each table; it serves as a guide
for the designer of the database to follow and also for auditors and other users to find out
where specific data is stored in the database. (alphabetize)
Describe the REA Matrix correct answers Only non-client document, Identify business
events, resources, and agents. Formatted as ERA(events, resources,agent). First step in the
design process.
, Describe the REA Diagram correct answers Organized in cycles: Production, Payroll,
Revenue, Purchase. Client Document; identify tables and types of relationships. Indicates
where relationship tables will be placed
Describe the Schema correct answers Primary keys are underlined, foreign keys in italics.
Client document used to identify fields, primary keys, foreign keys, and other attributes. Lists
REA, relationship, and lookup tables.
Define Control Source correct answers Where we are writing the information to, A field in
the table
Define Record SOurce correct answers Tables or query that the form is based off of
Define Row Source correct answers List source you're pulling from for a combo box
Whats the purpose of a form? correct answers mask for entering data into tables
Why use subforms? correct answers Writes data to a different table than the form, they are
inserted in another form
Whats the purpose of a query? correct answers A question asked to a database, combines data
from different tables and specific fields, allows user to manipulate data
Whats the purpose of a report? correct answers To present information in a formal way to
decision makers
Whats the purpose of a table? correct answers To hold data
What is the purpose of a relationship table? correct answers Allows for many to many
relationships to take place
What is the purpose of referential integrity? correct answers Both tables same file, fields in
relationship have same data type, parent table's field is a primary key, child table can only
hold values found in parent table
What are action queries? correct answers Append query, update query, delete query
Describe an append query? correct answers add to
Describe how to update a query? correct answers modify
Describe how to delete a query? correct answers remove
Which is the only document not given to the client? correct answers REA Matrix
What is the order of tables from left to right that are identified in the REA Matrix? correct
answers Events, resources, agents
What is an accounting information system? correct answers An accounting information
system is a structure of interrelated components that collect, store, and process data arising
from business events.
What are the components of an accounting information system? correct answers Procedures
and instructions, internal controls, data, people, software, and information technology
infrastructure
Why is it important for accountants to know about accounting information systems? correct
answers Because accountants use them every day.
What is the main benefit of an accounting information system? correct answers The main
benefit AISs provide is that they efficiently gather and store all relevant business event data
for the purpose of extracting information for decision making. Scope of data, financial/non-
financial. Breadth and depth of data. All of this helps for better decision making.
What is the main disadvantage of an accounting information system? correct answers Cost
(implentation, updates, maintenance)
How do accounting information systems differ from traditional double-entry systems? correct
answers AISs gather and store all relevant business event data, whereas traditional double-
entry systems gather and store only financial details.
What is a relational database? And why are they useful in building an AIS? correct answers
Tables made up of rows and columns linked to other tables. Each table has one focus which is
why relationships are created. Reduces storage costs-data redundancy, analytical abilities-
model real world entities.
How are internal controls relevant to an accounting information system? correct answers
Internal controls help maintain the integrity of the accounting information system and the
accounting information system is the platform with which many of the internal controls are
implemented.
What is the purpose of the REA Matrix? correct answers To identify and organize the events
and their related agents and resources
What is the purpose of the REA Diagram? correct answers It is given to the user to show how
the tables in the database are linked together, in their applicable business cycles, so that the
user can perform updates or maintenance.
What is the purpose of the Schema? correct answers The Schema identifies all of the primary
keys, foreign keys, and other attributes that will be found in each table; it serves as a guide
for the designer of the database to follow and also for auditors and other users to find out
where specific data is stored in the database. (alphabetize)
Describe the REA Matrix correct answers Only non-client document, Identify business
events, resources, and agents. Formatted as ERA(events, resources,agent). First step in the
design process.
, Describe the REA Diagram correct answers Organized in cycles: Production, Payroll,
Revenue, Purchase. Client Document; identify tables and types of relationships. Indicates
where relationship tables will be placed
Describe the Schema correct answers Primary keys are underlined, foreign keys in italics.
Client document used to identify fields, primary keys, foreign keys, and other attributes. Lists
REA, relationship, and lookup tables.
Define Control Source correct answers Where we are writing the information to, A field in
the table
Define Record SOurce correct answers Tables or query that the form is based off of
Define Row Source correct answers List source you're pulling from for a combo box
Whats the purpose of a form? correct answers mask for entering data into tables
Why use subforms? correct answers Writes data to a different table than the form, they are
inserted in another form
Whats the purpose of a query? correct answers A question asked to a database, combines data
from different tables and specific fields, allows user to manipulate data
Whats the purpose of a report? correct answers To present information in a formal way to
decision makers
Whats the purpose of a table? correct answers To hold data
What is the purpose of a relationship table? correct answers Allows for many to many
relationships to take place
What is the purpose of referential integrity? correct answers Both tables same file, fields in
relationship have same data type, parent table's field is a primary key, child table can only
hold values found in parent table
What are action queries? correct answers Append query, update query, delete query
Describe an append query? correct answers add to
Describe how to update a query? correct answers modify
Describe how to delete a query? correct answers remove
Which is the only document not given to the client? correct answers REA Matrix
What is the order of tables from left to right that are identified in the REA Matrix? correct
answers Events, resources, agents
