Introduction to MS Access

Question 1

A powerful database software package or program that can be used to create and manage databases.

Answer 1

MS Access

Question 2

The main file that encompasses the entire database.

Answer 2

Database File

Question 3

A collection of related data about a specific topic (entity).

Answer 3

Table

Question 4

The different characteristics (attributes) within a Table

Answer 4

Fields

Question 5

The properties of each field.

Answer 5

Data Types

Question 6

A row on a datasheet and is a set of values defined by fields

Answer 6

Record

Question 7

Parts of the MS Access UI

Answer 7

MS Office Button
Quick Access Toolbar
Title Bar
Ribbon
Navigation Panel

Question 8

This is where data is stored at. It is a set of columns and rows.

Answer 8

Table

Question 9

It is used to retrieve specific data from your database.

Answer 9

Queries

Question 10

It organizes or summarizes your data so you can print it or view it onscreen.

Answer 10

Reports

Question 11

It gives you the ability to choose the format and arrangement of fields.

Answer 11

Forms

Question 12

It is used to add functionality to a form, report, or control.

Answer 12

Macros and modules