Deck 9: Access

Question 1

AND criteria means that all criteria must be true to select a record.

Answer 1

True

Question 2

To _____ a query, you right-click it in the Navigation Pane, and then click Copy on the shortcut menu.

A) paste
B) cut
C) copy
D) rename

Answer 2

C

Question 3

What does the criterion <=200 mean?

A) less than or equal to 200
B) less than 200
C) greater than or equal to 200
D) not equal to 200

Answer 3

A

Question 4

To select records in the Sales table that have no related records in the Customers table, create a(n) _____ join.

A) right inner
B) orphan outer
C) select inner
D) right outer

Question 5

_____ criteria are two or more criteria on the same Criteria row of the query design grid.

A) AND
B) OR
C) Comparison
D) Date/Time

Question 6

What kind of criteria would you use to find records with OrderDate values in May or June?

A) IS NULL
B) PLUS
C) AND
D) OR

Question 7

Enter _____ criteria on different Criteria rows in the query design grid.

A) AND
B) Date/Time
C) null
D) OR

Question 8

The _____ property renames a field list in Query Design view.

A) Caption
B) Alias
C) Field List
D) Recordset

Question 9

As you add AND criteria to the query design grid, you increase the number of records selected for the resulting datasheet.

Question 10

Use >500 as the criterion for a Number field in a query to select records with a value less than 500 in that field.

Question 11

_____ criteria are two or more criteria on different Criteria rows of the query design grid.

A) AND
B) OR
C) SHOW
D) SELECT

Question 12

To display a field list for the Employees table with the name "Managers" in Query Design view, you change the _____ property for the field list. ​

A) Description
B) Source
C) Lookup
D) Alias

Question 13

You cannot view a query with a self join in SQL View.

Question 14

Create a(n) _____ join to relate an Employee table to itself using two fields in the same table to identify the relationship between employees and supervisors.

A) inner
B) outer
C) self
D) referential

Question 15

Which of the following are tasks you can perform on a query listed in the Navigation Pane? Select all the options that apply. ​

A) Close the query.
B) Copy the query.
C) Paste the query.
D) Open the query.

Question 16

A(n) self join selects all the records from the "one" table regardless of whether there is a related record in the "many" table.

Question 17

What criterion would you use to find numbers greater than or equal to 100?

A) <=100
B) <>100
C) >+100
D) >=100

Question 18

To select records from the Customers table that have no related records in the Sales table, create a(n) _____ join.

A) inner
B) outer
C) self
D) referential

Question 19

Which of the following statements describe OR criteria? Select all the options that apply.

A) You enter OR criteria on different rows of the query design grid.
B) You use OR criteria when any one criterion must be true to select a record.
C) As you add OR criteria to a query, you increase the number of records in the resulting datasheet.
D) You use OR criteria when all of the criteria must be true to select a record.

Question 20

You enter _____ criteria on the same row of the query design grid.

A) NOT
B) AND
C) TEXT
D) OR

Question 21

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

Question 22

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

Question 23

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

Question 24

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

Question 25

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.

Question 26

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

Question 27

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

Question 28

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

Question 29

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.

Question 30

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

Question 31

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.

Question 32

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.

Question 33

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

Question 34

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

A) duplicate
B) alias
C) self
D) union

Question 35

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.

Question 36

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

Question 37

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.

Question 38

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

Question 39

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

Question 40

The outer join is the default join operation in Access.

Question 41

After you hide a field in a datasheet, you can redisplay the hidden field using a shortcut menu.

Question 42

What criterion should you use in the Bedrooms field to select records of houses for sale with exactly four bedrooms?

A) 4
B) >=4
C) <>4
D) "Is 4"

Question 43

What property controls both the values that users can enter into a text box and provides a visual guide as users enter data?

A) Input Mask
B) Format
C) Visual Guide
D) Caption

Question 44

(999)000-000;1;_ would be a possible entry for which field property?

A) Input Mask
B) Format
C) Required
D) Field Size

Question 45

To set the properties for an entire table, open the table's property sheet in Table Design view.

Question 46

For a Date/Time field, use the _____ property to display the date 1/17/2017 as January 17, 2017.

A) Input Mask
B) Caption
C) Lookup
D) Format

Question 47

A(n) _____ is an intentional "nothing" entry, which you might use for employees who do not want their email addresses stored in the database.

