Level 47 Level 49
Level 48

Creating & Using a Database


43 words 0 ignored

Ready to learn       Ready to review

Ignore words

Check the boxes below to ignore/unignore words, then click save at the bottom. Ignored words will never appear in any learning session.

All None

Ignore?
Records
Horizontal row in table, representing a data item. Also called tuple.
Field
A column in a table.
Unique identifier
These numbers are unique; that is, no two clients are assigned the same number.
primary key
A field that uniquely identifies each record in a file.
Data type
Describes type of attribute. Data types are decided by the software or DBMS.
Text
Online database that provides access to full text of indexed articles from one or mre journals- but does not includes drawings, graohics, and pictures.
number
an idea that is designated by a numeral
Currency
Money
Access work area
You work on objects such as tables, forms, and reports in the Access work area.
Object tabs
Object tabs for the open objects appear at the top of the work area.
insertion point
a vertical blinking bar on the computer screen that indicates where text will be inserted.
Mouse pointer
Becomes different shapes depending on the task you are performing in Access and the pointer's location on the screen.
Scroll bar
Display different portions of a database object in the Access window.
Status bar
Located at the bottom of the Access window above the Windows Vista taskbar, presents information about the database object, the progress of current tasks, and the status of certain commands and keys; it also provides controls for
Ribbon
Located near the top of the Access window, is the control center in Access.
home tab
a ribbon tab that provides access to frequently used commands
contextual tabs
In addition to the top-level tabs, Access displays other tabs, called contextual tabs, when you perform certain tasks or work with objects such as datasheets.
Enhanced ScreenTip
is an on-screen note that provides the name of the command, available keyboard shortcut(s), a description of the command, and sometimes instructions for how to obtain help about the command.
Dialog Box Launcher
The lower-right corner of some groups on the Ribbon has a small arrow, called a Dialog Box Launcher, which, when clicked, displays a dialog box or a task pane with additional options for the group.
Task pane
Is a window that can remain open and visible while you work in the database object.
Mini toolbar
which appears automatically based on tasks you perform, contains commands related to changing the appearance of text in a database object.
Shortcut menu
Which appears when you right-click an object, is a list of frequently used commands that relate to the right-clicked object.
Quick Access Toolbar
Located by default above the Ribbon, provides easy
Office Button
is a central location for managing and sharing database objects.
Menu
A dropdown list or table that contains exacutable options
Submenu
A __________ is an additional set of commands that the computer displays after you make a selection from the main menu.
Key Tip badge
you can press the ALT key on the keyboard to display a Key Tip badge, or keyboard code icon, for certain commands
Key Tip
To select a command using the keyboard, press its displayed code letter, or Key Tip.
Row selector
The small box or bar that, when you click it, selects the entire row, indicates the fi eld you currently are describing.
Datasheet View
a display of the data in a table of rows and columns, like a spreadsheet, where each record is on one row. There are often too many fields to see all of them at once.
Datasheet.
A collection of rows and columns.
AutoCorrect
Afeature of Access works behind the scenes, correcting common mistakes when you complete a text entry in a cell.
Navigation buttons
Which are buttons used to move within a table, found near the lower-left corner of the screen when a table is open.
Portrait orientation
Means the printout is across the width of the page.
Landscape orientation
Means the printout is across the length (height) of the page.
Split form
Combines both a datasheet and a form, thus giving the advantages of both views. The following
Form View
a display of the fields in a record that makes it easy to enter new data or to edit existing data or to choose actions.
database properties
which are the details about a file.
metadata
Database properties, can include such information as the project author, title, or subject.
Keywords
Are words or phrases that further describe the database.
Standard properties
Are associated with all Microsoft Offi ce documents and include author, title, and subject.
Automatically updated properties
Include fi le system properties, such as the date you create or change a fi le, and statistics, such as the fi le size.
Access Help
At any time while using Access, you can fi nd answers to questions and display information about various topics through Access Help.