Shared Flashcard Set

Details

Access Unit A Definitions
Access Unit A
26
Other
10th Grade
12/03/2015

Additional Other Flashcards

 


 

Cards

Term
Relational Database Software
Definition
Multiple tables that are linked together to address a business process such as managing tours, sales, and customers at Quest Specialty Travel
Term
Database
Definition
a structured set of data held in a computer, especially one that is accessible in various ways.
Term
Table
Definition
a set of facts or figures systematically displayed, especially in columns
Term
Short Text
Definition
Text or umbers not used in calculations such as a name, zip code, or phone number
Term
Long Text
Definition
Lengthy text greater than 255 characters, such as comments or notes
Term
Number
Definition
numeric data that can be used in calculations, such as quantities
Term
Currency
Definition
monetary values
Term
AutoNumber
Definition
sequential integers controlled by Access
Term
Yes/No
Definition
Only two values: yes or no
Term
OLE Object
Definition
OLE (Object Linking and Embedding) objects such as an Exel Spreadsheet or Word Document
Term
Hyperlink
Definition
web and email address
Term
Attachment
Definition
External files such as .jpg images, spreadsheets, and documents
Term
Calculated
Definition
Result of a calculation based on other fields in the data
Term
Lookup Wizard
Definition
The lookup wizard helps you set lookup properties, which display a drop-down list of values for the field; after using the lookup wizard, the final data type for the field is either Short Text or Number depending on the values in the drop-down list
Term
Date/Time
Definition
dates and times
Term
Field
Definition
a specific piece or category of data such as a first name, last name, city, state, or phone number
Term
Record
Definition
a group of related fields that describes a person, place, thing, or transaction such as a customer, location, product, or sale
Term
Key Field
Definition
a field that contains unique information for each record, such as a customer number for a customer
Term
Objects
Definition
The parts of an Access database that will help you view, edit, manage, and analyze the data
Term
Query
Definition
allows you to select a subset of fields or records from one or more tables; queries are created when you have a question about the data
Term
Form
Definition
Provides an easy-to-use data entry screen
Term
Report
Definition
Provides a professional printout of data that can contain enhancements such as headers, footers, graphics, and calculations on groups of records
Term
Design View
Definition
a view in which the structure of the object can be manipulated. Every Access object has a design view
Term
Datasheet View
Definition
a view that lists the records of the object in a datasheet. Most objects have a datasheet view.
Term
Edit Mode
Definition
The mode in which Access assumes you are trying to edit a particular field.
Term
Navigation Mode
Definition
a mode in which Access assumes that you are trying to move between the fields and records of a datasheet.
Supporting users have an ad free experience!