Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
48 Cards in this Set
- Front
- Back
|
Microsoft Access
|
a relational database management application that is used to create analyze a database
|
|
|
Database
|
collection of related data
|
|
|
Objects
|
contain the basic elements of a database
|
|
|
Table
|
a data structure that organizes information into rows and columns. It can be used to both store and display data in a structured format.
|
|
|
Query
|
another word for question. used to retrieve information. Eg. Search Engine is search query
|
|
|
Report
|
the answer to a query
|
|
|
Macro
|
a small program, or script, that automates common tasks. These scripts are usually run within programs and can often be created by the user. Also known as a "keyboard shortcut"
|
|
|
Module
|
can contain one or several routines
|
|
|
Programs
|
are composed of one or more independently developed modules that are not combined until the program is linked
|
|
|
Datasheet
|
used to add, modify, delete and view records
|
|
|
Design
|
used to create and modify the fields in a table
|
|
|
F6 Key
|
moves to the next pane
|
|
|
Primary Key
|
a field the uniquely identify each record
|
|
|
FieldSize Property
|
set in design view. Anticipates the future
|
|
|
Validation Rules
|
used to avoid data entry errors by restricting what can be entered
|
|
|
SOX
|
protects public and shareholders against fraudulent practices
|
|
|
Personal Non Public Info (PNPI)
|
laws govern the safeguard of data such as social security numbers
|
|
|
Avoid calculated fields
|
use in queries or reports instead
|
|
|
Design multiple tables
|
educe redundancy- normalization
|
|
|
CamelCase
|
notation to use for field names, access does not like spaces
|
|
|
Form
|
an interface that enable you to enter or modify record data; Same can be accomplished through the datasheet view of the table, but the form interface is easier for non-tech users
|
|
|
Criteria
|
the rules to formulate queries
|
|
|
Select Query
|
Most basic query, which searches table and returns a datasheet
|
|
|
Datasheet
|
Answer to a query
|
|
|
File Management
|
access data is stored on the hard drive. While you are working-not in memory like word, excel, and powerpoint
|
|
|
Filter
|
lets you find a subset of meaningful data
|
|
|
Filter by sections
|
selects only the records that match the pre-selected criteria
|
|
|
Sort
|
lists those records in a specific sequence, alphabetically or last name
|
|
|
Relational Database
|
Data organized in related tables
Common key Helps eliminate redundant data Excel is NOT relational |
|
|
Primary Key
|
each record in table unique
|
|
|
Foreign Key
|
primary key form a table that becomes stored in another table so it can be linked.
|
|
|
Referential Integrity
|
data in database maintains consistency when data change
|
|
|
Cardinality
|
indicates the number of instances of an entity, relationships:
One on One One to Many Many to Many |
|
|
Front End
|
Object needed for user interaction
|
|
|
Back End
|
data resides
|
|
|
Order of Precedence
|
rules of equations
|
|
|
Expressions
|
formulas based on existing fields include:
Names of fields Operators Functions, constant values |
|
|
Constant
|
a named item whose value remains constant
|
|
|
Tax Calculation
|
[Price]*[Quantity]*.8
|
|
|
Expression builder
|
used to formulate the expression in field
|
|
|
IIF in Access
|
If and only If
|
|
|
“q”
|
come up with quarter
|
|
|
“h”
|
hour
|
|
|
“d”
|
date
|
|
|
Chart Data
|
2 Types: Continuous & Discrete
|
|
|
Continuous Chart Data
|
broken into smaller segs
|
|
|
Discrete Chart Data
|
broken down into smaller increments
|
|
|
Macros
|
embedded: single task Standalone: more tasks
|
