Deck 1: Getting Started With Excel

Question 1

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

Answer 1

False - query
False - Query
False - QUERY

Question 2

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

Answer 2

False - edit
False - Edit
False - EDIT

Question 3

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

A) Start Access from the Start menu.
B) Double-click the database icon.
C) Start Access, and then create a new database.
D) Right-click the database icon.

Answer 3

B

Question 4

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

Question 5

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

Question 6

_____ view provides the most options for defining fields.

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

Question 7

A new blank desktop database includes one table named Table1.

Question 8

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

Question 9

When you double-click an Access database icon, you have the choice of opening a database or creating a new one.

Question 10

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

Question 11

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

Question 12

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

Question 13

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

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

Question 14

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

Question 15

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

Question 16

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

Question 17

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

Question 18

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

Question 19

You can use the Compact and Repair Database button on the Database Tools tab to reduce the size of the database.

Question 20

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

Question 21

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 22

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 23

Use the _____ to exit Access.

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

Question 24

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 25

Which data type stores only one of two values?

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

Question 26

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

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

Question 27

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

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

Question 28

When you _____ a database, you reduce the size of the database by up to 75 percent.

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

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

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 31

Each item on a form is called a _____.

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

Question 32

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

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

Question 33

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

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

Question 34

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 35

Which data type stores web addresses?

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

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

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 39

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

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

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

What Access tool can you use to enter dates in a Date/Time field?

A) Date Box
B) Calendar Picker
C) Property Sheet
D) Lookup Wizard

Question 42

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

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

Question 43

Which of the following are advantages of using Microsoft Access to manage data? Select all the options that apply.

A) Access provides data-entry forms.
B) Access allows more than one user to enter data at the same time.
C) Access stores all the data in a single table.
D) Access minimizes duplicate data.

Question 44

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 45

Which of the following is a best practice when you are creating a table containing employee names?

A) Separate the first and last names into two fields.
B) Keep the first and last names together in one field.
C) Assign the Long data type to any field containing names.
D) Create the table in Table Datasheet view.

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

In which object can you rename a field?

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

Question 48

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 49

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 50

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 51

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 52

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 53

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 54

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 55

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 56

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

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

Question 57

Each row in a table datasheet displays a _____.

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

Question 58

Microsoft Access 2016 can best be described as ____ software.

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

Question 59

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 60

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 61

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

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

Question 62

Which of the following are properties you can set for a field? Select all the options that apply.

A) Font Color
B) Field Name
C) Field Size
D) Default Value

Question 63

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

Question 64

Which of the following are features of Access reports? Select all the options that apply.

A) headers
B) calculations on groups of records
C) easy-to-use data entry screens
D) footers

Question 65

Which of the following are tasks you perform when creating tables? Select all the options that apply.

A) Name the table.
B) Define the fields in the table.
C) Select a data type for each field.
D) Arrange the controls for easy data entry.

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 are Access objects?

A) forms
B) spreadsheets
C) reports
D) queries

Question 68

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

Question 69

Which of the following statements describe a query datasheet? Select all the options that apply.

A) You can edit the records in a query datasheet.
B) You store data in a query by entering a record in a query datasheet.
C) You can display a subset of records and fields from a table in a query datasheet.
D) You can sort and filter a query datasheet.

Question 70

Which of the following techniques can you use to navigate to the next record in a datasheet? Select all the options that apply.

A) First record button
B) Next record button
C) TAB key
D) DOWN ARROW key

Question 71

You enter and edit data in a query datasheet in the same way you do in a table datasheet.

Question 72

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

Question 73

Which of the following are examples of changing a table's design? Select all the options that apply.

A) Add a field to the table.
B) Rename a field in the table.
C) Change a field value.
D) Change a field's data type.

Question 74

Which of the following are Access data types? Select all the options that apply.

A) Number
B) Street Address
C) Date/Time
D) Currency

Question 75

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 76

What can you do with the navigation buttons on a datasheet? Select all the options that apply.

A) Move the focus to the next record.
B) Create a new blank record.
C) Delete a record.
D) Move the focus to the first record.

Question 77

Which of the following options are available to you when you start Access? Select all the options that apply.

A) Import an existing database.
B) Open an existing database.
C) Create a new blank database.
D) Create a database from a template.

Question 78

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

Question 79

Which of the following can you define in Table Datasheet view? Select all the options that apply.

A) field descriptions
B) field names
C) data types
D) field properties

Question 80

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