Term
|
Definition
| Database management system software program used to organize, story, maintain, retrieve, sort, and print all types of business data |
|
|
Term
|
Definition
| comprised of a series of objects such as tables, forms, reports, and queires that you use to enter, manage, view, and print data |
|
|
Term
|
Definition
| Organizes data in fields (columns) and rows (records). Adatabase must contain at least one table. The table is the base upon which other objects are created |
|
|
Term
|
Definition
| Used to display data from a table or related tables that meets a conditional statement and/or to perform calculations. For example, display only those records in which the city is Vancouver. |
|
|
Term
|
Definition
| Allows fields and records to be presented in a different layout than the datasheet. Used to facilitate data entry and maintenance. |
|
|
Term
|
Definition
| Prints data from tables or queries |
|
|
Term
|
Definition
| Describe a person, customer, client, object, place, idea, or event |
|
|
Term
|
Definition
| Unique and describes the contents of the field, can contain up to 64 characters. |
|
|
Term
|
Definition
| Specifies the type of data you can enter in a field, helps to mange and maintain the data. |
|
|
Term
|
Definition
| Consider the data that will be entered in the field than shorten or lengthen the number to accommodate any possible entries. |
|
|
Term
|
Definition
| Is saved automatically on a periodic basis, also when another record is made active, a table or database is closed. |
|
|
Term
| Add a new record to table |
|
Definition
| Click the New button in the Records group in home tab or Ctrl+Shift++ |
|
|
Term
|
Definition
| Used in a table to define field names and assign data types |
|
|
Term
|
Definition
| Used to enter data in fields, organizes fields into columns |
|
|
Term
|
Definition
| Store characters (letters, symbols, words, a combination of letters and numbers) |
|
|
Term
|
Definition
| Fields that store a number with a deciman portion |
|
|
Term
|
Definition
| Fields that store only whole numbers |
|
|
Term
|
Definition
| Field that automatically stores a numeric value that is one greater than that in the last record added. |
|
|
Term
|
Definition
|
|
Term
|
Definition
| The way data in a field is displayed. |
|
|
