Deck 1: Access 2019

Question 1

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

Answer 1

False

Question 2

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

Answer 2

True

Question 3

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

Answer 3

False

Question 4

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

Question 5

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

Question 6

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

Question 7

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

Question 8

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

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

Question 9

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

Question 10

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

Question 11

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

Question 12

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

Question 13

To select fields and records to answer a question, you most likely create a form object.

Question 14

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

Question 15

A new blank desktop database includes one table named Table1.

Question 16

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

Question 17

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

Question 18

To learn more about a data type, you can enter the name of the data type in the Tell Me box.

Question 19

After starting Access, which of the following is the fastest way to open a database you worked on yesterday?

A) Click Open Other Files, click Browse, navigate to and click the database file, and then click Open.
B) Click the database you want to open in the list of recent databases.
C) Click Blank database and then enter a name for the new database.
D) Right-click Blank database and then click Open.

Question 20

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

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

Question 21

Which data type works best to store dollar amounts?

A) Money
B) Number
C) Decimal
D) Currency

Question 22

The _____ to the left of a table record indicates that you are editing the record.

A) pencil symbol
B) star symbol
C) plus sign
D) minus sign

Question 23

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 24

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

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

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

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

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

Question 27

A _____ typically shows all the fields for one record on a single screen for data entry and editing.

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

Question 28

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 29

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 30

Which data type stores only one of two values?

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

Question 31

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 32

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 33

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 34

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

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

Question 35

What should you do when you are finished working 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 36

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 37

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

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

Question 38

Use the _____ to exit Access.

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

Question 39

Which two properties are required for every field?

A) Field Size and Format
B) Default Value and Data Type
C) Field Name and Field Size
D) Field Name and Data Type

Question 40

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 41

Microsoft Access can best be described as ____ software.

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

Question 42

In which object can you rename a field?

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

Question 43

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

Each row in a table datasheet displays a _____.

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

Question 46

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 47

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 48

Creating a table in Design view involves entering the field names and defining the _____ for the fields.

A) properties
B) purpose
C) appearance
D) criteria

Question 49

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

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

Question 50

Which key do you press to remove all characters when editing a field value in Table Datasheet view?

A) BACKSPACE
B) DELETE
C) LEFT ARROW
D) ESC

Question 51

Tyler created a table with an AutoNumber primary key field, and then entered 10 records in alphabetic order by the values in the LastName field. When he closes and then reopens the table, how are the records ordered?

A) by LastName field
B) by the primary key field
C) by any date field
D) by the first field in the table

Question 52

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

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

Question 53

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 54

Database templates create tables and queries, but not forms and reports.

Question 55

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 56

Carrie entered 10/16/21 as the date in a field with the Date/Time data type and the default format. How does Access format the year in the date after Carrie moves to a new field?

A) as a two-digit year value
B) as a four-digit year value
C) by omitting the year value
D) using the number of digits entered

Question 57

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 58

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

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 61

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

Question 62

When using the Report Wizard, you can click the Back button to review previous dialog boxes.

Question 63

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

Question 64

When viewing a long datasheet, which of the following is the fasted way to move to the end of the datasheet?

A) Click the Last record button in the navigation bar.
B) Click the Next field button in the navigation bar.
C) Press PAGE DOWN.
D) Press RIGHT ARROW.

Question 65

You can use a report to enter a record into the database.

Question 66

To resize a datasheet column to its best fit, you double-click the vertical line to the right of the field name.

Question 67

What happens when you save and close a query?

A) Access saves the query design.
B) Access makes a copy of the data, which is saved in the query.
C) Access timestamps the data as being part of this query.
D) Access makes a backup of the data.

Question 68

When you create a table in Table Datasheet view, Access assigns the name PrimaryID to the first field, which you must rename.

Question 69

You can enter, edit, and navigate data in a query datasheet just like in a report datasheet.

Question 70

To navigate to the first record in a form, first switch to Form Design view.

Question 71

A _____ is a predesigned database that includes professionally designed tables, reports, and other database objects.

A) theme
B) blank database
C) custom database
D) template

Question 72

For a field using number values that will not be used in calculations, you should assign the Short Text data type.

Question 73

On a form, you use Edit view to enter, edit, and delete records.

Question 74

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 75

To navigate records in Form view, you use the buttons on the _____.

A) navigation bar
B) Navigation Pane
C) Home tab
D) record bar

Question 76

What is the main purpose of a form?

A) to provide an easy-to-use format for entering and editing records
B) to prevent changes to the data in tables
C) to display records without allowing changes to them
D) to preview the contents of reports

Question 77

What is the difference between entering a record using a form and entering a record using a datasheet?

A) A form uses a different navigation bar from the one in a datasheet.
B) A form cannot be sorted, while a datasheet can.
C) A form presents records one at a time, while a datasheet lists all records.
D) A form displays field names and record data, while a datasheet does not.

Question 78

The Form Wizard prompts you for information it needs to create a form, such as the fields, layout, and title for the form.

Question 79

A field's data type determines what values you can enter for the field.

Question 80

What data type should you assign to a field that stores postal codes?

A) Number
B) Address
C) Required
D) Short Text