Question 1

To copy a table, you right-click it in _____ and then click Copy on the shortcut menu.
A) the Field List
B) Datasheet View
C) the Navigation Pane
D) Design View

Accepted Answer

The answer of To copy a table, you right-click it...

Question 2

Which of the following join types can you create by double-clicking a join line in Query Design View? Select all the options that apply. ​
A) right outer
B) left outer
C) inner
D) upper

Accepted Answer

Double-clicking a join line in Query Design View allows you to choose the type of join you want to create. The options available are right outer join, left outer join, and inner join. "Upper" is not a valid join type.

Question 3

You can copy and paste any object in Access except for tables.

Accepted Answer

You can copy and paste tables in Access.

Question 4

If you want to find records in the table on the "one" side of a one-to-many relationship that do not have related records in the "many" side, which join do you use?
A) inner
B) self
C) left outer
D) cascade updates

Accepted Answer

A left outer join will return all records from the table on the "one" side, along with any matching records from the "many" side. Any records from the table on the "one" side that do not have matching records in the "many" side will still be returned with null values in the columns from the "many" side. So, by checking for null values in those columns, we can identify the records that do not have related records in the "many" side.

Question 5

What is the first step in creating a query with a self join in Query Design View?
A) Display two field lists for the same table.
B) Add the Join Type row to the query design grid.
C) Remove all field lists from the upper pane.
D) Establish a one-to-many relationship between two tables.

Accepted Answer

The first step in creating a self join in Query Design View is to display two field lists for the same table. This allows for the table to be joined to itself.

Question 6

You can set a startup option to show or hide the Navigation Pane itself.

Accepted Answer

In Microsoft Access, you can set a startup option to show or hide the Navigation Pane by checking or unchecking the "Display Navigation Pane" option under the Current Database settings.

Question 7

To unhide a hidden object, right-click the Property Sheet title bar, click Navigation Options, then click the Show Hidden Objects check box.

Accepted Answer

- Navigation Pane
False - Navigation pane
False - navigation pane
False - NAVIGATION PANE

Question 8

Before you can change the Hidden property for a hidden object in the Navigation Pane, you must _____.
A) hide the Navigation Pane itself
B) change the Navigation Options to show hidden objects
C) restart Access
D) open the Property Sheet for the Navigation Pane

Accepted Answer

To change the Hidden property for a hidden object in the Navigation Pane, you must first change the Navigation Options to show hidden objects. This will allow the object to be visible in the Navigation Pane and its Hidden property can then be modified. Hiding the Navigation Pane itself or restarting Access will not affect the Hidden property of individual objects. Opening the Property Sheet for the Navigation Pane may provide additional options for customization but is not necessary for changing the Hidden property of hidden objects.

Question 9

How do you specify an outer join between two tables?
A) In the Relationships window, click the Modify Join button.
B) In Query Design View, double-click the join line.
C) Add the "outer" criterion to the query design grid.
D) Change the order of the fields in the query design grid.

Accepted Answer

The answer of How do you specify an outer join...

Question 10

To remove the Hidden property from an object, right-click the object, click _____, and uncheck the Hidden attribute check box.
A) Object Properties
B) Change Type
C) Hidden
D) Unhide

Accepted Answer

Right-clicking the object and selecting "Object Properties" is the correct option as it will bring up a menu where the Hidden attribute check box can be unchecked, thus removing the Hidden property from the object. The other options listed (B, C, and D) are not necessary or correct for removing the Hidden property.

Question 11

How can you identify a linked table in a database?
A) A linked table appears with a link icon in the Navigation Pane.
B) A linked table opens in a separate window, not on a tab.
C) A linked table is red in the Linked Table Manager.
D) A linked table has "Linked" at the beginning of its name.

Accepted Answer

A linked table appears with a link icon in the Navigation Pane.

Question 12

In which of the following circumstances would you copy an entire table?
A) You want to export records to another format.
B) You want to create a query with a self join.
C) You want to make one table the parent table and the other the child table.
D) You want to use the same table structure as in another table.

Accepted Answer

If you want to use the same table structure as in another table, you can simply copy the table, which will provide you with the same column names, data types, and other properties. This is typically done when you need to create a similar table with some modifications without having to recreate the entire table structure from scratch.

