Mod 9 Pre/Post Database Unit1Purpose and Parts

DatabaseObject:TableTable Parts: 1. Entry 2. Field 3. Record

2 DataTypesField PropertiesData types:.1. Text –2. Memo –3. Number-4. Date/time –5. Currency –6. Auto Number –7. Yes/No –8. Drop Down List-9. Lookup Wizard

Field properties 10. Field size –11. Format – 12. Input Mask –13. Caption –

Editing and Printing int. Print Orientation Portrait/ Landscape

3DB_ Managemt

A.Filters 1. Filter by

Selection –2. Filter/

Advanced Filter Sort –

3. Filter by exclusion –

B. Query C. Sorts

Ascending Descending

Mod 7 SS Basics1 SS and Components

1. Workbook:2. SS:3. Cells :4. Cell Data-Label -Value -Formula

2 Formulating with Formulas= to begin

Order of OperationsParenthesesExponentsMultiplication

Division

AdditionDivisionPlease Excuse My Dear Aunt

Sally

2fx Function Fun 1. ComponentsCell Reference -relative,-absolute,-mixedParenthesesCondition/Criteria

2. FunctionsSumAverageMaxMin

Mod 7 SS Basics3 Formats1. Header/footer2. Font Size/Style3. . Justification (left,

indent, right, center)4. Adjust Height, Width,

Size of cells, Columns, Rows (Wrap, Merge, Column Width)

5. Borders and Shading6. Editing7. Renaming8. Reordering

4 SS Operations

1. Sort (primary, secondary)2. Freeze Pane3. Fill Series4. Print

Mod 8Advanced SS 1. Advanced Functions

1. If Statements2. Date

Functions3. Look Up

(2)/Vlook UP (2+)

4. List (Validate or non Validate)

5. Count/Count A/Count If

Mod 8 Advanced SS2 Chart and Graph Components

GRAPHS1. y-axis2. X-axis3. data-marker4. Data series5. gridlines6. plot area7. tick mark

CHARTS

1. legend2. data label3. chart title4. x-axis

title5. y-axis

title

3 Types of Charts

1. Column2. Stacke

d bar3. Line4. XY

Scatter5. Pie6. Exploded