Microsoft Access 2003 Introduction

This intensive, hands-on training course is designed to give delegates an understanding of some of the major features and functions within Microsoft Access.

Course Aims

This intensive, hands-on training course is designed to give delegates an understanding of some of the major features and functions within Microsoft Access. An introduction to database theory and practice, plus hints and tips on good database design techniques are also given.

Who Should Attend?

New, recent or intending users of Access 2003 or XP who have little or no existing database knowledge. A basic understanding of PCs and familiarity with the layout of a PC style keyboard, mouse and Windows is required

Getting Started

Starting Out: • Basic Terminology • Opening Microsoft Access • Interface Overview • Closing Microsoft Access

Using the Access Interface: • UsingThe Access Menus • Access Task Panes • Using Toolbars • Adding, Removing, and Moving Toolbars • The Switchboard • Using the Database Window Getting Help: • The Help Menu • The Help Task Pane • The Office Assistant • Using the Type a Question Box • Getting Help in a Dialog Box • Using the Sample Databases
Creating a Database First Steps: • Planning a Database • Creating a Blank Database • Database Objects
Records: • What is a Record? • Adding Records • Editing Records • Deleting Records • Printing Records
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
Formatting Text: • The Zoom Toolbar • Selecting Data • Cutting, Copying, and Pasting • The Format Painter • Undo and Redo • Checking your Spelling Formatting Controls: • Changing the Colour of a Control • Control Properties • Aligning Controls • Applying Special Effects
Doing More with Your Database Creating Forms: • What is a Form? • Bound vs. Unbound Controls • Creating a Form with the Wizard • Creating a Form in Design View • Using Forms
Creating Queries: • What is a Query? • Creating a Query with the Wizard • Using Design View to Modify a Query • Using Queries
Reports: • What is a Report? • Creating a Report with the Wizard • Creating a Report in Design View • Using Reports
Sorting and Filtering Data: • Using Find and Replace • Sort Ascending or Descending • Using Filter by Form • Using Filter by Selection • Creating a Filter
Viewing and Printing Your Data Formatting a Datasheet: • Adjusting Row Height and Column Width • Rearranging Columns • Freezing a Row or Column • Hiding a Column • Changing the Datasheet Font
Viewing Data: • The View Menu • The Window Menu • Hiding and Unhiding Windows • Arranging Windows • Closing Individual Windows
Printing a Database Object: • The Print Icon • Print Preview • Page Setup