Shared Flashcard Set

Details

Access Unit A
Getting started with Access 2007
61
Computer Networking
Undergraduate 1
12/21/2010

Additional Computer Networking Flashcards

 


 

Cards

Term
Relational Database Software
Definition
Manages data that is organizzed into lists, such as information about customers, products, vendors, employees, projects, or sales
Term
Layout
Definition
Provides a natural tabular layouts as well as ability to create customized data entry screens
Term
Storage
Definition
Stores any number of records up to 2 GB
Term
Linked Tables
Definition
Allows links between lists of information to reduce data
Term
reporting
Definition
Creates and saves multiple presentations of data
Term
Security
Definition
Allows users to access only the records and fields they need
Term
Multiuser Capabilities
Definition
Allows multiple users to simultaneously enter and update data
Term
Data Entry
Definition
Provides the ability to create extensive data entry screens called forms
Term
Field
Definition
The Smallest unit of data organization; consists of a specific category of data such as a customer's name, city, state. or phone number
Term
record
Definition
A group of related fields that describe a person, place, or thing
Term
Key field
Definition
A field that contains unique information for each record, such as a customer number for a customer
Term
table
Definition
A collection of records for a single subject
Term
Database
Definition
A colelction of tables associated with a generl topic
Term
Relational Database
Definition
An Access database with mulitple tables that are linked together by a common field
Term
Onjects
Definition
the aprts of an Access database that help you view, edit, manage, and analyze the data, such as tables, queiries, forms, reports, macros and modules
Term
featured database\online templates
Definition
Assets, contacts, issues, events, Marketing Projects, projects, sales pipeline, tasks
Term
AutoNumber field
Definition
Access automatically enters the next consecutive number into the field as it creates the record
Term
Press ESC
Definition
Pressing [ESC] once removes the current field's editing changes, so the tourStartDAte changes back to 7/16/2010. Pressing [ESC] twice removes all changes to the current record.
Term
[Backspace]
Definition
Deletes on character to the left of the insertion point
Term
[Delete]
Definition
Deletes one character to the right of the insertion point
Term
[F2]
Definition
Switches between edit and Navigation mode
Term
[ESC]
Definition
Undoes th change to the current record
Term
[ESC][ESC]
Definition
Undoes all changes to the current record
Term
[F7]
Definition
Starts the spell check feature
Term
[Ctrl][']
Definition
Inserts the value from the same field in the previous record into the current field
Term
[Ctrl][;]
Definition
Inserts the current date in a Date field
Term
Access form
Definition
(an easy-to-use date entry screen) instead fo directly in a table, the data is stored in the underlying table.
Term
Navigation Pane
Definition
provides a way to move between objects (tables, queires, forms, and reports) in the database
Term
Text
Definition
Text information or combinations of text and numbers, such as a street address, name, or phone number. Up to 255 characters
Term
Memo
Definition
lengthy text, such as comments or notes. up to 65,535 characters
Term
Number
Definition
Numeris information, such as quantities. Several sizes available to store numbers with varying degrees of precision.
Term
Date\Time
Definition
Dates and times. Size controlled by Access to accommodate dates and times across thousands of years (for exmaple, 1/1/1850 and 1/1/2150 are valid dates)
Term
Currency
Definition
Monetary values. Size controlled by Access; accommodates up to 15 digits to the left decimal point and four digits to the right
Term
AutoNumber
Definition
Integars assigned by Access to sequentially order each record added to a table. Size controlled by Access
Term
yes\No
Definition
Only one of two values stored (Yes\No, On\Off, True\False). Size controlled by Access
Term
OLE Object
Definition
Office and windows files that can be linked or embedded (OLE) such as a pictures, sound clips, documents, or spreadsheets. Up to 2GB
Term
Attachment
Definition
Any Supported file type including .jpg images, speradsheets, and documents (new for Office 2007). Up to 1 GB
Term
Hyperlink
Definition
Web and e-mail address. Size controlled by access
Term
Primary Key Field Symbol
Definition
Key symbol
Term
Criteria
Definition
Limit the number fo records shown the resulting datasheet
Term
Click Datasheet View Button ont eh design tab to switch to datasheet View
Definition
The RESULTING datasheet lists the Adventure tours.
Term
Ascending
Definition
Sorts records based on the celected field in ascending order (0 to 9, A to Z)
Term
Descending
Definition
Sprts records based on the seleted field in descneding order (Z to A, ( to 0)
Term
Clear All Sorts
Definition
removes the current sort order
Term
find
Definition
opens the Find and Replace dialog box, which allows you to find data in a single field or in the entire datashetet
Term
Replace
Definition
Opens the Find and Replace dialog box, which allows you to find and replace data
Term
Go To
Definition
Helps you navigate to the first, previous, last, or new reocrd
Term
Select
Definition
Helps you select a single record or all record or all records in a datasheet
Term
Wildcard
Definition
represents and character in the criteria entry
Term
Filter
Definition
Provides a list of values int the selected field by which to customize a filter
Term
Filter
Definition
Provides a list of values int the selected field by which to customize a filter
Term
Selection
Definition
Filters records that equal, do not equal, or are otherwise compared to the current value
Term
Advanced
Definition
provides advanced filter features such as Filter by Form, Save as Query, and clear grid
Term
Toggle Filter
Definition
applies or removes the current filter
Term
Criteria Syntax
Definition
Rules by which criteria need to be entered.
Term
Is Null and Is not Null
Definition
Two other types of common criteria. The is Null criteria finds all records where no entry has been made in the field. Is Not Null finds all records where is any entry in the field, even if the entry is 0. Primary key fields cannot have a null entry.
Term
>
Definition
greater than
Term
>=
Definition
greater than or equal too
Term
<
Definition
less than
Term
<=
Definition
less than or equal to
Term
<>
Definition
Not equal to
Supporting users have an ad free experience!