Deck 12: Developing an Excel Application

Question 1

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

Answer 1

True

Question 2

What Access tool should you use if the path to the back-end database changes and you need to reconnect the front-end and back-end databases?

A) Linked Table Manager
B) Database Connector
C) Database Documenter
D) Table Location Manager

Answer 2

A

Question 3

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

Answer 3

False

Question 4

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

Question 5

How can examining object dependencies help you when developing a database?

A) It identifies potential performance problems.
B) It flags naming conflicts among database objects.
C) It deletes objects you have not used recently.
D) It can prevent you from deleting a query used by another object.

Question 6

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 7

You can keep an action query in the Navigation Pane but hide it using the Hidden property.

Question 8

Before deleting a query, you can view its _____ to determine if any other queries, forms, or reports depend on that query.

A) linked tables
B) object dependencies
C) trusted folder
D) Database Documenter report

Question 9

Use the _____ Table Manager to manage a split database.

A) Split
B) Datasheet
C) Linked
D) Front-End

Question 10

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

Question 11

Because it can be dangerous to leave action queries in the Navigation Pane, you can _____ an action query you want to run again.

A) hide
B) disable
C) export
D) link

Question 12

The Performance Analyzer recommends how you can improve database performance.

Question 13

If you move the source of a linked table, you must update its location using the Linked Table Manager.

Question 14

To keep the Navigation Pane hidden in the Access window, you set a(n) _____ option.

A) security
B) exclusive mode
C) window design
D) startup

Question 15

The text you specify for the Application Title property appears in the title bar instead of the database filename.

Question 16

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

Question 17

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 18

To view a list of the database objects that depend on the selected object, open the Object Dependencies pane.

Question 19

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

Question 20

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 21

Database passwords are case sensitive, which means that IOWA and iowa are different passwords.

Question 22

A front-end database contains _____ to the tables in the back-end database.

A) updates
B) links
C) relationships
D) maps

Question 23

You can _____ an Access database into a back-end database and front-end database.

A) split
B) convert
C) backup
D) reconfigure

Question 24

_____ passwords are longer than eight characters and use the entire keyboard, including uppercase and lowercase letters, numbers, and symbols.

A) Split
B) Strong
C) Combination
D) Exclusive

Question 25

When you split a database, the back-end database contains all of the queries, forms, and reports in the database.

Question 26

Which of the following is a startup command-line option?

A) /repair
B) /excl
C) /open
D) /trust

Question 27

The most important items in the Performance Analyzer results are the _____ and the suggestions.

A) recommendations
B) ideas
C) lightbulb icons
D) proposals

Question 28

If you set a database _____, all users must enter that combination of characters before they are allowed to open the database.

A) password
B) startup option
C) permission
D) share list

Question 29

When you split an Access database, what do you call the database containing all the tables?

A) Front-end database
B) File-server database
C) Back-end database
D) Back-up database

Question 30

When you type a password in the Set Database Password dialog box, _____ appear instead of the characters you typed.

A) question marks (?)
B) quotation marks (")
C) dashes (-)
D) asterisks (*)

Question 31

When you split an Access database, what do you call the database stored on your computer?

A) Client-end database
B) Object database
C) Front-end database
D) Table database

Question 32

Set the _____ Form startup option to specify which form opens when the database opens.

A) Initial
B) Splash
C) Navigation
D) Display

Question 33

Exception mode means that you are the only person who has the database open, and others cannot open the file during this time.

Question 34

You set the opening Display Form for a database using the Access Preferences dialog box.

Question 35

Set the Database Title property of a database to change the text displayed in the title bar.

Question 36

What must you do before setting a password for a database?

A) Split the database.
B) Open the database in Exclusive mode.
C) Remove any linked tables from the database.
D) 'Set a password for each object in the database.

Question 37

You use the Performance Analyzer to analyze tables only.

Question 38

One reason to split a database is to improve performance.

Question 39

_____ means to make the data in a database unreadable by other software.

A) Encrypting
B) Backing up
C) Compacting
D) Trusting

Question 40

When you split an Access database, how many copies of the back-end database do you have?

A) One copy for each user
B) One copy for each object in the database
C) One copy
D) Two copies

Question 41

Which of the following are types of advice the Performance Analyzer gives regarding performance? Select all the options that apply.

A) Suggestion
B) Idea
C) Issue
D) Recommendation

Question 42

Which startup command-line option opens the database for exclusive access?

A) '/ro
B) '/excl
C) '/exclusive
D) '/enable

Question 43

Which Access tool studies the structure and size of a database and recommends how to improve its speed?

A) Object Dependencies pane
B) Performance Analyzer
C) Relationships report
D) Database Optimizer

Question 44

You can manage default startup options using features in the _____ category of the Access Options dialog box.

A) Current Database
B) Trust Center
C) Security
D) Advanced

Question 45

After you split a database, what does the back-end database contain?

A) Links to the database tables
B) Queries, forms, and reports
C) Queries, forms, and reports
D) The database tables

Question 46

Which of the following are ways to help secure an Access database? Select all the options that apply.

