Shared Flashcard Set

Details

Microsoft Access Vocab Cards
Vocabulary Cards for Microsoft Access
20
Computer Science
8th Grade
11/07/2012

Additional Computer Science Flashcards

 


 

Cards

Term
Information Age
Definition
Present Time; is referred to because of the computer's fast retrieval and large storage capabilities
Term
Data
Definition
a single piece of information entered in a database;
Term
Microsoft Access
Definition
the database application in the software package for Microsoft Office
Term
Form
Definition
used for entering and viewing data
Term
Query
Definition
used for displaying specific data
Term
Report
Definition
used for formatting and organizing data for printing
Term
Field
Definition
defined by its name, type, size, and format; stores only one piece of data;
Term
Tips on Choosing Field Names
Definition
Short and unique; no spaces and capital letters; complete words; avoid using special characters
Term
Field Type Text
Definition
Stores letters, symbols, words, and combination of letters
Term
Field Type Number
Definition
Stores numeric values
Term
Field Type Date/ Time
Definition
Stores a date or time
Term
Field Type Currency
Definition
Stores dollar amounts
Term
Field Type Memos
Definition
Stores several lines of text
Term
Field Type AutoNumber
Definition
Automatically stores a numeric value that is one greater than that in the last record added
Term
Field Size
Definition
the number of characters or the type of number it can store; can hold up to 255 characters; size of the number field is defined by the type of value it stores
Term
Field Format
Definition
Determines how data will be displayed
Term
Numeric Field Formats
Definition
Generic; Fixed; Percent; Standard
Term
Data/ Time Field Formats
Definition
Long: Saturday, November 12, 2006;
Medium: 24 June 03
Short: 6/23/05
Term
Tables
Definition
a group of related fields
Term
Record
Definition
the data for a set of fields
Supporting users have an ad free experience!