Deck 12: Developing an Excel Application

Question 1

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

Answer 1

True

Question 2

The Performance Analyzer recommends how you can improve database performance.

Answer 2

True

Question 3

You use the Performance Analyzer to analyze tables only.

Answer 3

False

Question 4

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

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

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 7

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 8

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 9

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

Question 10

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

Question 11

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

Question 12

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 13

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

Question 14

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

Question 15

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 16

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

Question 17

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

Question 18

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 19

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

Question 20

Use the _____ Table Manager to manage a split database.

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

Question 21

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

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

Question 22

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

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

Question 23

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

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

Question 24

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 25

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 26

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 27

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

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

Question 28

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

Question 29

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

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

Question 30

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 31

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 32

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

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

Question 33

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 34

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

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

Question 35

_____ 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 36

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

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

Question 37

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 38

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 39

One reason to split a database is to improve performance.

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

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 42

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 43

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 44

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 45

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 46

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 47

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 48

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 49

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 50

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 51

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 52

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

Question 53

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 54

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 55

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 56

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

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

Question 57

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 58

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 59

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

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

Question 60

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 61

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 62

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

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

Question 63

If you add Is Null as the criterion for the Advisor field in the Students table,what are the results?

A) Advisors without students
B) Students with advisors
C) Students with more than one advisor
D) Students without advisors

Question 64

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

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

Question 65

Which of the following criteria selects records for customers except those who live in New York,even if the City field is blank?

A) Null OR Not "New York"
B) Is Not Null OR "New York"
C) Not "New York"
D) Is Null OR Not "New York"

Question 66

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

Question 67

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 68

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 69

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

Question 70

Where do you set the Allow Multiple Values property of a field in Table Design view?

A) in the Data Type column of the upper pane
B) on the Lookup tab of the Field Properties pane
C) in the property sheet for the table
D) in the Description column of the upper pane

Question 71

How do you enter more than one value in a multivalued lookup field in Table Datasheet view?

A) Type the values separated by periods.
B) Drag each value from other records to the multivalued lookup field.
C) Click the arrow in the field,and then click a check box for each value.
D) Click the record selector,and then click each value.

Question 72

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 73

To create a multivalued field in Table Design view,enter Yes in the Allow Multiple Values Lookup property.

Question 74

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

Question 75

In Table Design view,you create a lookup list of values you enter using the _____ Lookup property of a field.

A) Limit to List
B) Allow Multiple Values
C) Field Size
D) Row Source

Question 76

Which of the following statements accurately describe null field values? Select all the options that apply.

A) You enter a null value by typing two quotation marks ("").
B) A null field value indicates unknown data.
C) You can use the Is Null criterion to select records with null values.
D) You enter a null value by leaving a field blank in a record.

Question 77

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 78

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 79

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 80

_____ fields allow you to make more than one choice from a field's lookup list.

A) Indexed
B) Long Text
C) Attachment
D) Multivalued