Access 2019 Module 1-2

Access is like an electronic _____.

• typewritter

• calculator

• file cabinet

• poster maker

A _______ is used to store, maintain, and analyze data.

• word processor

• database

• spreadsheet

• presentation software

A _____ database is a collection of related bits of data that can be organized in many different ways.

• master

• table-based

• multi-faceted

• relational

All of the following are benefits of using a database over a spreadsheet, EXCEPT:

• Data entry is slower and harder using Access forms.

• • Duplicate data is minimized, and therefore Information is more accurate, reliable, and consistent.

• • Information can be viewed and sorted in many ways using Access queries, forms, and reports.

• Information is more secure using Access forms, passwords, and security features.

An ____ in Access is a table, query, form, report, macro, or module in a database.

What label goes in the box (where all the arrows point to)?

• forms

• objects

• data files

• columns

When opening a database file, you may need to click “_______” from the yellow pop-up box, if it appears.

• Enable Content

• Disable Content

• Upload File

• External Data

To close the object, right-click on the objects tab and select “_____."

• Save

• Close

• Design View

• Datasheet View

In a table, datasheet data in columns are called ____ and in _____ are called records.

• columns/rows

• columns/labels

• fields/rows

• rows/fields

A ____ is one piece of data, such as a first name.