A) index
B) blank string
C) validation text
D) zero-length string

Question 48

In large datasheets, you can ____ certain fields so that they remain on the screen at all times.

A) freeze
B) hide
C) duplicate
D) format

Question 49

After you freeze a field in a query datasheet, you must run the query again before you can unfreeze the field.

Question 50

Which of the following could you use as a criterion in a Number field? Select all the options that apply.

A) >0
B) <=0
C) Is Not Null
D) <0>

Question 51

To set the validation text for a table in Table Datasheet view, you use the _____ button on the Table Tools Fields tab.

A) Validation
B) Property Sheet
C) Message
D) Required

Question 52

In Table Design view, "State must be AZ or CO" is an example of integrity text.

Question 53

A common place to use the Input Mask property is for a FirstName field.

Question 54

You cannot use the Validation Rule property with Short Text or Date/Time fields.

Question 55

The Input Mask property provides a pattern for data to be entered, such as for a phone number.

Question 56

The _____ property creates an easy-to-use visual guide to help users enter accurate data.

A) Phone Number
B) Pattern
C) Input Mask
D) Default Value

Question 57

To view all the indexes in a table at the same time, use the Indexes button in Table Design view.

Question 58

You can freeze one or more fields in a datasheet so they remain visible at all times.

Question 59

What happens if you hide the Bonus column in the Employees table in Table Datasheet view?

A) The Bonus field is removed from all objects based on the Employees table.
B) Only the Bonus column heading appears in the Employees datasheet.
C) The Bonus column no longer appears in the datasheet, but is still part of the Employees table.
D) The Bonus column moves to the end of the datasheet.

Question 60

Hiding a column in Table Datasheet view is that same as freezing the column.

Question 61

When exporting to XML, Access creates an _____ helper file that contains a description of the data's characteristics.

A) XSD
B) XLSX
C) XP
D) HTML

Question 62

If you often sort on a field, you should set its_____ property to Yes.

A) Required
B) Caption
C) Bound Column
D) Indexed

Question 63

The Database Documenter provides step-by-step help for using an Access database.

Question 64

A(n) _____ provides a template for designing a form.

A) Access web app
B) Application Part
C) Quick Style
D) SharePoint server

Question 65

If you set the _____ property for a field that is often used for sorting, you improve database performance.

A) Sort
B) Indexed
C) Duplicates
D) Validation

Question 66

You use the _____ property of a query to document the purpose or author of the query.

A) Purpose
B) Object
C) Miscellaneous
D) Description

Question 67

The Performance Analyzer recommends how you can improve database performance.

Question 68

To set the Validation Text property for a table in Table Design view, you use the _____.

A) Validation Text property for any field in the table
B) Object dialog box
C) Expression dialog box
D) property sheet for the table

Question 69

The Enabled property specifies whether you can edit a control in Form view.

Question 70

You can select a particular form, such as a Navigation form, to display when Access starts.

Question 71

Which type of template creates a traditional Access database?

A) Application Part
B) custom web app
C) custom desktop
D) desktop database

Question 72

To share form data among two or more programs, export the form as a(n) _____ file.

A) another Access database
B) Excel
C) XML
D) PDF

Question 73

You use _____ to mark up structured data so you can easily share the data with other programs.

A) XML
B) HTML
C) ODBC
D) dBase

Question 74

Which of the following types of tables can you create from an Application Part? Select all the options that apply.

A) blank table
B) contacts table
C) tasks table
D) issues table

Question 75

You can recover a forgotten database password by opening the database in Exclusive mode.

Question 76

What would you use to quickly create an Issues table and related forms?

A) a Custom Table
B) a Quick Part
C) an Application Part
D) an Outlook task

Question 77

A(n) _____ is a template for creating a table that contains fields and specifies their data types.

A) Application Part
B) Access web app
C) Navigation form
D) Data Type Wizard

Question 78

An XML file is a text file containing Extensible Markup Language tags that identify field names and data.

Question 79

If you set the _____ property to Yes for the CustEmail field, that means users can enter two quotation marks ("") in the field to mean no entry.

A) Allow Zero Length
B) Allow Multiple Values
C) Allow Value List Edits
D) Allow Null

Question 80

Which of the following types of files does Access create when it exports data to the XML file format? Select all the options that apply.

A) XAM
B) XML
C) XSD
D) XSL