Question 1

The most likely user of a Microsoft Access Report:

Accepted Answer

A) Data input clerk. 
B) Store manager. 
C) Systems analyst. 
D) System coder. 
A) Data input clerk. 
B) Store manager. 
C) Systems analyst. 
D) System coder.

Question 2

Which of the following operators would be used in a SQL query designed to simply display database records?

Accepted Answer

A) SELECT. 
B) INSERT. 
C) DISPLAY. 
D) VIEW. 
A) SELECT. 
B) INSERT. 
C) DISPLAY. 
D) VIEW.

Question 3

In Microsoft Access,we use "Forms" for:

Accepted Answer

A) Data entry. 
B) Data storage. 
C) Date retrieve. 
D) Two of the choices are correct. 
A) Data entry. 
B) Data storage. 
C) Date retrieve. 
D) Two of the choices are correct.

Question 4

Queries in Access are utilized by users to enter data into tables and view existing records.

Accepted Answer

A) True 
 B)False

Question 5

The SQL command "Group by" can be used to order an amount in a descending order.

Accepted Answer

A) True 
 B)False

Question 6

Which of the following Microsoft Access objects is used to integrate data from one or more queries and/or tables in order to present information useful to decision makers?

Accepted Answer

A) Tables. 
B) Reports. 
C) Forms. 
D) Macros. 
A) Tables. 
B) Reports. 
C) Forms. 
D) Macros.

Question 7

Which of the following best describes a DBMS?

Accepted Answer

A) The manager(s)in charge of a company's databases. 
B) Software that can create,modify and query databases. 
C) A language used to retrieve data from databases. 
D) A database created using Microsoft software. 
A) The manager(s)in charge of a company's databases. 
B) Software that can create,modify and query databases. 
C) A language used to retrieve data from databases. 
D) A database created using Microsoft software.

Question 8

Which of the following items can best be described as a "Resource" in the REA data model?

Accepted Answer

A) Cashier. 
B) Sales. 
C) Cash. 
D) Two of the above are correct. 
A) Cashier. 
B) Sales. 
C) Cash. 
D) Two of the above are correct.

Question 9

Which of the following items can best be described as an "Agent" in the REA data model?

Accepted Answer

A) Purchases. 
B) Purchasing manager. 
C) Raw material inventory. 
D) Purchase returns. 
A) Purchases. 
B) Purchasing manager. 
C) Raw material inventory. 
D) Purchase returns.

Question 10

Which type of data models allows each record to have multiple parent and child records?

Accepted Answer

A) The hierarchical mode. 
B) The network model. 
C) The relational model. 
D) None of these choices is correct. 
A) The hierarchical mode. 
B) The network model. 
C) The relational model. 
D) None of these choices is correct.

Question 11

What is the main purpose of using foreign keys in a relational database design?

Accepted Answer

A) It provides useful financial data value in the table. 
B) It is required in all tables. 
C) It is used to link tables. 
D) It is required for forms. 
A) It provides useful financial data value in the table. 
B) It is required in all tables. 
C) It is used to link tables. 
D) It is required for forms.

Question 12

The property of the primary key in a table in Microsoft Access should be set to:

Accepted Answer

A) The Required field = "Yes",the Indexed field = "Yes (No Duplicates)". 
B) The Required field = "NO" and the Indexed field = "Yes (No Duplicates)". 
C) The Required field = "Yes" and the Indexed field = "Yes (Duplicated)". 
D) The Required field = "NO" and the Indexed field = "Yes (Duplicated)". 
A) The Required field = "Yes",the Indexed field = "Yes (No Duplicates)". 
B) The Required field = "NO" and the Indexed field = "Yes (No Duplicates)". 
C) The Required field = "Yes" and the Indexed field = "Yes (Duplicated)". 
D) The Required field = "NO" and the Indexed field = "Yes (Duplicated)".

Question 13

Which of the following is not a type of data model?

Accepted Answer

A) Hierarchical data model. 
B) Network data model. 
C) Normalization data model. 
D) Relational data model. 
A) Hierarchical data model. 
B) Network data model. 
C) Normalization data model. 
D) Relational data model.

Question 14

In Microsoft Access,we use tables in a database for:

Accepted Answer

A) Data entry. 
B) Data storage. 
C) Data retrieval. 
D) Two of these choices are correct. 
A) Data entry. 
B) Data storage. 
C) Data retrieval. 
D) Two of these choices are correct.

The most likely user of a Microsoft Access Report:

Which of the following operators would be used in a SQL query designed to simply display database records?

In Microsoft Access,we use "Forms" for:

Queries in Access are utilized by users to enter data into tables and view existing records.

The SQL command "Group by" can be used to order an amount in a descending order.

Which of the following Microsoft Access objects is used to integrate data from one or more queries and/or tables in order to present information useful to decision makers?

Which of the following best describes a DBMS?

Which of the following items can best be described as a "Resource" in the REA data model?

Which of the following items can best be described as an "Agent" in the REA data model?

Which type of data models allows each record to have multiple parent and child records?

What is the main purpose of using foreign keys in a relational database design?

The property of the primary key in a table in Microsoft Access should be set to:

Which of the following is not a type of data model?

In Microsoft Access,we use tables in a database for:

Accounting Information Systems and Firm Value

Accountants As Business Analysts

Data Modeling

Sales and Collections Business Process

Purchases and Payments Business Process

Conversion Business Process

Reporting Processes and Extensible Business Reporting Language Xbrl

Data Analytics in Accounting: Concepts and the Amps Model

Data Analytics in Accounting: Tools and Practice

Emerging Technologies: Blockchain and Ai Automation

Accounting Information Systems and Internal Controls

Information Security and Computer Fraud

Monitoring and Auditing Ais

The Balanced Scorecard, Business Model Canvas, and Business Value of Information Technology

Evaluating Ais Investments

Filters

Exam 4: Relational Databases and Enterprise Systems

The most likely user of a Microsoft Access Report:

Which of the following operators would be used in a SQL query designed to simply display database records?

In Microsoft Access,we use "Forms" for:

Queries in Access are utilized by users to enter data into tables and view existing records.

The SQL command "Group by" can be used to order an amount in a descending order.

Which of the following Microsoft Access objects is used to integrate data from one or more queries and/or tables in order to present information useful to decision makers?

Which of the following best describes a DBMS?

Which of the following items can best be described as a "Resource" in the REA data model?

Which of the following items can best be described as an "Agent" in the REA data model?

Which type of data models allows each record to have multiple parent and child records?

What is the main purpose of using foreign keys in a relational database design?

The property of the primary key in a table in Microsoft Access should be set to:

Which of the following is not a type of data model?

In Microsoft Access,we use tables in a database for:

Accounting Information Systems and Firm Value

Accountants As Business Analysts

Data Modeling

Sales and Collections Business Process

Purchases and Payments Business Process

Conversion Business Process

Reporting Processes and Extensible Business Reporting Language Xbrl

Data Analytics in Accounting: Concepts and the Amps Model

Data Analytics in Accounting: Tools and Practice

Emerging Technologies: Blockchain and Ai Automation

Accounting Information Systems and Internal Controls

Information Security and Computer Fraud

Monitoring and Auditing Ais

The Balanced Scorecard, Business Model Canvas, and Business Value of Information Technology

Evaluating Ais Investments

Filters