Deck 1: Access 2019

Question 1

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

Answer 1

False

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

A new blank desktop database includes one table named Table1.

Answer 3

True

Question 4

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

Question 5

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

Question 6

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

Question 7

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

Question 8

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

Question 9

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

Question 10

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

Question 11

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

Question 12

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

Question 13

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

Question 14

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

Question 15

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

Question 16

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

Question 17

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

Question 18

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

Question 19

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

Question 20

Access displays your user account information in the Navigation Pane.

Question 21

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

Question 22

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

Question 23

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

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

Question 24

Which data type stores only one of two values?

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

Question 25

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 26

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

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

Question 27

_____ view provides the most options for defining fields.

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

Question 28

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

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

Question 29

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 30

Each item on a form is called a _____.

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

Question 31

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 32

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 33

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 34

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

Question 35

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 36

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 37

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 38

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 39

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

Which data type stores email addresses?

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

Question 42

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 43

Use the _____ to exit Access.

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

Question 44

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 45

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

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

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

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 48

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 49

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 50

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

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

Question 51

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

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

Question 52

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 53

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 54

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

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

Question 55

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

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

Question 56

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 57

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 58

In which object can you rename a field?

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

Question 59

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 60

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

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

Question 61

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 62

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 63

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

Question 64

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 65

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 66

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 67

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 68

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

Question 69

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 70

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 71

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

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

Question 72

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

Question 73

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

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

Question 74

Each row in a table datasheet displays a _____.

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

Question 75

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

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

Question 76

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 77

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

Question 78

Microsoft Access can best be described as ____ software.

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

Question 79

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 80

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

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