Microsoft Access Template Loan Amortization - Excel - Excel

Document Sample
Microsoft Access Template Loan Amortization - Excel - Excel Powered By Docstoc
					                                   WHAT YOU SHOULD KNOW……
Word Project 1
                                                     Where         How
Display Formatting Marks                             WD 14
Wordwrap Text as You Type                            WD 15
Insert a Blank Line                                  WD 15
Check Spelling & Grammar as you type                 WD 16
Save a New Document                                  WD 19
Apply Styles                                         WD 24
Center a Paragraph                                   WD 26
Change the Font Size of Selected Text                WD 28
Change the Font of Selected Text                     WD 29
Bullet a List of Paragraphs                          WD 32
Undo and Redo an Action                              WD 32
Select a Group of Words                              WD 33
Bold & Italicize Text                                WD 34
Underline a Word                                     WD 35
Change the Style Set                                 WD 37
Change Theme Colors and Fonts                        WD 39
Insert a Picture                                     WD 41
Apply a Picture Style                                WD 44
Change a Border Picture Color                        WD 45
Zoom the Document                                    WD 45
Resize a Graphic                                     WD 46
Add a Page Border                                    WD 48
Change Spacing Above and Below Paragraphs            WD 50
Change Document Properties                           WD 51
Save an Existing Document w/ the Same File Name      WD 53
Quit Word with One Document Open                     WD 55
Insert Text in an Existing Document                  WD 58

                                                  Date Completed
Project 1
In The Lab 3
Project 1 Online Practice Test
Project 1 Test
Project 1 Practicum
Study Guide
                                      WHAT YOU SHOULD KNOW……
Word Project 2
                                                        Where          How
Double-Space Text                                       WD 78
Remove Space after a Paragraph                          WD 79
Switch to the Header                                    WD 80
Right-Align a Paragraph                                 WD 81
Insert a Page Number                                    WD 82
Close the Header                                        WD 83
Display the Rulers                                      WD 87
First-Line Indent Paragraphs                            WD 88
Create a Quick Style                                    WD 90
AutoCorrect as you Type                                 WD 91
Use the AutoCorrect Options Button                      WD 92
Create an AutoCorrect Entry                             WD 93
Change the Bibliography Entry                           WD 95
Insert a Citation and Create its Source                 WD 96
Edit a Citation                                         WD 98
Insert a Footnote Reference Mark                        WD 100
Insert a Citation Placeholder                           WD 101
Modify a Style Using a Shortcut Menu                    WD 102
Edit a Source                                           WD 104
Count Words                                             WD 107
Page Break Manually                                     WD 112
Create the Bibliographical List                         WD 113
Modify a Style Using the Styles Task Pane               WD 114
Create a Hanging Indent                                 WD 116
Modify a Source and Update the Bibliographical List     WD 117
Use the Select Browse Object Menu                       WD 118
Select and Move Text                                    WD 121
Display the Paste Options Menu                          WD 122
Find and Replace Text                                   WD 123
Find and Insert a Synonym                               WD 124
View or Modify Entries in a Custom Dictionary           WD 127
Set the Default Custom Dictionary                       WD 127
Use the Research Task Pane to Look Up Information       WD 128
Print Document Properties and then the Document         WD 130

                                                      Date Completed
Project 2
In The Lab 3
Project 2 Online Practice Test
Project 2 Test
Project 2 Practicum
Study Guide
                                       WHAT YOU SHOULD KNOW……
Word Project 3
                                                          Where          How
