Deck 1: Getting Started With Excel

Question 1

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

Answer 1

False

Question 2

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.

Answer 2

D

Question 3

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

Answer 3

True

Question 4

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

Question 5

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 6

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 7

A new blank desktop database includes one table named Table1.

Question 8

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

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

Question 9

Which data type stores only one of two values?

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

Question 10

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

Question 11

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.

Question 12

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

Question 13

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

Question 14

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

Question 15

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

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

Question 16

_____ view provides the most options for defining fields.

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

Question 17

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

Question 18

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 19

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

Question 20

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 21

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 22

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

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

Question 23

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 24

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 25

In which object can you rename a field?

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

Question 26

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 27

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 28

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 29

Which data type stores web addresses?

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

Question 30

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

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

Question 31

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

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

Question 32

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 33

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

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

Question 34

Each item on a form is called a _____.

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

Question 35

Use the _____ to exit Access.

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

Question 36

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 37

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

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

Question 38

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 39

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 40

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 41

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 42

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 43

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

Each row in a table datasheet displays a _____.

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

Question 46

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 47

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 48

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 49

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 50

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 51

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 52

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 53

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 54

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 55

Microsoft Access 2016 can best be described as ____ software.

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

Question 56

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

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

Question 57

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 58

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 59

Which of the following are Access objects?

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

Question 60

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 61

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

Question 62

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 63

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

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

Question 64

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

Question 65

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

Question 66

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 67

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

Question 68

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

Question 69

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

Question 70

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 71

When editing a record using a form,how can you move from field to field in the same record?

A) Press TAB.
B) Click the Next field button in the navigation bar.
C) Press the PAGE DOWN key.
D) Click the right arrow button in the navigation bar.

Question 72

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 73

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 74

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

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 77

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 78

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

Question 79

You use the Report tool to quickly create a report based on the selected table.

Question 80

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