Java Games: Flashcards, matching, concentration, and word search.

Lesson 9 Advanced Tables

Match the term in Column 1 to its description in Column 2.

AB
Aggregate functionfunction that calculates values across a range of data.
Table Analyzera wizard that performs the normalization process by examining a table design and suggesting a way to divide the table for maximum efficiency.
Total rowa row inserted at the bottom of a table that provides a menu of functions for each column in the row.
row selectorsquare to the left of a field in Design view.
Insert Rows buttoninserts a blank row above a selected row in Design view.
Delete Rows buttondeletes a selected field row in Design view.
Normalizationthe process of applying rules to a database design to ensure that you have divided your information into the appropriate tables.
Countan aggregate function that counts the records in a column.
Currencya data type
Descriptionan optional part of Design view where you can enter a field description.


CTE Computer/Business Teacher
Garinger High School
Charlotte, NC

This activity was created by a Quia Web subscriber.
Learn more about Quia
Create your own activities