Use the Grow Font Button to Increase Font Size            WD 151
Color Text                                                WD 152
Insert Clip Art                                           WD 153
Resize a Graphic Using the Size Dialog Box                WD 155
Recolor a Graphic                                         WD 156
Set a Transparent Color in a Graphic                      WD 157
Set Custom Tab Stops Using the Tabs Dialog Box            WD 158
Bottom Border a Paragraph                                 WD 161
Clear Formatting                                          WD 162
Convert a Hyperlink to Regular Text                       WD 163
Create a New File from an Existing File                   WD 165
Set Custom Tab Stops Using the Ruler                      WD 167
Insert the Current Date                                   WD 168
Create a Building Block                                   WD 170
Insert a Nonbreaking Space                                WD 171
Insert a Building Block                                   WD 172
Insert an Empty Table                                     WD 173
Enter Data in a Table                                     WD 175
Apply a Table Style                                       WD 176
Resize Table Columns to fit Table Contents                WD 177
Bullet a List as you Type                                 WD 180
Use a Template                                            WD 183
Modify Text in a Content Control                          WD 187
Copy & Paste Items to/from the Office Clipboard           WD 189
Enter a Line Break                                        WD 194
Indent a Paragraph                                        WD 196
Insert a Building Block Using the Quick Parts Gallery     WD 198
Sort Paragraphs                                           WD 200

                                                        Date Completed
Project 3
In The Lab 3
Project 3 Online Practice Test
Project 3 Test
Project 3 Practicum
Study Guide
                                          WHAT YOU SHOULD KNOW……
Word Project 4
                                                               Where          How
Border a Paragraph                                             WD 231
Shade a Paragraph                                              WD 232
Change Left and Right Paragraph Indent                         WD 233
Insert a SmartArt Graphic                                      WD 235
Add Text to a SmartArt Graphic                                 WD 237
Change Colors of a SmartArt Graphic                            WD 238
Apply a SmartArt Style                                         WD 239
Format Characters & Modify Character Spacing                   WD 240
Modify & Reset the Default Font Settings                       WD 242
Change Case of Text                                            WD 243
Zoom One Page                                                  WD 244
Create a Watermark                                             WD 245
Reveal Formatting                                              WD 248
Insert a Next Page Section Break                               WD 250
Delete a Section Break                                         WD 251
Customize Theme Fonts                                          WD 255
Delete a Page Break                                            WD 256
Cut Text                                                       WD 257
Go to a Section                                                WD 258
Create a Header different from the Previous Section Header     WD 259
Insert a Formatted Header & Footer                             WD 260
Format Page Numbers to Start at a Different Number             WD 262
Add & Delete Columns                                           WD 263
Sum Columns in a Table                                         WD 265
Border a Table                                                 WD 267
Align Data in Cells                                            WD 268
Chart a Table                                                  WD 269
Move Legend Placement in a Chart                               WD 270
Change the Chart Type                                          WD 272
Find a Format                                                  WD 274
Create a Character Style                                       WD 276
Select Nonadjacent Text                                        WD 277
Customize Bullets in a List                                    WD 278
Draw an Empty Table                                            WD 280
Erase Lines in a Table                                         WD 282
Distribute Rows                                                WD 283
Display Text in a Cell Vertically                              WD 284
Merge Cells                                                    WD 287
Split Table Cells                                              WD 287
Shade a Table Cell                                             WD 288

                                                             Date Completed
Project 4
In The Lab 3
Project 4 Online Practice Test
Project 4 Test
Project 4 Practicum
Study Guide
                                         WHAT YOU SHOULD KNOW……
Word Project 5
                                                              Where          How
Change the Username and Initials                              WD 312
Change the Margin Settings                                    WD 313
Insert a Drawing Canvas                                       WD 314
Insert a Shape                                                WD 316
Apply a Shape Style                                           WD 316
Add Formatted Text to a Shape                                 WD 319
Resize a Drawing Canvas                                       WD 320
Create a Folder while Saving                                  WD 321
Create a New Data Source                                      WD 323
Save the Data Source when Prompted                            WD 328
Enter the Date                                                WD 330
Edit the Greeting Line Merge Field                            WD 332
Insert a Merge Field in the Main Document                     WD 333
Create a Multilevel List                                      WD 335
Insert an IF Field in the Main Document                       WD 338
Display a Field Code                                          WD 341
Print Field Codes in the Main Document                        WD 342
Merge the Form Letters to the Printer                         WD 344
Merge to a New Document Window                                WD 345
Select Records to Merge                                       WD 345
Remove a Merge Condition                                      WD 348
Sort the Data Records in a Data Source                        WD 348
View Merged Data in the Main Document                         WD 349
Address & Print Mailing Labels using Existing Data Source     WD 350
Address & Print Envelopes using Existing Data Source          WD 356
Merge to a Directory                                          WD 358
Convert Text to Table                                         WD 361
Format Text as Hidden                                         WD 366
Hide Hidden Text                                              WD 367

                                                            Date Completed
