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.
-In the SQL SELECT statement, Kirk must identify the object type for queries using code that SQL can interpret. In the Access system table, the field value for the query object type is ____ and will follow [Type]= in the statement.
A)1
B)3
C)5
D)7

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.
-In the SQL SELECT statement, Kirk must identify the object type for queries using code that SQL can interpret.  In the Access system table, the field value for the query object type is ____ and will follow [Type]= in the statement.
A)1
B)3
C)5
D)7

Quizplus · Accepted Answer

In Microsoft Access, the object type for a query is represented by the number 5 in the system table.