Question 1

To delete a record from a table,first click in the _______________ of the _____________.

Accepted Answer

A)  Record Selector cell,record 
B)  Append Row,datasheet 
C)  first field,record 
D)  first row,datasheet 
A)  Record Selector cell,record 
B)  Append Row,datasheet 
C)  first field,record 
D)  first row,datasheet

Question 2

Which of the following is not located on the Access Ribbon?

Accepted Answer

A)  File tab 
B)  Home tab 
C)  Create tab 
D)  Organize tab 
A)  File tab 
B)  Home tab 
C)  Create tab 
D)  Organize tab

Question 3

Access provides two ways to view a table.Describe each view,how to open a table in each view,and how to switch between views.

Accepted Answer

Access provides two ways to view a table

Question 4

To add a new field between existing fields,put your pointer on the field name of the column _____________ where you wish to insert a new field.

Accepted Answer

A)  to the left of 
B)  to the right of 
C)  above 
D)  below 
A)  to the left of 
B)  to the right of 
C)  above 
D)  below

Question 5

Which of the following is used to find data in a database?

Accepted Answer

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

Question 6

In Access,what are the different components of a database application called?

Accepted Answer

A)  fields 
B)  data 
C)  objects 
D)  tables 
A)  fields 
B)  data 
C)  objects 
D)  tables

Question 7

What are data records displayed in?

Accepted Answer

A)  Navigation pane 
B)  contextual tab 
C)  datasheet 
D)  Navigation menu 
A)  Navigation pane 
B)  contextual tab 
C)  datasheet 
D)  Navigation menu

Question 8

Define field,record,table,and database.Provide an example of how each of these might relate to a database that a university might use.

Accepted Answer

A field is a single unit of data.Example

Question 9

When you first create an object,Access assigns a generic name,such as Table1 or Form1.

Accepted Answer

A) True 
 B)False

Question 10

Share everything you know at this point about the four major objects in Access,namely tables,forms,queries,and reports.

Accepted Answer

Data records are stored in tables.Once a

Question 11

The Navigation pane displays your objects by categories and groups.

Accepted Answer

A) True 
 B)False

Question 12

It is possible to change row height by ____________ the border of a row.

Accepted Answer

A)  selecting 
B)  clicking 
C)  double-clicking 
D)  dragging 
A)  selecting 
B)  clicking 
C)  double-clicking 
D)  dragging

Question 13

In a database,which of the following enables you to connect two tables to each other?

Accepted Answer

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

Question 14

Which of the following is a type of software application?

Accepted Answer

A)  hierarchy of data 
B)  database 
C)  database management system 
D)  Entity-Relationship Diagram 
A)  hierarchy of data 
B)  database 
C)  database management system 
D)  Entity-Relationship Diagram

Question 15

Each field in your database must be assigned a specific data type.

Accepted Answer

A) True 
 B)False

Question 16

You can sort a datasheet by one field,or a set of adjacent fields,in ascending or descending order.

Accepted Answer

A) True 
 B)False

Question 17

What are the general steps for creating and using a table in datasheet view?

Accepted Answer

Open Access or click the New button if A

Question 18

Access ____________ determines a data type for the field based on the contents that you enter.

Accepted Answer

A)  never 
B)  rarely 
C)  sometimes 
D)  automatically 
A)  never 
B)  rarely 
C)  sometimes 
D)  automatically

Question 19

Which of the following tabs must you use to create a backup copy of a database?

Accepted Answer

A)  Home 
B)  File 
C)  Backup 
D)  Copy 
A)  Home 
B)  File 
C)  Backup 
D)  Copy

Question 20

What is Microsoft Access used for? Provide an example.

Accepted Answer

Microsoft Access is database management

To delete a record from a table,first click in the ___ of the _.

Which of the following is not located on the Access Ribbon?

Access provides two ways to view a table.Describe each view,how to open a table in each view,and how to switch between views.

To add a new field between existing fields,put your pointer on the field name of the column _____________ where you wish to insert a new field.

Which of the following is used to find data in a database?

In Access,what are the different components of a database application called?

What are data records displayed in?

Define field,record,table,and database.Provide an example of how each of these might relate to a database that a university might use.

When you first create an object,Access assigns a generic name,such as Table1 or Form1.

Share everything you know at this point about the four major objects in Access,namely tables,forms,queries,and reports.

The Navigation pane displays your objects by categories and groups.

It is possible to change row height by ____________ the border of a row.

In a database,which of the following enables you to connect two tables to each other?

Which of the following is a type of software application?

Each field in your database must be assigned a specific data type.

You can sort a datasheet by one field,or a set of adjacent fields,in ascending or descending order.

What are the general steps for creating and using a table in datasheet view?

Access ____________ determines a data type for the field based on the contents that you enter.

Which of the following tabs must you use to create a backup copy of a database?

What is Microsoft Access used for? Provide an example.

Creating a Database and Tables

Using Design View, Data Validation, and Relationships

Creating and Using Queries

Creating and Using Forms and Reports

Templates, Advanced Relationships, and Macros

Creating Advanced Queries and Reports and Using SQL

Creating Advanced Forms

Integrating Applications

Designing and Managing Databases

Filters

Exam 10: Customizing Access and Using Skydrive and Office Web Apps

To delete a record from a table,first click in the _______________ of the _____________.

Which of the following is not located on the Access Ribbon?

Access provides two ways to view a table.Describe each view,how to open a table in each view,and how to switch between views.

To add a new field between existing fields,put your pointer on the field name of the column _____________ where you wish to insert a new field.

Which of the following is used to find data in a database?

In Access,what are the different components of a database application called?

What are data records displayed in?

Define field,record,table,and database.Provide an example of how each of these might relate to a database that a university might use.

When you first create an object,Access assigns a generic name,such as Table1 or Form1.

Share everything you know at this point about the four major objects in Access,namely tables,forms,queries,and reports.

The Navigation pane displays your objects by categories and groups.

It is possible to change row height by ____________ the border of a row.

In a database,which of the following enables you to connect two tables to each other?

Which of the following is a type of software application?

Each field in your database must be assigned a specific data type.

You can sort a datasheet by one field,or a set of adjacent fields,in ascending or descending order.

What are the general steps for creating and using a table in datasheet view?

Access ____________ determines a data type for the field based on the contents that you enter.

Which of the following tabs must you use to create a backup copy of a database?

What is Microsoft Access used for? Provide an example.

Creating a Database and Tables

Using Design View, Data Validation, and Relationships

Creating and Using Queries

Creating and Using Forms and Reports

Templates, Advanced Relationships, and Macros

Creating Advanced Queries and Reports and Using SQL

Creating Advanced Forms

Integrating Applications

Designing and Managing Databases

Filters

To delete a record from a table,first click in the ___ of the _.