Deck 1: Access-2019

Question 1

For a Comments field that contains many words, set a Long data type.

Answer 1

True

Question 2

When you add a field to a table in Table Design view, entering the field name is optional.

Answer 2

False

Question 3

Table Design view shows how each table relates to other tables in the database.

Answer 3

False

Question 4

A new blank desktop database includes one table named Table1.

Question 5

When you enter a record in a table, you are working in navigation mode.

Question 6

To display the data in a table, you open the table in Table Design view.

Question 7

To navigate to a record in a table, switch to Table Design view.

Question 8

After you create a table, you must save the entire database so you do not lose the new table.

Question 9

Use the New (blank) record button to move the focus to the first record in a table.

Question 10

Before you close a database, you must save any changes you made to the data.

Question 11

To rename a form, open the form, and then use the Rename command on the Home tab.

Question 12

To enter data in a table, open it in Table Datasheet view.

Question 13

Access displays your user account information in the Navigation Pane.

Question 14

When you start Access, the first screen that appears is one showing a blank database.

Question 15

You can create a table in Table Datasheet view or Table Design view.

Question 16

A field with the Currency data type contains values such as quantities, measurements, and scores.

Question 17

Compacting a database has the same result as backing up a database.

Question 18

To learn about the new features in Access, you can use the Tell Me box.

Question 19

Before you can rename a field, you must change its data type.

Question 20

Compacting a database rearranges the data and objects in a database to decrease its file size.

Question 21

The _____ refers to the data you would edit if you started typing.

A) focus
B) emphasis
C) editor
D) highlight

Question 22

Which of the following tools can you use to create a query?

A) Choose Fields Wizard
B) Simple Query Wizard
C) query datasheet
D) Blank Query Wizard

Question 23

A group of related fields, such as all the demographic information for one customer, is called a _____.

A) table
B) record
C) query
D) field

Question 24

Which data type stores only one of two values?

A) Hyperlink
B) Date/Time
C) Yes/No
D) AutoNumber

Question 25

If you want to manage lists of data about customers and the products they order, use _____ software.

A) spreadsheet
B) relational database
C) tabular
D) communication

Question 26

To rename a field in Table Datasheet view, you change the text in the _____.

A) column heading
B) first record
C) primary key
D) Navigation Pane

Question 27

A form selects a subset of fields and records from one or more tables, and then presents the selected data as a single datasheet.

Question 28

Each item on a form is called a _____.

A) control
B) field
C) layout
D) format

Question 29

Which of the following is the fastest way to open an Access database?

A) Click Open Other Files, click Browse, navigate to the database file, and then double-click it.
B) Double-click its file or shortcut icon.
C) Click Blank database and then enter a name for the new database.
D) Right-click Blank database and then click Open.

Question 30

A category of data such as a customer's name, city, state, or phone number is called a _____.

A) record
B) table
C) data type
D) field

Question 31

Press ESC to remove editing changes you made to the previous record.

Question 32

Of all the database objects, a table provides the most formatting, layout, and summary options.

Question 33

When you _____ a database, you make more storage space available and enhance the performance of the database.

A) back up
B) trust and verify
C) analyze
D) compact and repair

Question 34

Which Access object contains all of the data in the database?

A) form
B) macro
C) table
D) query

Question 35

What should you do if you want to make a copy of a database in a secure location?

A) Back up the database.
B) Compact and repair the database.
C) Convert the database.
D) Split the database.

Question 36

_____ view provides the most options for defining fields.

A) Field Create
B) Field Define
C) Table Create
D) Table Design

Question 37

You might delete an employee record if the employee no longer works for the company.

Question 38

You can create an Access report by selecting fields from one or more tables or _____.

A) records
B) forms
C) queries
D) modules

Question 39

What should you do when you are finished working with a database?

A) Open and then save each object in the database.
B) Close the Navigation Pane.
C) Sign out so other people can use the database.
D) Close the database.

Question 40

What is the most efficient way to navigate to the last record in a table containing 100 records?

A) Press the END key.
B) Press TAB as many times as necessary.
C) Use the Next record button on the navigation bar.
D) Use the Last record button on the navigation bar.

Question 41

Suppose you rename a field in Table Design view. What must you do before you can view the data in the table?

A) Save the field.
B) Check the spelling of the field names.
C) Save the table.
D) Set other properties for the field.

Question 42

In a datasheet, what do you click to select a record for deletion?

A) column heading
B) field in the record
C) record deletion button
D) record selector button

Question 43

When editing a record, what key can you use to navigate to the next record?

A) DOWN ARROW
B) END
C) LEFT ARROW
D) ESC

Question 44

Which of the following templates lets you create a database from scratch?

A) Custom desktop database
B) Blank desktop database
C) Personal database
D) Application database

Question 45

In what part of the Access window do you rename a form?

A) Navigation Pane
B) Form view of the form
C) Print preview of the form
D) Backstage view

Question 46

