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,datasheetE) A) and D)
F) C) and D)

Question 2

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)   databaseE) B) and D)
F) A) and C)

Question 3

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 4

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 5

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 6

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)   CopyE) A) and B)
F) A) and C)

Question 7

What is Microsoft Access used for? Provide an example.

Accepted Answer

Microsoft Access is database management ...

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

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

Accepted Answer

A)   never
B)   rarely
C)   sometimes
D)   automaticallyE) C) and D)
F) All of the above

Question 10

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

Accepted Answer

A)   fields
B)   data
C)   objects
D)   tablesE) All of the above
F) A) and B)

Question 11

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

Accepted Answer

A)   File tab
B)   Home tab
C)   Create tab
D)   Organize tabE) B) and C)
F) A) and D)

Question 12

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

Accepted Answer

A)   report
B)   form
C)   query
D)   tableE) A) and D)
F) A) and C)

Question 13

The Navigation pane displays your objects by categories and groups.

Accepted Answer

A) True 
 B)False

Question 14

What are data records displayed in?

Accepted Answer

A)   Navigation pane
B)   contextual tab
C)   datasheet
D)   Navigation menuE) B) and D)
F) A) and B)

Question 15

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

Accepted Answer

A)   selecting
B)   clicking
C)   double-clicking
D)   draggingE) C) and D)
F) None of the above

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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 19

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)   belowE) C) and D)
F) B) and C)

Question 20

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 DiagramE) B) and D)
F) A) and B)

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

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

Correct AnswerverifiedOpen Access or click the New button if A...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Which of the following is a type of software application?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedData records are stored in tables.Once a...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedAccess provides two ways to view a table...View AnswerShow Answer

The Navigation pane displays your objects by categories and groups.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

What is Microsoft Access used for? Provide an example.

Correct AnswerverifiedMicrosoft Access is database management ...View AnswerShow Answer

What are data records displayed in?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedA field is a single unit of data.Example...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Correct Answer
verified
Open Access or click the New button if A...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Data records are stored in tables.Once a...
View Answer

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

Correct Answer
verified

Correct Answer
verified
Access provides two ways to view a table...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Microsoft Access is database management ...
View Answer

Correct Answer
verified

Correct Answer
verified
A field is a single unit of data.Example...
View Answer

Correct Answer
verified

Correct Answer
verified