Project 5
In The Lab 3
Project 5 Online Practice Test
Project 5 Test
Project 5 Practicum
Study Guide
                                      WHAT YOU SHOULD KNOW……
Word Project 6
                                                         Where          How
Set Custom Margins                                       WD 389
Insert WordArt                                           WD 391
Change the WordArt Fill Color                            WD 393
Change the WordArt Shape                                 WD 395
Border One Edge of a Paragraph                           WD 396
Insert a Symbol                                          WD 398
Format a Graphic as Floating                             WD 402
Move & Flip a Graphic                                    WD 403
Adjust the Brightness of a Graphic                       WD 404
Modify a Style Using the Modify Style Dialog Box         WD 405
Insert a Continuous Section Break                        WD 409
Insert a File in a Column of the Newsletter              WD 412
Format a Letter as a Drop Cap                            WD 416
Format the Drop Cap                                      WD 417
Insert a Next Page Break                                 WD 418
Insert a Column Break                                    WD 420
Update a Style to Match a Selection                      WD 424
Place a Vertical Rule between Columns                    WD 425
Insert & Position a Text Box                             WD 427
Change Column Formatting                                 WD 432
Split the Window                                         WD 434
Arrange All Open Word Documents on the Screen            WD 435
Copy & Paste Using Split Windows                         WD 436
Remove a Split Window                                    WD 437
Balance Columns                                          WD 438
Change the Layout of a SmartArt Graphic                  WD 440
Modify Theme Effects                                     WD 440
Add a Shape to a SmartArt Graphic                        WD 441
Save Customized Themes                                   WD 441
Add Text to a SmartArt Graphic Through the Text Pane     WD 442
Add an Outline to a SmartArt Graphic                     WD 443
E-Mail a Document as a PDF                               WD 449

                                                       Date Completed
Project 6
In The Lab 3
Project 6 Online Practice Test
Project 6 Test
Project 6 Practicum
Study Guide
                                      WHAT YOU SHOULD KNOW……
PowerPoint Project 1
                                                           Where         How
Choose a Document Theme                                    PPT 16
Enter the Presentation Title                               PPT 18
Enter the Presentation Subtitle Paragraph                  PPT 20
Select Multiple Paragraphs                                 PPT 22
Change the Text Color                                      PPT 23
Select a Group of Words                                    PPT 24
Increase Font Size                                         PPT 24
Decrease the Title Slide Title Text Font Size              PPT 25
Add a New Text Slide with a Bulleted List                  PPT 29
Enter a Slide Title                                        PPT 31
Select a Text Placeholder                                  PPT 31
Type a Single-Level Bulleted List                          PPT 32
Add a New Slide and Enter a Slide Title                    PPT 33
Type a Multi-Level Bulleted List                           PPT 34
Create a Third-Level Paragraph                             PPT 37
Duplicate a Slide                                          PPT 40
Arrange a Slide                                            PPT 41
Delete All Text in a Placeholder                           PPT 42
Change Document Properties                                 PPT 44
Save an Existing Presentation with the Same File Name      PPT 45
Use the Scroll Box to Move Another Slide                   PPT 47
Start Slide Show View                                      PPT 49
Move Manually through Slides in a Slideshow                PPT 50
Display the Pop-Up Menu and Go to a Specific Slide         PPT 51
Use the Pop-Up Menu to End a Slide Show                    PPT 52
Open a Presentation from PowerPoint                        PPT 54
Display a Presentation in Grayscale                        PPT 59
Print a Presentation                                       PPT 61
Search for PowerPoint Help                                 PPT 63

                                                        Date Completed
Project 1
In The Lab 3
Project 1 Online Practice Test
Project 1 Test
Project 1 Practicum
Study Guide
                                             WHAT YOU SHOULD KNOW……
PowerPoint Project 2
                                                                      Where         How