Two required tasks when creating a field are naming the field and _____.

A) selecting the appropriate data type
B) adding field descriptions
C) specifying all field properties
D) entering at least one record

Question 47

When you use the _____, Access asks you for the information it needs to create a query.

A) Create Query Wizard
B) Form Wizard
C) Query Design command
D) Simple Query Wizard

Question 48

Which of the following is a difference between Table Design view and Table Datasheet view?

A) Table Datasheet view does not display data.
B) Table Design view displays table relationships.
C) Table Design view does not display data.
D) Table Datasheet view does not allow changes.

Question 49

In a datasheet, which mode do you use for changing the value of a field?

A) Update mode
B) Navigation mode
C) Edit mode
D) Modify mode

Question 50

Use the _____ to exit Access.

A) Close button
B) Exit command in Backstage view
C) Exit & Repair button
D) Save button

Question 51

Tables, queries, and forms are examples of Access ____.

A) values
B) objects
C) fields
D) controls

Question 52

When you enter data in the rows of a table datasheet, you are entering _____.

A) keys
B) records
C) tables
D) relations

Question 53

Which data type is used for sequential integers controlled by Access?

A) Number
B) AutoNumber
C) SeqNumber
D) Integer

Question 54

Field _____ are the characteristics that describe each field, including Field Name and Data Type.

A) selectors
B) formats
C) values
D) properties

Question 55

In the _____, Access lists each object in the open database.

A) Objects Bar
B) Database Tools tab
C) Navigation Pane
D) status bar

Question 56

In which object can you rename a field?

A) form
B) macro
C) report
D) table

Question 57

Which data type stores email addresses?

A) Web
B) URL
C) HTML
D) Hyperlink

Question 58

At what point does Access save the data in a database?

A) when you close the database
B) when you finish entering or editing a record
C) when you click the Save button
D) when you close a table

Question 59

A _____ is a grid that displays fields as columns and records as rows.

A) query
B) datasheet
C) logical table
D) report

Question 60

When you edit a record, pressing ESC once removes the changes to the field. What happens if you press ESC a second time?

A) Access restores the changes to the field.
B) Access deletes the record.
C) Access deletes the field.
D) Access removes all changes to the record.

Question 61

Access provides a single database template for creating a blank database.

Question 62

What can you use to find information about Access commands and features and instructions about how to use them?

A) Query Wizard
B) Access Wizard
C) Command box
D) Tell Me box

Question 63

What happens when you close a module?

A) The module begins to run automatically.
B) The Visual Basic window closes.
C) The module is hidden in the Navigation Pane.
D) The Visual Basic window highlights any syntax errors.

Question 64

You can assign most but not all data types to a field in Table Datasheet view.

Question 65

Each row in a table datasheet displays a _____.

A) data type
B) property
C) field
D) record

Question 66

The first step in the Form Wizard is to _____.

A) select a layout for the form
B) select a sort order for the records
C) select the fields to include in the form
D) provide a name for the form

Question 67

In an Employees table, what is the appropriate data type for a field that shows the hiring date?

A) Calendar
B) Date
C) Date/Time
D) Lookup

Question 68

Besides reducing file size, what other benefit does compacting an Access database provide?

A) sorting the records in the database
B) repairing the database
C) saving the database
D) relating tables in the database

Question 69

When you finish creating a report with the Report Wizard, you can choose to preview the report or _____.

A) modify the report's design
B) continue by creating a second report
C) send the report to a colleague
D) print the report

Question 70

To close an Access module, you must close the Visual Basic Editor.

Question 71

_____ is the default name for a new table in an Access database.

A) Table1
B) NewTable
C) Table
D) TableA

Question 72

Microsoft Access can best be described as ____ software.

A) spreadsheet
B) relationship
C) utility
D) database

Question 73

_____ view is a spreadsheet-like view of the data in a table.

A) Design
B) Layout
C) Form
D) Datasheet

Question 74

When does Access save changes you make to a record?

A) when you click the Save button
B) when you close the table
C) when you move to a different record
D) when you select the record

Question 75

The upper pane of _____ view shows field names and data types.

A) Table Datasheet
B) Query Design
C) Table Tools
D) Table Design

Question 76

If the Navigation Pane is not open, click the _____ to open it and view the database objects.

A) Shutter Bar Open/Close button
B) Expand button
C) View tab
D) Navigation bar

Question 77

When you delete a record containing an AutoNumber field, Access discards the value in the AutoNumber field and _____.

A) reuses the same value in the next new record
B) does not reuse the value
C) changes the AutoNumber values in all other records
D) prompts you for the value of the next new record

Question 78

An Access template is a diagram showing the structure of a database.

Question 79

Which of the following does NOT save changes made to a record?

A) When you click the Save button
B) When you close the datasheet
C) When you move to another record
D) As you move from field to field in the same record

Question 80

To back up a database, you use the _____ command.

A) Make a Backup
B) Back Up Database
C) Package and Sign
D) Compact & Repair