A) Password
B) Encryption
C) Show/hide objects
D) Attachment fields

Question 47

The _____ property displays a value that is automatically entered in the field for new records.

A) New Record
B) AutoEntry
C) Default Value
D) Starting Value

Question 48

To set a startup form, click the File tab, and then click _____.

A) New
B) Open
C) Options
D) Account

Question 49

_____ data is scrambled so that it is indecipherable when opened by another program.

A) Encrypted
B) Compacted
C) Read-Only
D) Linked

Question 50

Set the _____ startup option to add a custom title to the title bar instead of the database name and path.

A) Program Title
B) Display Form
C) Application Title
D) 'Caption

Question 51

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 52

A field's Required property determines whether users must enter a value in the field.

Question 53

Which of the following are ways to improve database performance? Select all the options that apply.

A) Compact the database regularly.
B) Add more memory.
C) Convert the database to an earlier format.
D) Close other open applications you do not need.

Question 54

How do you start the Performance Analyzer?

A) Click the Database Tools tab, and then click the Document Database button.
B) Click the Database Tools tab, and then click the Analyze Performance button.
C) Click the Database Tools tab, and then click the Analyze Database button.
D) Click the File tab, click Options, and then click Analyze Performance.

Question 55

What property would you set for a field with a Yes/No data type that usually stores a Yes value?

A) Field Size
B) Default Value
C) Caption
D) Required

Question 56

_____ are a series of commands that execute when the database opens.

A) Macros
B) Modules
C) Startup options
D) Exclusive options

Question 57

Where can you set a field's Default Value in Table Design view?

A) in the Description column
B) in the Validation dialog box
C) on the Lookup tab
D) in the Field Properties pane

Question 58

What do you use to open a database in Exclusive mode?

A) Create tab on the ribbon
B) Navigation Pane
C) Open dialog box
D) Access Options dialog box

Question 59

Use the Default field property to specify that an entry is required for the field.

Question 60

Which Short Text field property should you use to indicate users must enter a value in the field?

A) Default
B) Required
C) Validation Rule
D) Yes/No

Question 61

To create a filter using the _____ feature, you work in a view similar to Query Design view.

A) Filter By Selection
B) Filter by Form
C) Advanced Filter
D) Comparison

Question 62

To query for null values, use Is Null as the criterion.

Question 63

To remove filter criteria from the Filter by Form grid, you _____.

A) open a new form
B) click the Advanced button, and then click Clear All Filters
C) click the Toggle Filter button
D) click the Filter by Form button, and then click Clear

Question 64

Number fields store values that represent quantities, measurements, and scores, for example.

Question 65

The term _____ describes a field value that does not exist because it has never been entered.

A) join
B) zero-length
C) orphan
D) null

Question 66

To close a query from SQL view, you can _____.

A) click the View button in the Results group
B) click the Run button in the Results group
C) right-click the query tab and then click Close on the shortcut menu
D) double-click the query in the Navigation Pane

Question 67

Which of the following statements are true about field properties? Select all the options that apply.

A) Modifying the properties helps ensure database accuracy.
B) Some properties are required, and some are optional.
C) The properties are the same for each data type.
D) The properties can be used to change the way data is displayed.

Question 68

If users must enter data in a LastName field, what property should you set for the field?

A) Short Text
B) Required
C) Referential Integrity
D) Indexed

Question 69

Which of the following properties can you set for a Short Text field?

A) Format
B) Decimal Places
C) Default Value
D) Input Mask

Question 70

You click the _____ button to close the Filter by Form grid.

A) Delete
B) Advanced
C) Selection
D) Toggle Filter

Question 71

If most records will contain "NY" in the State field, enter _____ as the _____ property for the State field.

A) NY; Default Value
B) State; Default Value
C) NY; Input Mask
D) State; Field Size

Question 72

What data type is most appropriate for a field named SquareFeet?

A) Hyperlink
B) Attachment
C) Number
D) AutoNumber

Question 73

What happens when you run a query with the Is Null criterion in the Product Type field?

A) The results include only records with a correct Product Type value.
B) The query deletes the values in the Product Type field.
C) The query moves records with no Product Type value to a history table.
D) The results include only records with no Product Type value.

Question 74

What data type should you assign to a CourseHours field that stores the hours required to complete a course?

A) AutoNumber
B) Short Text
C) Hours
D) Number

Question 75

Use the Number data type for fields that store postal codes.

Question 76

Query for zero-length values by entering Is Null as the criterion.

Question 77

If users must enter text in a LastName field, you can set the _____ property for the field in Table Datasheet view.

A) Unique
B) Indexed
C) Default Value
D) Required

Question 78

When you add fields to a table in Table Design view, the _____ is optional.

A) Field Size
B) Field Description
C) Data Type
D) Field Name

Question 79

Which of the following are properties you can set for a Short Text field in Table Datasheet view? Select all the options that apply.

A) Name
B) Append Only
C) Required
D) Field Size

Question 80

To find employee records that do not contain an entry in the Email field, use the _____ criterion in the Email field.

A) Is Not Null
B) Is Null
C) Find Unmatched
D) Is Blank