|
Database:
Field - attribute - content of field is called field value
Record- tuple
Table - relation all records must be the same number of fields, same order, and
same data types.(NOT)
Open - display the content of a table
Design - modify the structure of an existing table
New - create a new table and offers several method of
doing so
Common Field- same data type - used for joins
Primary Key - unique, not null, 1st index of table - called entity integrity
Composite primary key is made up of two or more fields.
Foreign Key - common key in related table must be same data type as primary key
Joins -
one to many - once in primary tables primary key- many times
in related tables foreign key
one to one - once in primary table and once in related table
many to many - use composite key in third table made up of
primary key from the two other tables
Referential Integrity - can not be put into related tables foreign key,
unless it already exist in the primary tables primary key.
Cascade Update - if the primary key is changed in the primary table then all
records in the related tables foreign keys will also be changed to the new
primary key|
Cascade Delete - if the primary key in the primary tables is deleted all record
in the related tables foreign key that match the deleted primary key will be
deleted.
Table - made up of fields- is the structure that contain all of the data Field
types.
Text
Auto Number- integer values
Date/Time
OLE
Hyperlink
Look Up
Number
Currency
Memo
Yes/NO
Form - Graphic User Interface (GUI) used to design forms for input into
tables
Group Form - Use the primary table data first and the related
table second
Auto Form Wizard - several selections - some for one record
display at a time other for multiple
record display.
Sub Form
Queries - used to select information from the tables based on criteria selected
for the fields.
select queries - do not change data in the tables
action queries - modify the data in the tables
all queried are saved in Structured Query Language (SQL)
the data sheet produced by the query is not saved it is
temporary
Calculated field in query
Expression Builder
Zoom
Reports - formatted out put for the queries and reports.
Report Header - once at beginning of the report
Report Footer - once at the end of the report - calculated
fields here
Page Header - at the top of each page
Page Footer - at the bottom of each page
Detail - this is where you place the data you want displayed
GrouP Header - up to ten also sort
Group Footer - up to ten also sort
Grouped Report - use the primary table data first and the
related table data second.
Macros - functions used to automate
Page - used to create data access web pages
Module - used to write Visual Basic Code.
Database Design
1. Identify all the fields needed to produce the required
information - brain storm
2. Group Related fields into tables
3. Determine each table's primary key
4. include a common field in related tables
5. Avoid Data redundancy
6. Field names can be 255 characters long. Must begin
with an alpha character
7. Compacting a database rearranges the data, removes the
deleted records, and makes the database
smaller
Relational Data Base Management System (DBMS) allows the creation of tables with
common fields that can be joined in relationship and data can be extracted from
multiple tables in queries based on the joins.
Importing data by copying from another database table can only be done if both
tables have the same structure.
Importing tables can also be done
Spread Sheet -
Work book is 255 columns (A to IV) by 65,356 rows by 255 sheets
Cell is referenced by Column and Row- PageDown, PageUp, Alt-PageUP, Alt-PageDown,
Ctrl-Home, F5
AutoFill -
AutoComplete
AutoFormat
Chart Wizard
Ask you to select chart type
Ask you to select data to be graphed
Ask you to input main title
Ask you to input x axis title
Ask you to input y axis title
Ask you to select legend
Can select to display grids both vertical and horizontal
tic mark in graph represent data intervals
Pointer (mouse) is a plus sign that is white and fat
Pointer (mouse) for auto fill is a plus sign that is black and thin
Formulas and functions all begin with a =
There are numerous functions in excel
=SUM()
=If(COND,True,False)
=AVG()
The arguments to the functions are generally cell ranges.
Borders Tab/Toolbar
Line Style
Border Style
Fill Effects
Back Ground Image - single sheet, all sheets
Relative Relationship Copy
Absolute Reference Copy- F4
Mixed Reference Copy
Range of cell in formula or function =SUM(A5:C5, D12, E1:E20)
Alignment Default Value
Text
Number
Save As allow us to rename a work book
It is important to consider the size of your power point presentation when
saving to a floppy disk.
Presentation Graphics
Slide Sorter View
Normal View
Slide Show
Slides
Print
Slides
Handouts
| NotePages
Outline
GrayScale
Pure Black and White
Color
Presentation can be modified in outline pane or slide pane
Bulleted list
Number list
Promote by decrease indent
|