Term
click below
click below
Term
Normal Size Small Size show me how
Access
Chapter 1 definitions
Term | Definition |
---|---|
Common Field | A field in one or more tables that stores the same data. |
Data | Facts about people, events, things, or ideas. |
Database | An organized collection of facts about people, events, things, or ideas related to a specific topic.; an organized collection of data |
Field | A single piece of information that is stored in every record and represented by a column in a table. |
First Principle of Good Database Design | eliminate redundant data; A principle stating that data is organized in tables so that there is no redundant data. |
Flat Database | A simple data base file that is not related or linked to any other collection of data. |
Information | Data that is organized in a useful manner. |
Navigation Pane | The window area that organizes the data base objects and from which you open objects. |
Normalization | The process of applying design rules and principles to ensure that a data base performs as expected. |
Object Window | The window area that displays each open object on its own tab. |
Objects | The basic parts of a database; for example tables, queries, forms, and reports. |
Populate | The action of filling a data base with records. |
Record | A table row that contains all of the categories of data pertaining to one person, place, thing, event, or idea. |
Second Principle of Good Database Design | Employ techniques to ensure accuracy; A principle stating that techniques are used to ensure the accuracy of data entered into a table. |
Table | The database object that stores the data and is the foundation of an access database. |
File | A collection of information stored under a single name. |
Folder | A container where files can be stored. |
Window | A rectangular area on the computer screen. |
Desktop | Opening screen in Windows that simulates a work area. |
Footer | Displays at the bottom of each page of the document. |
Header | Displays at the top of each page of the document |
Zoom | Increase or decrease the viewing area |
Portrait Orientation | Paper is taller than it is wide. |
Landscape Orientation | Paper is wider than it is tall. |
File Tab | Displays Backstage view |
Group | Related commands on the ribbon. |
Window Control Buttons | Minimize, Restore Down, Close |
Quick Access Toolbar | Buttons to perform frequently used commands |
Ribbon | Task-oriented tabs |
Fill | the inside color of an object |
Option Button | Allows the user to make one choice from two or more options. |
Gallery | Office feature that displays a list of potential results. |
Screen Tip | Displays useful information about mouse actions. |
Gradient fill | one color fades into another. |
Point | 1/72 of an inch |
Font styles | Bold, italic, underline |
toggle button | turns a feature on and off |
format painter | allows for the copying of the formatting of a selected text |
clipboard | temporary storage area that holds items that have been cut or copied |
command | an instruction to a computer program |
scroll bar | displays in a window that has information not visable |
point | move the mouse pointer over something |
click | press the left mouse button |
scroll box | the box within a scroll bar |
pt. | abbreviation for point when referring to font size |
font | set of characters with the same design and shape |
sans serif font | a font design with no lines or extensions on the ends of characters |
serif font | a font design that includes lines or extensions on the ends of characters |
theme | pre-designed set of colors, fonts, lines, and fills |
Query | used to ask a question |
select query | used to create subsets of data that you can use to answer specified questions |
data source | table or tables from which you select fields for a query |
run | finds and displays the records that match criteria in a query |
wizard | walks you step by step through a process |
relational database | multiple collections of data are related to one another |
DBMS | microsoft access, for example |
database template | a pre-formated database designed for specific purposes |
Form View | a way to view the records in a form, but not change the form's layout or design |
Layout view | a way to make changes to a form or to a report while seeing the data |
design view | a way to view a table's structure |
datasheet view | a way to view all the records in a table |