Case-Based Critical Thinking Questions
Case 10-2
Misaki is a new Reservation Specialist for an event rental company. She has asked the database administrator, Kirk, to develop an interface for her to access the database objects she needs because she is not familiar with Access.
-Kirk has determined he needs a list box of all of the queries in the database to include in the interface he is developing. Access maintains special tables that store information about the structure of the objects in the database. The ____ system table, stores information about the names, types, and other characteristics of every object in a database. Kirk will write an SQL statement that includes information from this table.
A)USysRibbon
B)MSysObjects
C)MSysQueries
D)MSysSelect

Question

Case-Based Critical Thinking Questions
Case 10-2
Misaki is a new Reservation Specialist for an event rental company. She has asked the database administrator, Kirk, to develop an interface for her to access the database objects she needs because she is not familiar with Access.
-Kirk has determined he needs a list box of all of the queries in the database to include in the interface he is developing.  Access maintains special tables that store information about the structure of the objects in the database. The ____ system table, stores information about the names, types, and other characteristics of every object in a database.  Kirk will write an SQL statement that includes information from this table.
A)USysRibbon
B)MSysObjects
C)MSysQueries
D)MSysSelect

Quizplus · Accepted Answer

The MSysObjects system table stores information about the names, types, and other characteristics of every object in a database, including queries. Kirk can use this table to create a list box of all the queries in the database for Misaki's interface. The other options, USysRibbon, MSysQueries, and MSysSelect, do not contain the necessary information for this task.