Deck 8: Access

Question 1

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

Answer 1

object dependencies

Question 2

In Form Layout view of a navigation form, you can double-click the navigation button to _____.

A) rename the navigation button
B) open the object associated with the button
C) open the Property Sheet for the button
D) move the navigation button

Answer 2

rename the navigation button

Question 3

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

Answer 3

startup

Question 4

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

Question 5

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

Question 6

Which of the following security methods makes data indecipherable to other programs when sent across a network?

A) Encryption
B) Password
C) Startup options
D) Split a database

Question 7

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

Question 8

A SharePoint list is a collection of data that you can share with other people who use the SharePoint site.

Question 9

Which of the following types of external files can you link to an Access database? Select all the options that apply.

A) dBase file
B) SharePoint list
C) Word table
D) HTML document

Question 10

How can you reorder the navigation buttons in a navigation form in Form Layout view?

A) Drag a navigation button to a new position.
B) Use the Tab Order dialog box.
C) Use the Ascending and Descending buttons to sort the navigation buttons.
D) Set the Button Order property for the navigation buttons.

Question 11

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

Question 12

You can drag a report from the Navigation Pane to an [Add New] button to add the report to the navigation form in Form Layout view.

Question 13

What must you do before setting a database password?

A) Back up the database.
B) Open the database in Exclusive mode.
C) Encrypt the database.
D) Split the database.

Question 14

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 15

When you clone a database, you create a back-end database and a front-end database.

Question 16

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

Question 17

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 18

Use the _____ Table Manager to manage a split database.

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

Question 19

Trusting a database means to verify the authenticity of a database with a digital signature.

Question 20

Unsecure databases automatically enable all content, so they do not present the Enable Content message when they open.box.

Question 21

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

Question 22

In a Navigation form, you reorder tabs by dragging them to a new location on the form.

Question 23

One reason to split a database is to improve performance.

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

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

Question 27

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

Question 28

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

Question 29

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

Question 30

For a table, the _____ produces a report listing the field names, property values for each field, and table relationships.

A) Linked Table Manager
B) Database Documenter
C) Performance Analyzer
D) Object Dependencies pane

Question 31

The Performance Analyzer recommends how you can improve database performance.

Question 32

What happens when you drag a tab on a Navigation form in Form Layout View?

A) You delete the tab from the Navigation form.
B) You reorder the tabs on the Navigation form.
C) You increase the width of the Navigation form.
D) You make a copy of the tab on the Navigation form.

Question 33

You use the Performance Analyzer to analyze tables only.

Question 34

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

_____ a database means to identify the database file as safe to open.

A) Securing
B) Enabling
C) Trusting
D) Splitting

Question 38

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

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

Question 39

A database in a trusted folder enables all database content, including all macros and VBA.

Question 40

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

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

Question 41

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 42

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 43

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 44

What is the result of using the Database Documenter?

A) A list of recommendations and tips for improving performance
B) A report providing details on the objects and properties of the database
C) A list of orphan records
D) A report on how to make the database more secure

Question 45

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

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

Question 46

How can you prevent the security warning with the Enable Content button from appearing when you open an Access database?

A) Store the database in a trusted folder.
B) Change the Enable Content startup option.
C) Split the database.
D) Compact and repair the database.

Question 47

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

A) Links to the database tables
B) Queries, forms, and reports
C) Only customized data-entry forms
D) The database tables

Question 48

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

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

Question 49

You can trust a database or a folder using the features in the _____ category of the Access Options dialog box.

A) Current Database
B) Trust Center
C) Client Settings
D) General

Question 50

Which of the following Access options provides a way to set security, macro, and other privacy settings?

A) Add-ins
B) Current Database
C) Customize Ribbon
D) Trust Center

Question 51

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

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

Question 52

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

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

Question 53

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

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

Question 54

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

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

Question 55

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

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

Question 56

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 57

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 58

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 59

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 60

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 61

Tables contain and execute class modules.

Question 62

A function created in a standard module can be used in any query in the database.

Question 63

_____ modules are displayed as module objects in the Navigation Pane.

A) Class
B) Standard
C) Macro
D) Method

Question 64

Standard modules are also called universal modules.

Question 65

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 66

A macro is an Access object that stores Visual Basic for Applications (VBA) programming code.

Question 67

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 68

A(n) event is a procedure that returns a value.

Question 69

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 70

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 71

To create a backup of a module, you can right-click a module to copy and paste it like any other object.

Question 72

If you create a function in a standard module, it applies only to the current object.

Question 73

You can use a function created in a standard module in any query in the database.

Question 74

You might want to create a function to calculate a value based on your company's unique business rules.

Question 75

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

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

Question 76

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 77

Which of the following describe the reports created by the Database Documenter? Select all the options that apply.

A) You can print the Database Documenter reports.
B) You can save the Database Documenter reports in the database.
C) You can set an option to include table relationships in the reports.
D) You can set an option to include field property values in the reports.

Question 78

A _____ module is stored as a part of the form or report in which it was created.

A) global
B) class
C) standard
D) sub

Question 79

Class modules are stored in an individual form or report.

Question 80

Which VBA keyword(s) do you use to declare the name and arguments that create a new function procedure?

A) Start Function
B) Function
C) Option Function
D) Declare Function