Exam 11: Introduction to Access: Finding Your Way Through an Access Database

arrow
  • Select Tags
search iconSearch Question
flashcardsStudy Flashcards
  • Select Tags

SharePoint is an add-on program for Access.

(True/False)
4.8/5
(32)

Custom Web app is available in the Backstage view of Access.

(True/False)
4.9/5
(36)

What is one limit to two users working on the same database file at the same time?

(Essay)
4.8/5
(35)

Access is preferred over Excel in managing mostly numeric data.

(True/False)
4.9/5
(38)

When you ________,you ensure that data entered into a related table first exists in the primary table.

(Multiple Choice)
4.9/5
(33)

A complete set of all fields about one person or event is called a field.

(True/False)
4.8/5
(28)
Match the following keys to their functions:
Tab
moves insertion point right one field in the same row of a database
F2
switch to Edit mode
Esc
moves insertion point to the first field in the current row of a database
Correct Answer:
Verified
Premises:
Responses:
Tab
moves insertion point right one field in the same row of a database
F2
switch to Edit mode
Esc
moves insertion point to the first field in the current row of a database
Home
cancels any change made in a current field while in Edit mode
F11
toggles the Navigation Pane on and off
(Matching)
4.7/5
(37)

In relational databases,there is a concept known as ________ that ensures that data cannot be entered into a related table unless it first exists in a primary table.

(Short Answer)
4.7/5
(35)

The process of saving in Access is nearly the same as it is in other Microsoft Office applications.

(True/False)
5.0/5
(32)

Use ________ if you have mostly numeric data and may require complex charts and graphs.

(Short Answer)
4.9/5
(37)

A(n)________ is a collection of fields that describe something,such as a person,place,event,or idea.

(Short Answer)
4.9/5
(30)

Which of the following is NOT a main object type in an Access database?

(Multiple Choice)
4.9/5
(34)

When forming relationships in a relational database,the ________ from one table must be joined to the foreign key of another table.

(Short Answer)
4.7/5
(40)

People use databases to store collections of data.

(True/False)
4.9/5
(31)

The ________ utility of Access helps reduce the size of a database.

(Short Answer)
4.8/5
(30)

A(n)________ system is a software system that offers tools needed to create,maintain,and use a database.

(Short Answer)
4.8/5
(38)

The ________ Database utility in Access creates a duplicate copy of a database.

(Short Answer)
4.8/5
(33)

________ a database rearranges data and objects in a database to make its size smaller.

(Multiple Choice)
4.8/5
(34)

Offer three examples of interactions that you may have had with databases (knowingly or unknowingly)within the last week.

(Essay)
4.8/5
(39)

Which of the following is a collection of data organized into meaningful information to be used in a meaningful way?

(Multiple Choice)
4.9/5
(32)
Showing 61 - 80 of 100
close modal

Filters

  • Essay(0)
  • Multiple Choice(0)
  • Short Answer(0)
  • True False(0)
  • Matching(0)