Question 1

When implementing a many-to-many relationship,which of the following should you do to ensure your database will function correctly?
A) Build the tables on the "one" side of the relationship first.
B) Define the primary key for each of the "one" side tables.
C) Build the junction table and define the primary key for the junction table.
D) all of the above.

Accepted Answer

All of the steps are necessary to ensure the database will function correctly.

Question 2

Which of the following statements is true about junction tables?
A) A junction table must contain the primary key from each of the related tables.
B) Each field is a foreign key that links the related table.
C) both A and B
D) neither A nor B

Accepted Answer

A junction table is used to create a many-to-many relationship between two tables, which have the one-to-many relationship. In a junction table, each field is a foreign key that links the related tables. It also must contain the primary key from each of the related tables. Therefore, both statements A and B are true about junction tables.

Question 3

Which of the following is the most common type of program flow statement?
A) program flow statement
B) Action
C) Comment
D) Macro Builder

Accepted Answer

The answer of Which of the following is the most...

Question 4

Which of the following keys will help you select multiple foreign keys?
A) Ctrl
B) Shift
C) Shift+Tab
D) Tab

Accepted Answer

Shift key helps to select multiple foreign keys.

Question 5

Which of the following determines how to match the data in two related tables?
A) join type property
B) inner join
C) left outer join
D) right outer join

Accepted Answer

The join type property determines how to match the data in two related tables. The inner join, left outer join, and right outer join are different types of join that can be specified using the join type property, but none of them alone determine how to match the data. Therefore, the correct answer is A.

Question 6

When building a macro,which of the following must you do?
A) decide what event will cause the macro to execute
B) plan out the logic behind the steps,or tasks,the macro will perform
C) determine the type of macro needed and the best way to build the macro
D) all of the above

Accepted Answer

When building a macro, it is necessary to decide what event will trigger the macro, plan out the logic behind the steps, and determine the type of macro needed and the best way to build the macro. Therefore, all three choices are required when building a macro.

Question 7

Which of the following are attached to tables?
A) user interface macros
B) data macros
C) events
D) macro window

Accepted Answer

Data macros are attached to tables to automate tasks such as updating or validating data when a table is modified. They are similar to triggers in SQL databases.

Question 8

Which of the following returns only records that have matching values in both tables?
A) join type property
B) inner join
C) left outer join
D) right outer join

Accepted Answer

Inner join returns only records that have matching values in both tables.

Question 9

Which of the following is the underlying language in a relational database system?
A) Application Log
B) Macro Builder
C) Lookup Wizard
D) Structured Query Language

Accepted Answer

The underlying language in a relational database system is Structured Query Language (SQL), which is used to create, modify, and extract data from the database. Options A, B, and C are not programming languages used in relational databases.

Question 10

Which of the following is a database object that allows you to write and attach code to different objects and controls in your database?
A) junction table
B) concatenated primary key
C) macro
D) Application Log

Accepted Answer

A macro is a database object that allows you to write and attach code to different objects and controls in your database. A junction table is used to implement many-to-many relationships between two tables, a concatenated primary key is a primary key that is composed of more than one column, and an Application Log is used to track changes and events in a database.

Question 11

Which of the following lets you write and edit he content of all macros?
A) program flow statement
B) Action
C) Comment
D) Macro Builder

Accepted Answer

The Macro Builder is a feature in Microsoft Access that allows you to create, edit, and manage macros. It lets you write and edit the content of all macros, making it the best choice for this question.

Question 12

Which of the following statements is true about deleting a relationship created with a Lookup field?
A) Occasionally you may need to remove a relationship that was not created correctly.
B) If the relationship was the result of using the Lookup Wizard,you most likely will need to delete both the relationship and the lookup attached to the field.
C) After deleting a relationship,you may need to change the Display Control property of the field so it is no longer a combo box.
D) all of the above

Accepted Answer

All three statements are true. A relationship may need to be deleted if it was created incorrectly, and if the relationship was created using the Lookup Wizard, both the relationship and the lookup attached to the field may need to be deleted. After deleting a relationship, the Display Control property of the field may need to be changed so that it is no longer a combo box.

