Database Vocabulary Slide Show Practice

Data

Groups:

(a) Data

,

(b) Database

,

(c) Database Management System (DBMS)

,

(d) Access

• A stored collection of data that can be

  easily organized and retrieved.

• Software used to create a database and

  analyze the data it stores.

• The name of Microsoft's DBMS.

• Information entered into a database that

  consists of text, numbers, sounds, and

  images.

Tags

CCSS.RI.9-10.4

CCSS.RI.9-10.4

CCSS.RI.6.4

CCSS.RI.7.4

CCSS.RI.8.4

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

• (EX: Customer Name, License

  Plate #, etc.)

• Column of a Table

• A category of data in a table that describes

  a specific characteristic of a

  record.

• Row of a Table

• A complete set of data fields for a specific

  object, person, or event in a database.

Label the diagram.

a

b

Fields

Records

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 "normal" view of a table that displays

  data as Fields and Records

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

  delete, and rearrange fields.

• 
• 

Match each definition with the term.

Groups:

(a) Form

,

(b) Query

,

(c) Report

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

  edit data into a table.

• 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.