Databases

Microsoft's version of a Database Management System

• Excel
• Access
• Word
• PowerPoint

Tables are set up to contain columns and rows of information. In a database table, the columns are called __________.

• Cell
• Field
• Column
• Record

In a database table, rows are called __________

• Fields

• Records

• Primary Keys

• Foreign Keys

Forms, queries, and reports are created based on the data in the _________

• Forms

• Tables

• Reports

• Spreadsheets

To sort from the smallest to the largest (from A to Z and 0 to 9)

• Ascending
• Descending
• Auto Sort
• Advanced Sort/Filter

What is sort order arranging text or numbers from Z to A, from largest to smallest, or from latest to earliest

• Ascending

• Descending

• Sort

• Part

_____________ is to arrange information in ascending or descending order

• Sort

• Arrange

• Separate

• Database

What is a document that uses data from tables and/or queries; the user controls which items in the database will appear in the report and how it is filtered or sorted

• Report

• Form

• Query

• Table

What is a question presented in a way that allows the database to process and generate specific data from one or more tables

• Form

• Report

• Query

• Table

What is a database view that allows the user to see all fields for one record and enter them one at a time

• Form

• Report

• Query

• Table