Choose a Background Style                                            PPT 89
Change the View to Slide Sorter View                                 PPT 91
Change the View to Normal View                                       PPT 91
Change the Slide Layout to Two Content                               PPT 92
Change the Slide Layout to Picture with Caption                      PPT 94
Insert a Clip from the Clip Organizer into a Content Placeholder     PPT 96
Insert a Photograph from the Clip Organizer into a Slide             PPT 98
Insert a Photograph from a File into a Slide                         PPT 99
Resize Clip Art                                                      PPT 100
Resize a Photograph                                                  PPT 103
Delete a Placeholder                                                 PPT 104
Move Clips                                                           PPT 105
Format Title Text Using Quick Styles                                 PPT 106
Format Remaining Title Text Using Quick Styles                       PPT 107
Change the Heading Font                                              PPT 109
Shadow Text                                                          PPT 110
Change Font Color                                                    PPT 110
Format Text Using the Format Painter                                 PPT 112
Format Remaining Title Text                                          PPT 113
Add a Shape                                                          PPT 116
Resize a Shape                                                       PPT 117
Add Text to a Shape                                                  PPT 119
Format Shape Text and Add a Shape Quick Style                        PPT 119
Add a Transition between Slides                                      PPT 122
Preview and Print an Outline                                         PPT 122
Preview and Print Handouts                                           PPT 129

                                                                   Date Completed
Project 2
In The Lab 3
Project 2 Online Practice Test
Project 2 Test
Project 2 Practicum
Study Guide
                                     WHAT YOU SHOULD KNOW……
PowerPoint Project 3
                                                       Where         How
Open a Microsoft Word Outline as a Presentation       PPT 165
Insert a Texture Fill                                 PPT 168
Insert a Picture to Create a Background               PPT 171
Format the Background Picture Fill Transparency       PPT 172
Add Slide Numbers, Date, and Time                     PPT 172
Apply a WordArt Style                                 PPT 175
Format the WordArt Text Fill                          PPT 176
Change the Weight of the WordArt Outline              PPT 178
Add a WordArt Text Effect                             PPT 179
Convert Text to a SmartArt Graphic                    PPT 181
Insert Images from a File into a SmartArt Graphic     PPT 182
Add a SmartArt Style to the Graphic                   PPT 184
Change the SmartArt Color                             PPT 186
Insert and Rotate a Text Box                          PPT 188
Format the Text Box                                   PPT 191
Insert a Clip into a Content Placeholder              PPT 197
Ungroup a Clip                                        PPT 198
Change the Color of PowerPoint Objects                PPT 199
Regroup Objects                                       PPT 203
Insert a SmartArt Graphic                             PPT 203
Enter Text in the SmartArt Graphic                    PPT 206
Format the Text Pane Characters                       PPT 207
Adjust the SmartArt Graphic Size                      PPT 209
Save an Existing PPT w/ the Same File Name            PPT 211
Add a Transition between Slides                       PPT 211

                                                    Date Completed
Project 3
In The Lab 3
Project 3 Online Practice Test
Project 3 Test
Project 3 Practicum
Study Guide
                                          WHAT YOU SHOULD KNOW……
PowerPoint Project 4
                                                                 Where         How
Change the Presentation Theme Colors                            PPT 232
Change the Theme Fonts                                          PPT 233
Insert a Picture into a Slide without a Content Placeholder     PPT 234
Apply a Picture Style                                           PPT 236
Change the Border Color of a Picture                            PPT 237
Change a Picture Contrast                                       PPT 238
Insert a Clip into a Slide without a Content Placeholder        PPT 238
Change the Border Color of a Clip                               PPT 241
Change the Brightness of a Clip                                 PPT 242
Add a Hyperlink to a Slide                                      PPT 243
Insert an Empty Table                                           PPT 246
Enter Data in a Table                                           PPT 248
Apply a Table Style                                             PPT 249
Add Borders to a Table                                          PPT 251
Add an Effect to a Table                                        PPT 252
Apply a Chart Style                                             PPT 260
Change the Chart Layout                                         PPT 261
Change the Shape Outline Weight                                 PPT 262
Change the Shape Outline Color                                  PPT 263
Change the Title and Legend Font Size                           PPT 263
Hide a Slide                                                    PPT 266
Use the Thesaurus                                               PPT 268
Find a Second Synonym                                           PPT 270
Insert an Action Button                                         PPT 271
Size an Action Button                                           PPT 273
Change the Action Button Fill Color                             PPT 273
Position the Action Button Using Guides                         PPT 274
Copy the Action Button                                          PPT 276
Edit the Action Button Hyperlink Settings                       PPT 278
Hide Guides                                                     PPT 279
Run a Slideshow with a Hidden Slide and Hyperlinks              PPT 281
Run a Slideshow with Action Buttons                             PPT 281

                                                              Date Completed
