Question 1

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

Accepted Answer

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

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

Accepted Answer

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

Which data type stores web addresses?

Accepted Answer

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

Question 4

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

Accepted Answer

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

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

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

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

Question 8

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

Accepted Answer

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

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

In which object can you rename a field?

Accepted Answer

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

Question 11

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

Accepted Answer

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

Question 12

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

Accepted Answer

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

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

Accepted Answer

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

Question 14

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

Accepted Answer

False - ed

Question 15

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

Accepted Answer

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

Question 16

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

Accepted Answer

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

Question 17

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

Accepted Answer

False - ta

Question 18

Each row in a table datasheet displays a _____.

Accepted Answer

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

Question 19

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

Accepted Answer

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

Question 20

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

Accepted Answer

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

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

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

Which data type stores web addresses?

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

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

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

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

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

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

In which object can you rename a field?

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

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

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

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

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

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

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

Each row in a table datasheet displays a _____.

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

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

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Generating Reports From Multiple Worksheets and Workbooks

Managing Data With Data Tools

Summarizing Data With Pivottables

Performing What-If Analyses

Exploring Financial Tools and Functions

Analyzing Data With Business Intelligence Tools

Exploring Pivottable Design

Developing an Excel Application

Filters

Exam 1: Getting Started With Excel

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

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

Which data type stores web addresses?

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

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

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

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

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

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

In which object can you rename a field?

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

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

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

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

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

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

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

Each row in a table datasheet displays a _____.

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

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

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Generating Reports From Multiple Worksheets and Workbooks

Managing Data With Data Tools

Summarizing Data With Pivottables

Performing What-If Analyses

Exploring Financial Tools and Functions

Analyzing Data With Business Intelligence Tools

Exploring Pivottable Design

Developing an Excel Application

Filters