Question 13

Why might you want to hide an action query in the Navigation Pane?
A) To avoid accidentally running the query
B) To remove clutter from the Navigation Pane
C) To keep the action query private
D) To run the query in the background

Accepted Answer

Hiding an action query in the Navigation Pane can prevent accidental running of the query, especially if the query has the potential to make significant changes to the data in the database.

Question 14

A(n) _____ join relates a record of a table to another record in the same table.
A) duplicate
B) alias
C) self
D) union

Accepted Answer

A self join is used when a single table contains relationships that need to be accessed through the table itself. It involves joining a table to itself using table aliases to differentiate between the two copies of the same table. This type of join is useful when querying hierarchical data or when trying to find relationships between records within the same table. The other options - duplicate, alias, and union - are not relevant to a self join.

Question 15

In which of the following situations would you create a query with a self join?
A) You want to identify orders with no customer address.
B) You want to list managers and their employees.
C) You want to list all products in the "Electronics" category.
D) You want to increase Fee field values by $25.00.

Accepted Answer

A self join is used to join a table to itself, usually when there is a relationship between rows in the same table. In this case, listing managers and their employees involves joining the employee table to itself to establish the relationship between managers and their subordinates. Options A, C, and D do not require a self join.

Question 16

You use an action query's the Invisible property to hide the query in the Navigation Pane.

Accepted Answer

You use an action query's "Show" property in the Navigation Pane to hide or show the query, not the "Invisible" property.

Question 17

In a database with a Products table and Orders table, you want to see which products have not been ordered.What type of query should you create?
A) Select query with a self join.
B) Update query.
C) Select query with an outer join.
D) Append query.

Accepted Answer

To see which products have not been ordered, you need to perform an outer join between the Products and Orders tables. An outer join will display all the products, including those that are not present in the Orders table. Therefore, a select query with an outer join is the best choice for this situation.

Question 18

A self join relates a record of a table to _____.
A) another record in the same table
B) an identical record in another table
C) a matching record in another database
D) a record with one or more blank field values

Accepted Answer

A self join relates a record in a table to another record in the same table. This is done by creating a join between two instances of the same table within a query.

Question 19

To unhide a hidden object in the Navigation Pane, you must enter a password for accessing the object.

Accepted Answer

There is no requirement to enter a password to unhide a hidden object in the Navigation Pane. Simply right-click on the Navigation Pane and select "Navigation Options," then check the box next to the object you want to unhide.

Question 20

The outer join is the default join operation in Access.

Accepted Answer

The default join operation in Access is the inner join. However, outer joins can be performed by selecting the appropriate join type in the query design view.

Quiz 9: Access

To copy a table, you right-click it in _____ and then click Copy on the shortcut menu.

Which of the following join types can you create by double-clicking a join line in Query Design View? Select all the options that apply. ​

You can copy and paste any object in Access except for tables.

If you want to find records in the table on the "one" side of a one-to-many relationship that do not have related records in the "many" side, which join do you use?

What is the first step in creating a query with a self join in Query Design View?

You can set a startup option to show or hide the Navigation Pane itself.

To unhide a hidden object, right-click the Property Sheet title bar, click Navigation Options, then click the Show Hidden Objects check box.

Before you can change the Hidden property for a hidden object in the Navigation Pane, you must _____.

How do you specify an outer join between two tables?

To remove the Hidden property from an object, right-click the object, click _____, and uncheck the Hidden attribute check box.

How can you identify a linked table in a database?

In which of the following circumstances would you copy an entire table?

Why might you want to hide an action query in the Navigation Pane?

A(n) _____ join relates a record of a table to another record in the same table.

In which of the following situations would you create a query with a self join?

You use an action query's the Invisible property to hide the query in the Navigation Pane.

In a database with a Products table and Orders table, you want to see which products have not been ordered.What type of query should you create?

A self join relates a record of a table to _____.

To unhide a hidden object in the Navigation Pane, you must enter a password for accessing the object.

The outer join is the default join operation in Access.

Which of the following join types can you create by double-clicking a join line in Query Design View? Select all the options that apply.