Chapter 1 definitions
Help!
|
|
||||
|---|---|---|---|---|---|
| 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
🗑
|
Review the information in the table. When you are ready to quiz yourself you can hide individual columns or the entire table. Then you can click on the empty cells to reveal the answer. Try to recall what will be displayed before clicking the empty cell.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
Created by:
ssassy796