Microsoft Office 97 - Access 97 - A97B

Description This training series will teach you step by step the many powerful facets and functions of Access 97. Simply follow the expert instruction of Tom Badgett as he walks you through each step of Access increasing your understanding and efficiency. The straightforward, compact nature of this series will give you the understanding you need to master Access 97.

Course Outline

Module 1

Section A: Introduction

Section B: What is Access? • Various Uses • Data Table, Record, Field & Forms

Section C: Using Access • Opening Access & Creating Shortcut • Office Shortcut Bar & Customization • Document Centric • Way to Open Access • Placing Office Shortcut Bar on Screen • Tour of Screen • Different Views & Uses of Access Screens • Forms Tab • Data Table Relationship

Section D: Creating a Database • Database Design • Building a Table • Transaction Table & Type • Entering Records • Analyzer Wizard • Database Wizard

Section E: Creating Forms • Using Autoform • Form Wizard • Positioning Objects on Forms

Section F: Creating Queries • Query Wizard

Section G: Creating Reports • Report Wizard • Print Wizard

Section H: Access & The World Wide Web • Web Toolbar • Help off the Web • HTML Wizard & Placement on the Web

Module 2

Section A: Introduction

Section B: Adding Tools • New Table • Modify Basic Design • Creating Relationships • Importing Tables • Link Tables

Section C: Modifying Tables & Table Properties • Field Properties • Add a Row

Section D: Complex Forms • Move Fields • Add a Field • Add a Field List • Add a Combo Box • Split Up a Form into Two Areas • Tab Object

Section E: Data Search & Filters • Understanding Searches & Filters • Sort Options • Edit Fields • Finding a Specific Record

Section F: Building Complex Queries • Building a Quick Query Group By Query • Query By Sum

Section G: Modifying Reports • Changing Report Design • Display Properties

Section H: Special Reports • Mail Merge • Managing Merged Document Print

Section I: Printing Access Data • Print Preview • Install a Print Driver

Module 3

Section A: Introduction

Section B: Cross Tab Queries Using Wizard • Building a Query From Other Queries

Section C: Action Queries • Editing & Updating Using a Query • Creating a Backup • Make Table Query Using Multiple Tables • Append Query • Delete Query • Creating an Expression Using • Query Creating a Report From Various Tables • Creating a Formula & Troubleshooting Functions/Expression • Builder IIF Function

Section D: Access & Other Applications • Export from Access to Word • Export from Access to Excel • Import Spreadsheet Wizard • Insert Object

Section E: Customizing Access • Toolbars & Menus Icons, Menu Animation & Keyboard • Network Settings • Switchboard Manager

Section F: Macros • Creating Macro • Names & Keystrokes • Assigning Macros to Buttons

Section G: Security & Backup • Copying to Same Drive or Disk • Creating a Password • Users & Groups

Section H: HTML & Hyperlinks • Internet Assistant & Wizard • Convert to HTML & Search Hyperlinks in a Table • Hyperlinks in a Form

Price £ 358 (Bundle of 3)

Complementary Courses
Word 97
Excel 97
Powerpoint 97
Outlook 98
Office 97 Bundle

<<Back <<Contact Us