This site is 100% ad supported. Please add an exception to adblock for this site.

Microsoft Office Lesson 11

Terms

undefined, object
copy deck
Field
One item of data, such as an employee's ID number, last name, or title.
Form
An Access window that contains all of the information about a specific record, and which is used for data entry or editing.
Relationship
A connection between data among different database objects.
Primary Key
A distinct field in a database that is used to make sure that each record is unique
Table
Information organized in horizontal rows and vertical columns.
Instance
A row of data that contains all of the information about one record.
Field Properties
The attributes and appearance of tables and data, such as setting a character limit or determining a default value.
Navigation Pane
An Access window that can be organized by object type, category, date, and other views.
Input mask
Text that provides clues to the data to be inserted, such as YYYY-MM-DD to indicate that the date November 4, 2010 should be entered as 2010-11-04
Module
A task related to a database object; similar to a module but uses Visual Basic for Applications (VBA), a program language.
Record
The complete information on one entity in the database, such as an employee.
Macro
A task related to a database object, such as adding a command button, created without using programming language.
Database Management System
A system or program, such as Microsoft Access, that organizes information like a filing cabinet, so that it can be entered, searched, and analyzed
Data type
A specification that determines the data that can be entered in a field.
Database
A program, such as Microsoft Access, that organizes information in records.
Attribute
A column of data that contains related data in a database, such as employees' last names.
Wizard
A series of dialog boxes that ask questions and verifies information needed to correctly complete a task.
Report
A database object that displays the contents of a table or of the results of a query in a readable and organized format.
Property Sheet
A window in Access Design view that allows you to set the field properties of a table in a database.
Query
To retrieve information based on search criteria.

Deck Info

20

permalink