Question 1

The view that shows how fields are defined is the ________ view.

Accepted Answer

design

Question 2

A query creates a run time table called a recordset.

Accepted Answer

A) True 
 B)False  True

Question 3

When working with objects in your Access database,you many need to use the ________ to find objects.

Accepted Answer

A)  Search bar 
B)  Query wizard 
C)  Query box 
D)  Search wizard 
A)  Search bar 
B)  Query wizard 
C)  Query box 
D)  Search wizard A

Question 4

A sample database is empty,while a template database has presupplied example data.

Accepted Answer

A) True 
 B)False

Question 5

The table view that shows the data contents within a table is called the ________ view.

Accepted Answer

A)  design 
B)  datasheet 
C)  data 
D)  table 
A)  design 
B)  datasheet 
C)  data 
D)  table

Question 6

A ________ is a database that is presupplied with data.

Accepted Answer

A)  beginner database 
B)  template database 
C)  sample database 
D)  starter database 
A)  beginner database 
B)  template database 
C)  sample database 
D)  starter database

Question 7

The file name suffix that helps Windows determine which program should open a file is called a(n)________.

Accepted Answer

A)  file extension 
B)  data expansion 
C)  object extension 
D)  file expansion 
A)  file extension 
B)  data expansion 
C)  object extension 
D)  file expansion

Question 8

To put records within a group into a specific order based on the values of a specific field,you ________ them.

Accepted Answer

A)  join 
B)  group 
C)  sort 
D)  arrange 
A)  join 
B)  group 
C)  sort 
D)  arrange

Question 9

A database and a database management system are not the same thing.A database is a collection of data,while a database management system is a software program that manages the data.

Accepted Answer

A) True 
 B)False

Question 10

A(n)________ can be based on the data in a table or query.

Accepted Answer

The answer of A(n)________ can be based on the data...

Question 11

The view that shows the data contents within a table is the ________ view.

Accepted Answer

The answer of The view that shows the data contents...

Question 12

While it is possible to import data from an Excel file,it is NOT possible to import data from a Word file.

Accepted Answer

A) True 
 B)False

Question 13

Access is a(n)________ DBMS (database management system).

Accepted Answer

The answer of Access is a(n)________ DBMS (database management system)....

Question 14

When you name a table in Access,you should use a long name that specifically identifies the data in the table.

Accepted Answer

A) True 
 B)False

Question 15

The file extension for Access files is ________.

Accepted Answer

A)  .acc 
B)  .accdb 
C)  .adb 
D)  .acdb 
A)  .acc 
B)  .accdb 
C)  .adb 
D)  .acdb

Question 16

One of the limitations of the Access database management system is that it can NOT calculate information such as total sales or baseball scores.

Accepted Answer

A) True 
 B)False

Question 17

Since Access does not reuse space when you delete a record,you need to occasionally ________ the database to make more efficient use of space.

Accepted Answer

A)  compact 
B)  group 
C)  repair 
D)  sort 
A)  compact 
B)  group 
C)  repair 
D)  sort

Question 18

An interface often used by end users of a database to enter and change data is called a(n)________.

Accepted Answer

A)  object 
B)  table 
C)  template 
D)  form 
A)  object 
B)  table 
C)  template 
D)  form

Question 19

To answer questions about data in your tables,you use ________.

Accepted Answer

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

Question 20

The structure of a database which includes tables,fields,forms,queries,and reports but has no data is a ________.

Accepted Answer

A)  beginner database 
B)  sample database 
C)  starter database 
D)  template database 
A)  beginner database 
B)  sample database 
C)  starter database 
D)  template database

Exam 5: Microsoft Access 2010,workshop 1: Understanding the Four Main Database Objects

The view that shows how fields are defined is the ________ view.

A query creates a run time table called a recordset.

When working with objects in your Access database,you many need to use the ________ to find objects.

A sample database is empty,while a template database has presupplied example data.

The table view that shows the data contents within a table is called the ________ view.

A ________ is a database that is presupplied with data.

The file name suffix that helps Windows determine which program should open a file is called a(n)________.

To put records within a group into a specific order based on the values of a specific field,you ________ them.

A database and a database management system are not the same thing.A database is a collection of data,while a database management system is a software program that manages the data.

A(n)________ can be based on the data in a table or query.

The view that shows the data contents within a table is the ________ view.

While it is possible to import data from an Excel file,it is NOT possible to import data from a Word file.

Access is a(n)________ DBMS (database management system).

When you name a table in Access,you should use a long name that specifically identifies the data in the table.

The file extension for Access files is ________.

One of the limitations of the Access database management system is that it can NOT calculate information such as total sales or baseball scores.

Since Access does not reuse space when you delete a record,you need to occasionally ________ the database to make more efficient use of space.

An interface often used by end users of a database to enter and change data is called a(n)________.

To answer questions about data in your tables,you use ________.

The structure of a database which includes tables,fields,forms,queries,and reports but has no data is a ________.

Integrated Projects, workshop 1: Integrating Word and Excel

Integrated Projects, workshop 2: Integrating Word, excel, and Access

Integrated Projects, workshop 3: Integrating Word, excel, access, and Powerpoint

Integrated Projects, workshop 4: Integrating Word, powerpoint, access, excel, and Outlook

Microsoft Access 2010,workshop 2: Gathering Data Into a Database

Microsoft Access 2010,workshop 3: Accessing Information From an Access Database

Microsoft Access 2010,workshop 4: Maintaining and Presenting Data

Microsoft Excel 2010,workshop 1: Understanding and Manipulating Microsoft Excel 2010

Microsoft Excel 2010, workshop 2: Formatting, formulas, and Functions

Microsoft Excel 2010,workshop 3: Conducting Excel Analysis Through Functions and Charts

Microsoft Excel 2010,workshop 4: Using Charts

Microsoft Office Outlook 2010, workshop 1: Communicating With E-Mail, and Managing Contacts, calendars, and Tasks

Microsoft Powerpoint 2010 workshop 1: Communicating With Presentations

Microsoft Powerpoint 2010,workshop 2: Applying and Modifying Text and Graphics

Microsoft Powerpoint 2010,workshop 3: Applying and Modifying Multimedia

Microsoft Powerpoint 2010, workshop 4: Customizing, Collaborating, and Presenting

Microsoft Word 2010,workshop 1: Reviewing and Modifying a Document

Microsoft Word 2010,workshop 2: Creating and Editing a Document

Microsoft Word 2010,workshop 3: Including Tables and Objects

Microsoft Word 2010,workshop 4: Formatting Special Documents and Using Mail Merge

Appendix: Microsoft Windows 8: Understanding the Windows 8 Interface

Common Features,workshop 1: Understanding the Common Features of Microsoft Office

Windows 7, workshop 1: Understanding the Windows 7 Desktop and Managing Windows

Filters