Shared Flashcard Set

Details

BIM Access Vocab
n/a
44
Business
9th Grade
01/20/2015

Additional Business Flashcards

 


 

Cards

Term
Database
Definition
descibes a collection of data organized in a manner that allows access, retrieval, and use of that data
Term
Record
Definition
the rows in the tables; contains information about a given person, product, or event
Term
Field
Definition
the columns in the tables; contains a specific piece of information within a record
Term
Unique Identifier
Definition
a given client number will appear only in a single record in the table
Term
Primary key
Definition
another name for unique identifier
Term
List all the datatypes for fields
Definition
text, memo, number, date/time, currency, autonumber, yes/no, lookup wizard
Term
Insertion tab
Definition
a blinking vertical bar that indicates where text, graphics, and other items will be inserted
Term
Scroll bar
Definition
you use this to display different portions of a database object in the Access window
Term
Status bar
Definition
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; also provides controls for viewing the object
Term
Ribbon
Definition
located near the top of the Access window; the control center in Access
Term
Home tab
Definition
contains more frequently used tabs
Term
Mini toolbar
Definition
appears automatically based on the tasks you perform; contains commands related to changing the appearance of text in a database object
Term
Shortcut menu
Definition
appears when you right click an object; of frequently used commands that relate to the right-clicked object
Term
Quick Access Toolbar
Definition
located by default above the Ribbon, provides easy access to frequently used commands
Term
Menu
Definition
contains a list of commands
Term
Office Button
Definition
a central location for managing and sharing database objects
Term
Submenu
Definition
a list of additional commands associated with the selected command
Term
Key tip Bridge
Definition
keyboard code icon to use keyboard instead of mouse
Term
Row selector
Definition
the small bow or bar that, when you click it, selects the entire row, indicates the field you are currently describing
Term
AutoCorrect feature
Definition
works behind the scenes correcting common mistakes when you complete a text entry in a cell
Term
Navigation Buttons
Definition
buttons used to move without a table, found near the lower-left corner of the screen when a table is open
Term
Portrait Orientation
Definition
means the printout is the across the width of the page
Term
Form view
Definition
where data is displayed in a form on the screen; you usually can see all the fields, but only for one record
Term
Database Properties
Definition
the details about a file
Term
Keywords
Definition
words or phrases that further describe the database
Term
Standard properties
Definition
are associated with all Microsoft Office documents and include author, title, and subject
Term
Access Help
Definition
where you can find the answers to questions and display information about various topics
Term
Query
Definition
a question presented in a way that Access can process
Term
Criterion
Definition
a condition that the records to be included must statisfy
Term
Wildcards
Definition
symbols that represent any character or combination of characters
Term
Parameter query
Definition
a query that prompts for input whenever it is used
Term
Comparison operators
Definition
the criteria that must be entered to not get the exact match
Term
Compound Criterion
Definition
more that one criterion that the data for which you are searching must satisfy
Term
AND Criterion
Definition
each individual criterion must be true in order for the compound criterion to be true
Term
OR Criterion
Definition
is true to provide either individual criterion is true
Term
Sort Key
Definition
the field or fields on which the records are sorted
Term
Major Key
Definition
the most important field
Term
Minor Key
Definition
the less important field
Term
Property Sheet
Definition
a window containing the various properties of the object
Term
Top-Values Query
Definition
allows you to quantify the results
Term
Join Properties
Definition
the properties that indicate which records appear in a join, of a query
Term
Calculated Field
Definition
a field can be computed from other fields
Term
Aggrigated Function
Definition
a function that performs some mathematical function against a group of records
Term
Grouping
Definition
creating groups of records that share some common characteristics
Supporting users have an ad free experience!