Deck 1: Introduction to Access: Hands-On-Exercise Videos

Question 1

A table can only be sorted on a single field.

Answer 1

False

Question 2

Why would you enforce referential integrity?

A) To avoid accidental deletion of macros
B) So data cannot be entered into a related table until the data is entered in the primary table
C) To confirm error free data
D) To determine which software to use Excel or Access

Answer 2

B

Question 3

You can use Access to create a Web app for sharing data with others through the Internet.

Answer 3

True

Question 4

Which one of the following objects allows users to add data to the database?

A) Table
B) Record
C) Query
D) Form

Question 5

The purpose of a database is to:

A) manage, store, sort, and query information.
B) help provide access to the internet.
C) compose e-mail messages.
D) create presentations.

Question 6

How does the Getting Started page help learn about a database?

A) The Getting Started page links you to introductory Access videos.
B) The Getting Started page details how to install software.
C) The Getting Stated page explains what to do if your system crashes.
D) The Getting Stated page shows how to create relationships between tables.

Question 7

Which of the following is NOT an Access comparison operator?

A) <
B) ≠
C) >=
D) =

Question 8

A ________ key is the field in the related table that you would use to connect to the primary key in another table.

A) secondary
B) foreign
C) composite
D) merged

Question 9

Clicking Undo will restore a deleted record.

Question 10

Where are the changes to an Access table saved as soon as you move the insertion point?

A) To memory
B) To a storage location
C) To the cloud
D) To the desktop

Question 11

The Filter by Selection returns:

A) only records matching the set criteria.
B) results filtered from a selected range.
C) specific query results.
D) any data with a comparison operator.

Question 12

You can use the Compact and Repair utility to help improve the performance of a database.

Question 13

Enforcing referential integrity ensures that no data are duplicated.

Question 14

Which of the following is NOT a method for creating a new database?

A) A blank desktop database
B) A database from a style
C) A custom Web app
D) A database from a template

Question 15

What is a relationship?

A) Two Excel spreadsheets with similar data
B) A database and a spreadsheet with similar data
C) Similar queries applied to the same table
D) A connection between two tables with a common field

Question 16

Creating a desktop database using a theme saves creation time.

Question 17

When performing a filter by selection,equals and contains produce the same result.

Question 18

Why is there a need to filter records?

A) Filters scan for viruses.
B) Filters hide records that do match the criteria.
C) Filters speed up the CPU.
D) Filters reduce the file size.

Question 19

In the Relationships window,join lines indicate the relationships between tables.

Question 20

What is an advantage of using Filter by Form?

A) There is no minimum number of records that can be filtered.
B) You can use the AND and OR operators.
C) The records are also sorted.
D) Access automatically saves the results to storage.