Table of Contents

Table of Contents


SECTION 1:	Starting Out
Lesson 1.1	Starting Out What is Microsoft Access What is new in Access 2003 Basic Terminology Opening Microsoft Access Interface Overview Closing Microsoft Access Practice Exercise
Lesson 1.2	Using The Access Interface Using The Access Menus Using Access Task Panes Using Toolbars Adding, Removing, And Moving Toolbars Using The Switchboard Using The Database Window Practice Exercise
Lesson 1.3	Getting Help Using The Help Menu Using The Help Task Pane Using The Office Assistant Configuring The Office Assistant Using The Type A Question Box Getting Help In A Dialog Box Using The Sample Databases Practice Exercise

SECTION 1:	Review Questions

SECTION 2:	Creating A Database
Lesson 2.1	First Steps Planning A Database Creating A Blank Database Using Database Objects Practice Exercise
Lesson 2.2	Records What Is A Record? Adding Records Editing Records Deleting Records Printing Records Practice Exercise
Lesson 2.3	Creating A Table About Tables Creating A Table In Design View Creating A Table Using The Wizard Entering Data Into A Table Formatting A Table Practice Exercise
Lesson 2.4	Formatting Text Using The Zoom Toolbar Selecting Data Cutting, Copying And Pasting Using The Format Painter Using Undo And Redo Checking Your Spelling Practice Exercise
Lesson 2.5	Formatting Controls Changing The Color Of A Control Using Control Properties Aligning Controls Applying Special Effects Practice Exercise
SECTION 2:	Review Questions

SECTION 3:	Doing More With Your Database
Lesson 3.1	Creating Forms What Is A Form? Bound Vs Unbound Controls Creating A Form With The Wizard Creating A From In Design View Using Forms Practice Exercise
Lesson 3.2	Creating Queries What Is A Query? Creating A Query With The Wizard Using Design View To Modify A Query Using Queries Practice Exercise
Lesson 3.3	Reports What Is A Report? Creating A Report With The Wizard Creating A Report In Design View Using Reports Practice Exercise
Lesson 3.4	Sorting And Filtering Data Using Find And Replace Sort Ascending Or Descending Using Filter By Form Using Filter By Selection Creating A Filter Practice Exercise
SECTION 3:	Review Questions

SECTION 4:	Viewing And Printing Your Data
Lesson 4.1	Formatting A Data Sheet Adjusting Row Height And Column Width Rearranging Columns Freezing A Row Or Column Hiding A Column Changing The Datasheet Font Practice Exercise
Lesson 4.2	Viewing Data Using The View Menu Using The Window Menu Hiding And Unhiding Windows Arranging Windows Closing Individual Windows Practice Exercise
Lesson 4.3	Printing A Database Object Using The Print Icon Using Print Preview Using Page Setup Practice Exercise
SECTION 4:	Review Questions