Database Vocabulary Slide Show Practice

Data

Groups:

(a) Data

,

(b) Database

,

(c) Database Management System (DBMS)

,

(d) Access

• Information entered into a database that

  consists of text, numbers, sounds, and

  images.

• The name of Microsoft's DBMS.

• Software used to create a database and

  analyze the data it stores.

• A stored collection of data that can be

  easily organized and retrieved.

Table:

A set of​ (a)   (rows) and ​ (b)   (columns) used to ​ (c)   and organize ​ (d)   in a database.

• records
• fields
• store
• data

Match the correct information for "Record" and "Field"

Groups:

(a) Record

,

(b) Field

• Row of a Table

• A category of data in a table that describes

  a specific characteristic of a

  record.

• (EX: Customer Name, License

  Plate #, etc.)

• A complete set of data fields for a specific

  object, person, or event in a database.

• Column of a Table

Label the diagram.

a

b

Records

Fields

Click on the Field that is the Primary Key, which is the field that uniquely identifies each record.

Match the correct information with the different type of Table Views.

Groups:

(a) Datasheet View

,

(b) Design View

• 
• 
• The view of a table that lets you add,

  delete, and rearrange fields.

• 
• The "normal" view of a table that displays

  data as Fields and Records

• 

Match each definition with the term.

Groups:

(a) Form

,

(b) Query

,

(c) Report

• A search or question to retrieve specific

  information (or data) from a database.

• A formatted, presentable way to look at

  data retrieved from a query.

• A user-friendly way to enter, view, and

  edit data into a table.