• Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

How to study your flashcards.

Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key

Up/Down arrow keys: Flip the card between the front and back.down keyup key

H key: Show hint (3rd side).h key

A key: Read text to speech.a key

image

Play button

image

Play button

image

Progress

1/48

Click to flip

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