Microsoft Access 2003 Complete Courseware Courseware and Training Materials

What's included?
What’s included?
Available for delivery as a download from our web server or provided on CD, this courseware package includes the following resources to make your trainer’s life much, much easier.

This courseware package includes:

	Student Manual. Fully customisable. May be opened in any wordprocessor and changed to meet your exact needs.
	Student workbook. Fully customisable. Additional book includes series of practical tasks and review questions.
	Student workbook exercises. Fully customisable. Sample exercises to accompany the student workbook.
	Trainer manual. Fully customisable with additional information for trainers.
	Timetable and lesson plans. Fully customisable. Detailed timetable and plans ensure you deliver the best possible course.
	PowerPoint presentations. Fully customisable. Complete set of PowerPoint slides for use by the trainer.

To get started, just open this ‘Microsoft Access 2003′ training courseware in your favourite word processor. You can fully customise the materials to suit your exact learning needs and include your own branding. Your own tailor-made course, delivered ‘off-the-peg’ and saving you thousands of pounds in development time and man-hours. Just press print and the perfect learning experience is yours to deliver.

Course outline
Course outline

Course contents: Foundation level

• Starting Out What is Microsoft Access? — What’s New in Access 2003? — Basic Terminology — Opening Microsoft Access — Interface Overview — Closing Microsoft Access
• 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
• 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
• First Steps Planning a Database — Creating a Blank Database — Using 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 Using the Zoom Toolbar — Selecting Data — Cutting, Copying, and Pasting — Using the Format Painter — Using Undo and Redo — Checking your Spelling
• Formatting Controls Changing the Colour of a Control — Using Control Properties — Aligning Controls — Applying Special Effects
• 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
• 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 Using the View Menu — Using the Window Menu — Hiding and Unhiding Windows — Arranging Windows — Closing Individual Windows
• Printing a Database Object Using the Print Icon — Using Print Preview — Using Page Setup

Course contents: Intermediate level

• Using My Computer within Access Navigating with My Computer — Performing Basic Tasks with My Computer — Changing Views with My Computer — Using the My Places Toolbar
• Database Management Repairing a Database — Compacting a Database — Backing up Your Database — Editing Database Properties
• Saving Your Files the Save As Dialogue — Using Object Properties — Using AutoRecover
• Exporting Files Exporting to Word — Exporting to Excel — Exporting to Older Versions of Access — Exporting vs. Save As
• Linking Files Linking to an Excel Spreadsheet — Linking to Another Database — Creating a Hyperlink — Inserting an OLE Object
• Customizing Tables Understanding Field Properties — Adding a Primary Key to a Table — Indexing a Field — Inserting, Deleting, and Moving Fields — Importing a Table from Another Source
• Formatting Tables Formatting Number Fields — Formatting Text Fields 70 — Field Descriptions — Changing Field Data Types — Adding Captions
• Controlling Table Data Entry Setting a Default Value — Setting a Required Value — Creating and Using Input Masks — Creating and Removing Table Relationships
• Managing Table Data Entry How to Validate Data — Creating a Lookup Field — Modifying a Lookup Field — Creating a Value List — Modifying a Value List
• Basic Form Controls Adding a Control — Using the Control Wizard — Cutting, Copying, Pasting, and Moving a Control — Formatting a Contro
• Advanced Form Controls Modifying a Control’s Properties — Changing a Control’s Data Source — Changing a Control’s Default Value — Creating a Calculated Control — Using Form Properties
• Formatting a Form Formatting Gridlines — Modifying the Font — Adding Images — Using AutoFormat
• Organizing Report Data Adding and Removing Fields — Using Report Sections — Changing Section Properties — Grouping and Sorting in a Report — Changing Group Properties — Using Calculated Controls in a Report
• Formatting Reports Formatting Gridlines — Modifying the Font — Adjusting the Layout of your Report — Using AutoFormat
• Common Report Tasks Adding a Photo — Adjusting Page Properties — Adding Headers and Footers — Adding Page Numbers — Using the Label Wizard
• Basic Queries Review of Queries — Creating a Query — Sorting a Query — Filtering a Query — Hiding Fields — Using AND/OR Operators — Using IIF Functions
• Multiple Table Queries Creating a Multiple Table Query — Creating a Calculated Field — Using the Expression Builder — Using Queries to Summarize — Using Make-Table Queries
• Management (Action) Queries Append Queries — Delete Queries — Update Queries — Exporting Queries

Course contents: Advanced level

• Customizing Menus and Toolbars Customizing Menus — Creating Menus — Showing and Hiding Toolbars — Customizing Toolbars — Creating Toolbars
• Setting Access Options, Part 1 Setting General and View Options — Setting Editing and Keyboard Options — Setting Datasheet, Form, and Report Options — Setting Page and Tables/Queries Options — Setting Error Checking Options — Setting Advanced Options
• Setting Access Options, Part 2 Setting International Options — Setting Spelling Options — Setting AutoCorrect Options — Setting Start-Up Options — Setting Macro Security Options
• Creating Macros Using the Macro Design Toolbar — Creating a Macro — Running a Macro — About Macro Groups
• Advanced Macro Uses Editing a Macro With the Visual Basic Editor — Assigning a Macro to a Keystroke — Assigning a Macro to a Toolbar — Viewing and Printing Macro Definitions
• Switchboards Using a Switchboard — Using the Switchboard Manager — Creating a Switchboard — Editing a Switchboard — Deleting a Switchboard
• Creating Data Access Pages Using the Data Access Page Wizard — Using Design View to Create a Data Access Page — Using an Existing HTML Page
• Modifying Data Access Pages Adding a Theme — Adding Text and Controls — Formatting Text and Controls — Aligning and Sizing Content — Adding Images
• Using Data Access Pages Basics of Using Data Access Pages — Viewing Data Entered Via a Data Access Page — Protecting Data
• Table Relationships Normalizing Your Data — Establishing Referential Integrity — Using Cascade Update and Cascade Delete — Setting Fields for Indexing — Using Indexing
• Using CrossTab Queries Understanding CrossTab Queries — Creating a CrossTab Query Using the Wizard — Creating a CrossTab Query Manually
• Using Parameter Queries Setting Up Parameter Queries — Using a Parameter Query
• Advanced Reporting Features Using AutoFormat — Aligning and Formatting Controls — Adding Pictures and Lines
• Creating a PivotTable Creating a PivotTable Using the Wizard — Continuing Where the Wizard Left Off — More About Fields — Completing Your PivotTable
• Using AutoForm and Creating PivotCharts Creating a PivotTable Using AutoForm — Creating a PivotChart Using AutoForm — About PivotChart Fields — Completing A PivotChart
• Using PivotTables and PivotCharts Using a PivotTable — Using a PivotChart — Editing a PivotTable or PivotChart — Common PivotChart Editing Features — Turning a PivotTable Into a PivotChart and Vice-Versa

FAQs

No FAQs specifically for this title have been uploaded yet. Please check out the Product FAQs for general questions about the products.