Question 13

Which of the following provides organizational structure to a macro?
A) program flow statement
B) Action
C) Comment
D) Macro Builder

Accepted Answer

The answer of Which of the following provides organizational structure...

Question 14

Which of the following statements is true?
A) When a report or form opens,the On Open event occurs.
B) When a user hovers the mouse over a button on a form,the On Mouse Move event occurs.
C) When a user pushes a button on a form,the On Click event occurs.
D) all of the above

Accepted Answer

All three statements are true. The On Open event occurs when a report or form opens, the On Mouse Move event occurs when a user hovers the mouse over a button on a form, and the On Click event occurs when a user pushes a button on a form. Therefore, D is the correct answer.

Question 15

Which of the following returns all the records from the table on the left side of the join and only the records that have a matching value from the table on the right side of the join?
A) join type property
B) inner join
C) left outer join
D) right outer join

Accepted Answer

The left outer join returns all records from the left table, and the matched records from the right table. If there is no match, the result is NULL on the side of the right table.

Question 16

Which of the following occur when an action happens to an object or control?
A) user interface macros
B) data macros
C) events
D) macro window

Accepted Answer

Events are triggered when an action happens to an object or control in a program. This can include clicking a button, entering data into a form, or selecting an option from a dropdown menu. User interface and data macros may be used to automate these actions, but events are what actually trigger them. The macro window is a tool for creating and editing macros, but is not directly related to events.

Question 17

Which of the following are attached to objects and controls,such as forms,reports,and command buttons,that are part of the user interface?
A) user interface macros
B) data macros
C) events
D) macro window

Accepted Answer

User interface macros are attached to objects and controls in the user interface to automate tasks and respond to events.

Question 18

When a relationship is created,what kind of join does Access assign?
A) inner join
B) left outer join
C) right outer join
D) none of the above

Accepted Answer

When a relationship is created, Access assigns an inner join by default. This means that only records with matching values in both tables will be included in the query result. This is usually the most appropriate type of join, as it ensures that the query only returns relevant and accurate data. Left and right outer joins may be necessary in some cases, but should be used sparingly and only when the specific needs of the query require it.

Question 19

Which of the following is an individual command inside of a macro?
A) program flow statement
B) Action
C) Comment
D) Macro Builder

Accepted Answer

An individual command inside of a macro is called an "Action," which is a specific task that the macro performs. Program flow statements are used to control the flow of operations within the macro and are not individual commands. Comments are used to add notes to the macro for human readers and do not perform any actions in themselves. Macro Builder is a tool used to create the macro and is not a command within the macro itself.

Question 20

Which of the following returns all the records from the table on the right side of the join and only the records that have a matching value from the table on the left side of the join?
A) join type property
B) inner join
C) left outer join
D) right outer join

Accepted Answer

Right outer join returns all records from the table on the right and only the matching records from the table on the left.

Quiz 6: Creating Advanced Queries and Reports and Using SQL

When implementing a many-to-many relationship,which of the following should you do to ensure your database will function correctly?

Which of the following statements is true about junction tables?

Which of the following is the most common type of program flow statement?

Which of the following keys will help you select multiple foreign keys?

Which of the following determines how to match the data in two related tables?

When building a macro,which of the following must you do?

Which of the following are attached to tables?

Which of the following returns only records that have matching values in both tables?

Which of the following is the underlying language in a relational database system?

Which of the following is a database object that allows you to write and attach code to different objects and controls in your database?

Which of the following lets you write and edit he content of all macros?

Which of the following statements is true about deleting a relationship created with a Lookup field?

Which of the following provides organizational structure to a macro?

Which of the following statements is true?

Which of the following returns all the records from the table on the left side of the join and only the records that have a matching value from the table on the right side of the join?

Which of the following occur when an action happens to an object or control?

Which of the following are attached to objects and controls,such as forms,reports,and command buttons,that are part of the user interface?

When a relationship is created,what kind of join does Access assign?

Which of the following is an individual command inside of a macro?

Which of the following returns all the records from the table on the right side of the join and only the records that have a matching value from the table on the left side of the join?