Project 4
In The Lab 3
Project 4 Online Practice Test
Project 4 Test
Project 4 Practicum
Study Guide
                                        WHAT YOU SHOULD KNOW……
Excel Project 1
                                                              Where         How
Enter the Worksheet Titles                                    EX 17
Enter Column Titles                                           EX 19
Enter Row Titles                                              EX 21
Enter Numbers                                                 EX 23
Sum a Column of Numbers                                       EX 25
Copy a Cell to Adjacent Cells in a Row                        EX 27
Determine Multiple Totals at the Same Time                    EX 28
Change a Cell Style                                           EX 35
Increase the Font Size of a Cell Entry                        EX 38
Change the Font Color of a Cell Entry                         EX 39
Center Cell Entries across Columns by Merging Cells           EX 40
Format Column Titles and the Total Row                        EX 42
Format Numbers in the Worksheet                               EX 44
Adjust the Column Width                                       EX 46
Use the Name Box to Select a Cell                             EX 47
Add a 3-D Clustered Column Chart to the Worksheet             EX 50
Change Document Properties                                    EX 55
Save an Existing Workbook with the Same File Name             EX 58
Use the AutoCalculate Area to Determine a Maximum             EX 62
Clear Cell Entries Using the Fill Handle                      EX 66
Clear Cell Entries Using the Shortcut Menu                    EX 66
Clear Cell Entries Using the Delete Key                       EX 66
Clear Cell Entries and Formatting Using the Clear Button      EX 66
Clear Formatting Using the Cell Styles Button                 EX 66

                                                           Date Completed
Project 1
In The Lab 3
Project 1 Online Practice Test
Project 1 Test
Project 1 Practicum
Study Guide
                                           WHAT YOU SHOULD KNOW……
Excel Project 2
                                                                    Where         How
Enter a Formula Using a Keyboard                                    EX 91
Enter Formulas Using Point Mode                                     EX 93
Copy Formulas Using the Fill Handle                                 EX 95
Determine the Average of a Range of Numbers                         EX 99
Determine the Highest Number in a Range of Numbers                  EX 101
Determine the Lowest Number in a Range                              EX 102
Copy a Range of Cells across Columns to an Adjacent Range           EX 104
Verify a Formula Using Range Finder                                 EX 106
Change the Workbook Theme                                           EX 109
Change Background Color/Apply Box Border to Worksheet Title         EX 110
Center Data in Cells and Format Dates                               EX 113
Apply an Accounting Number Format & Comma Style Format              EX 115
Apply a Currency Style Format with a Floating Dollar Sign           EX 116
Apply a Percent Style Format & Use the Increase Decimal Button      EX 118
Apply Conditional Formatting                                        EX 119
Change the Width of Columns                                         EX 122
Change the Height of Rows                                           EX 125
Change the Worksheet's Margins, Header, & Orientation               EX 130
Display the Formulas in the Worksheet and Fit it on One Page        EX 136
Import Data from a Web Source Using a Web Query                     EX 138
Change the Worksheets Names                                         EX 141

                                                                 Date Completed
Project 2
In The Lab 3
Cases and Places 3
Project 2 Online Practice Test
Project 2 Test
Project 2 Practicum
Study Guide
                                        WHAT YOU SHOULD KNOW……
Excel Project 3
                                                             Where         How
