Question 1

Which data type links files created in other programs such as pictures or documents?

Accepted Answer

A)  Lookup 
B)  Attachment 
C)  Yes/No 
D)  Link Wizard 
A)  Lookup 
B)  Attachment 
C)  Yes/No 
D)  Link Wizard B

Question 2

Which Access object provides an easy-to-use data entry screen?

Accepted Answer

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

Question 3

A(n) ____________________ key field contains unique data for each record.

Accepted Answer

primary

Question 4

Which two properties are required for every field?

Accepted Answer

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

Question 5

Which of the following is NOT a data type?

Accepted Answer

A)  Number 
B)  Formula 
C)  Date/Time 
D)  Short Text 
A)  Number 
B)  Formula 
C)  Date/Time 
D)  Short Text

Question 6

What are the advantages of using Access for database management?

Accepted Answer

1. Duplicate data is minimized. 
2. Info

Question 7

Match between columns
                        Premises: Previous field of the current record
Current field of the next record
Last field of the current record
First field of the current record
First field of the first record
Last field of the last record
Current field of the previous record
Next field of the current record

Accepted Answer

The Answer of [End] and [Up Arrow] and [Left Arrow] is...

Question 8

To adjust the column width in a datasheet to accommodate the widest entry in a field, right-click the column separator.

Accepted Answer

A) True 
 B)False

Question 9

To review a printout of a table before printing, on the ____ tab, click Print, and then click Print Preview.

Accepted Answer

A)  FILE 
B)  VIEW 
C)  PREVIEW 
D)  REPORT 
A)  FILE 
B)  VIEW 
C)  PREVIEW 
D)  REPORT

Question 10

In a datasheet, which mode assumes that you are trying to change the value of a particular field?

Accepted Answer

A)  Edit mode 
B)  Navigation mode 
C)  Update mode 
D)  Form mode 
A)  Edit mode 
B)  Navigation mode 
C)  Update mode 
D)  Form mode

Question 11

In the accompanying figure, Customers is a ____ tab.

Accepted Answer

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

Question 12

An Access database is limited to a size of 1 gigabyte.

Accepted Answer

A) True 
 B)False

Question 13

A(n) foreign key field is always on the "one" side of a one-to-many relationship between two tables.

Accepted Answer

A) True 
 B)False

Question 14

While editing a record, pressing [Esc] a second time ____.

Accepted Answer

A)  deletes the current field 
B)  deletes the current datasheet 
C)  removes all data from the current record 
D)  removes all changes made to the record you are currently editing 
A)  deletes the current field 
B)  deletes the current datasheet 
C)  removes all data from the current record 
D)  removes all changes made to the record you are currently editing

Question 15

Which data type stores Web addresses?

Accepted Answer

A)  Lookup Wizard 
B)  Hyperlink 
C)  URL 
D)  HTML 
A)  Lookup Wizard 
B)  Hyperlink 
C)  URL 
D)  HTML

Question 16

Which Access object contains all of the raw data within the database?

Accepted Answer

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

Question 17

Which is NOT a feature of Access reports?

Accepted Answer

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

Question 18

Which data type stores only one of two values?

Accepted Answer

A)  Attachment 
B)  Hyperlink 
C)  Yes/No 
D)  Null 
A)  Attachment 
B)  Hyperlink 
C)  Yes/No 
D)  Null

Question 19

If you use ____________________ View to design your table before starting the data entry process, you will probably avoid some common data entry errors.

Accepted Answer

The answer of If you use ____________________ View to design...

Question 20

Values in an AutoNumber field are automatically created by Access.

Accepted Answer

A) True 
 B)False

Which data type links files created in other programs such as pictures or documents?

Which Access object provides an easy-to-use data entry screen?

A(n) ____________________ key field contains unique data for each record.

Which two properties are required for every field?

Which of the following is NOT a data type?

What are the advantages of using Access for database management?

To adjust the column width in a datasheet to accommodate the widest entry in a field, right-click the column separator.

To review a printout of a table before printing, on the ____ tab, click Print, and then click Print Preview.

In a datasheet, which mode assumes that you are trying to change the value of a particular field?

In the accompanying figure, Customers is a ____ tab.

An Access database is limited to a size of 1 gigabyte.

A(n) foreign key field is always on the "one" side of a one-to-many relationship between two tables.

While editing a record, pressing [Esc] a second time ____.

Which data type stores Web addresses?

Which Access object contains all of the raw data within the database?

Which is NOT a feature of Access reports?

Which data type stores only one of two values?

If you use ____________________ View to design your table before starting the data entry process, you will probably avoid some common data entry errors.

Values in an AutoNumber field are automatically created by Access.

Getting Started With Access 2013

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyzing Data With Reports

Filters

Exam 1: Getting Started With Microsoft Office 2013

Which data type links files created in other programs such as pictures or documents?

Which Access object provides an easy-to-use data entry screen?

A(n) ____________________ key field contains unique data for each record.

Which two properties are required for every field?

Which of the following is NOT a data type?

What are the advantages of using Access for database management?

To adjust the column width in a datasheet to accommodate the widest entry in a field, right-click the column separator.

To review a printout of a table before printing, on the ____ tab, click Print, and then click Print Preview.

In a datasheet, which mode assumes that you are trying to change the value of a particular field?

In the accompanying figure, Customers is a ____ tab.

An Access database is limited to a size of 1 gigabyte.

A(n) foreign key field is always on the "one" side of a one-to-many relationship between two tables.

While editing a record, pressing [Esc] a second time ____.

Which data type stores Web addresses?

Which Access object contains all of the raw data within the database?

Which is NOT a feature of Access reports?

Which data type stores only one of two values?

If you use ____________________ View to design your table before starting the data entry process, you will probably avoid some common data entry errors.

Values in an AutoNumber field are automatically created by Access.

Getting Started With Access 2013

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyzing Data With Reports

Filters