Frst 232 Final

Field in a database which cannot be divided into parts with more that one kind of data in it such that what one part means to the DBMS depends on another part of the same field

A macro is a sequence of instructions.

It can be a single cell, or a block of cells.Top Left reference : Bottom Right reference

A database field whose value is calculated based on values of other fields using a specific formula

Extensible Markup Language is a set of rules for encoding documents in machine-readable form. It emphasizes simplicity and usability and is a textual data format with strong support from Unicode for the languages of the world.

A Relation

A set that represents a combination of two or more other sets.

When all foreign keys refer to an existing record. It is an option that is invoked after a data base is initially set up.

A Local Variable is one declared within the body of a function or a block

SQL is a language standard for systems that organize, manage and retrieve data stored by a computer. Some example commands are Select, Insert, Delete, Update

A Geographic Information System is designed to capture, store, manipulate, analyze, manage and display all types of geographically referenced data.

Useability, accuracy, precision, cost, learning curve

A UDT is a named data type that is created in a database by the user. Examples: As Single, As Integer, As Long

A set of named values represent integral constants. Values are assigned to non-numbered data. Example: Enum CardSuit
Clubs
Diamonds
Hearts
Spades
End Enum

Sub EnumExample()
Dim suit As CardSuit
suit = Diamonds
MsgBox suit
End Sub

A global variable is a variable declared in the main body of the source code, outside all functions.