Rotate Text and Create Series of Months                      EX 169
Increase Column Widths and Enter Row Titles                  EX 173
Copy a Range of Cells to Nonadjacent Area                    EX 175
Insert a Row                                                 EX 177
Enter Numbers with Format Symbols                            EX 181
Freeze Column and Row Titles                                 EX 182
Enter and Format the System Date                             EX 184
Enter a Formula Containing Absolute References               EX 187
Enter an IF Function                                         EX 190
Copy Formulas with Absolute Cell References                  EX 192
Unfreeze the Worksheet Titles & Save the Workbook            EX 194
Assign Formats to Nonadjacent Ranges                         EX 196
Format the Worksheet Titles                                  EX 199
Copy a Cell's Format Using the Format Painter Button         EX 201
Draw a 3-D Pie Chart on a Separate Chart Sheet               EX 206
Insert a Chart Title and Data Labels                         EX 206
Rotate the 3-D Pie Chart                                     EX 209
Apply a 3-D Format to the Pie Chart                          EX 211
Explode the 3-D Pie Chart & Change the Color of a Slice      EX 213
Rename & Reorder the Sheets and Color Their Tabs             EX 216
Check Spelling in Multiple Sheets                            EX 218
Split the Window into Panes                                  EX 222
Analyze Data in a Worksheet by Changing Values               EX 224

                                                          Date Completed
Project 3
In The Lab 3
Cases and Places 3
Project 3 Online Practice Test
Project 3 Test
Project 3 Practicum
Study Guide
                                     WHAT YOU SHOULD KNOW……
Excel Project 4
                                                         Where         How
Add Custom Borders & a Background Color to a Range       EX 272
Create Names Based on Row Titles                         EX 276
Enter the Loan Amount Formula Using Names                EX 279
Enter the PMT Function                                   EX 280
Create a Percent Series Using the Fill Handle            EX 286
Define a Range as a Data Table                           EX 288
Add a Pointer to the Data Table                          EX 292
Enter the Formulas in the Amortization Schedule          EX 297
Copy the Formulas to Fill the Amortization Schedule      EX 301
Set Up a Worksheet to Print                              EX 307
Set the Print Area                                       EX 309
Name and Print Sections of a Worksheet                   EX 310
Protect a Worksheet                                      EX 313
Hide & Unhide a Sheet                                    EX 316
Hide & Unhide a Workbook                                 EX 317
Enable Background Formula Checking                       EX 319

                                                      Date Completed
Project 4
In The Lab 3
Project 4 Online Practice Test
Project 4 Test
Project 4 Practicum
Study Guide
                                           WHAT YOU SHOULD
Excel Project 5

Format a Range as a Table
Validate Data
Modify a Table Quick Style
Enter Records in a Table
Add New Fields to a Table
Create a Lookup Table
Use the VLOOKUP Function to Determine Letter Grades
Add a Conditional Formatting Rule with an Icon Set
Use the Total Row Check Box
Sort a Table in a Ascending Sequence by Name
Sort a Table in a Descending Sequence by Name
Sort a Table Using the Sort Command on a Column Heading
Sort a Table on Multiple Fields Using the Custom Sort Command
Display Automatic Subtotals in a Table
Zoom Out on a Subtotaled Table & Use the Outline Feature
Remove Automatic Subtotals from a Table
Sort a Table Using a Column Heading List
Query a Table Using AutoFilter
Show All Records in a Table
Enter Custom Criteria Using AutoFilter
Create a Criteria Range on a Worksheet
Query a Table Using the Advanced Filter Dialog Box
Create an Extract Range and Extract Records
Use the DAVERAGE and DCOUNT Database Functions
Use the SUMIF and COUNTIF Functions
Save a Workbook in CSV File Format
Use Notepad to Open & Print the CSV File


Project 5
In The Lab 3
Project 5 Online Practice Test
Project 5 Test
Project 5 Practicum
Study Guide
OU SHOULD KNOW……
       Where         How
       EX 346
       EX 348
       EX 351
       EX 353
       EX 355
       EX 357
       EX 359
       EX 362
       EX 365
       EX 369
       EX 370
       EX 371
       EX 372
       EX 375
       EX 377
       EX 379
       EX 379
       EX 380
       EX 382
       EX 383
       EX 385
       EX 386
       EX 388
       EX 391
       EX 393
       EX 396
       EX 398

    Date Completed
              WHAT YOU SHOUL




