Access - Ch 1

Question 1

Collection of data organized as meaningful info that can be accessed, managed, stored, queried, sorted, reported

Answer 1

Database

Question 2

A software system that provides the tools needed to create, maintain, and use a database

Answer 2

Database Management System (DBSM)

Question 3

DBSM of Office

Answer 3

Access

Question 4

Components created & used to make a database; Tables, Queries, Forms, Reports

Answer 4

Object

Question 5

Where all data is stored

Answer 5

Table

Question 6

Column of Table

Answer 6

Field

Question 7

Row of Table

Answer 7

Record

Question 8

Field that uniquely identifies each record on a table

Answer 8

Primary Key

Question 9

A question you ask about data in your database

Answer 9

Query

Question 10

Allows simplified entry & modification of data

Answer 10

Form

Question 11

Contains professional-looking formatted info from underlying tables & queries

Answer 11

Report

Question 12

Defines the characteristics of a field in more detail

Answer 12

Field Property

Question 13

Connection between 2 tables by using a common field

Answer 13

Relationship

Question 14

Utility that creates a duplicate copy of the database

Answer 14

Back Up Database

Question 15

Reduces size of a database & fixes errors

Answer 15

Compact and Repair Database

Question 16

Allows you to specify conditions to display only these records that meet those conditions

Answer 16

Filter

Question 17

Lists records in specific sequence

Answer 17

Sort

Question 18

Predefined database that can include predesigned tables, forms, reports

Answer 18

Template

Question 19

Enables you to add a set of common Access components to an existing database

Answer 19

Application chart