Study Guide
                                               WHAT YOU SHOULD K
Excel Project 6

Save a Template
Create and Assign a Custom Format Code & Comma Style Format
Create & Apply a New Style
Open a Template & Save It as a Workbook
Add a Worksheet to a Workbook
Copy the Contents of a Worksheet to other Worksheets in a Workbook
Drill an Entry through Worksheets
Enter & Copy 3-D References Using the Paste Button Menu
Format the Clustered Cone Chart
Add a Chart Title Using the WordArt Tool
Add a Text Box, Arrow, & Brace to the Chart
Add a Header & Footer, Change Margins, & Center Printout Horizontally
Add a Header to the Clustered Cone Chart Sheet
Print all Worksheets in a Workbook
Print Nonadjacent Sheets in a Workbook
Insert and Remove a Page Break
Hide Page Breaks
Find a String
Replace a String with Another String
Search for and Open Workbooks
Create a Workplace File
Consolidate Data by Linking Workbooks


Project 6
In The Lab 3
Project 6 Online Practice Test
Project 6 Test
Project 6 Practicum
Study Guide
U SHOULD KNOW……
       Where         How
       EX 433
       EX 438
       EX 440
       EX 446
       EX 447
       EX 449
       EX 451
       EX 457
       EX 465
       EX 466
       EX 469
       EX 472
       EX 475
       EX 476
       EX 476
       EX 478
       EX 479
       EX 481
       EX 483
       EX 486
       EX 488
       EX 489

    Date Completed
                                    WHAT YOU SHOULD KNO
Access Project 1
                                                 Where
Create a Database Using a Database               AC 13
Create a New Database                            AC 14
Define the Fields in a Table                     AC 24
Create a Table Using a Template                  AC 26
Change the Primary Key                           AC 28
Add Records to a Table                           AC 30
Close a Table                                    AC 35
Add Additional Records to a Table                AC 38
Preview & Print the Contents of a Table          AC 41
Create an Additional Table                       AC 44
Modify the Primary Key and Field Properties      AC 46
Add Records to an Additional Table               AC 49
Create a Report                                  AC 51
Print a Report                                   AC 56
Create Additional Reports                        AC 56
Create a Split Form                              AC 57
Use a Split Form                                 AC 58
Change Database Properties                       AC 60
Search for Access Help                           AC 62

                                              Date Completed
Project 1
In The Lab 3
Project 1 Online Practice Test
Project 1 Test
Project 1 Practicum
Study Guide
SHOULD KNOW……
                How
                                        WHAT YOU SHOULD KN
Access Project 2
                                                          Where
Use the Simple Query Wizard to Create a Query             AC 78
Use a Criterion in a Query                                AC 81
Print the Results of a Query                              AC 83
Create a Query in Design View                             AC 83
Add Fields to the Design Grid                             AC 85
Use Text Data in a Criterion                              AC 86
Use a Wildcard                                            AC 87
Use Criteria for a Field Not Included in the Results      AC 88
Create a Parameter Query                                  AC 90
Use a Number in a Criterion                               AC 93
Use a Comparison Operator in a Criterion                  AC 94
Use a Comparison Criterion Involving AND                  AC 95
Use a Comparison Involving OR                             AC 96
Clear the Design Grid                                     AC 98
Sort Data in a Query                                      AC 98
Omit Duplicates                                           AC 100
Sort on Multiple Keys                                     AC 101
Create a Top-Values Query                                 AC 102
Join Tables                                               AC 105
Change Join Properties                                    AC 108
Create a Report Involving a Join                          AC 109
Print a Report                                            AC 111
Restrict the Records in a Join                            AC 112
Use a Calculated Field in a Query                         AC 113
Change a Caption                                          AC 116
Calculate Statistics                                      AC 118
Use Criteria in Calculating Statistics                    AC 120
Use Grouping                                              AC 121
Create a Crosstab Query                                   AC 123

                                                       Date Completed
Project 2
In The Lab 3
Project 2 Online Practice Test
Project 2 Test
Project 2 Practicum
Study Guide
SHOULD KNOW……
                How

				
DOCUMENT INFO
Description: Microsoft Access Template Loan Amortization document sample