Access 2000 (Program Details)
COURSE OUTLINE
Session 1
Section A: Introduction
- Uses for a Database
- Access & Other Office Applications
- Understanding & Comparing Tables
- Creating a New Database
Section B: Creating an Attribute Table
- Datasheet View
- Design View
- Entering Values
- Datasheet Features
- Print Preview
- Access vs. Excel
- Saving Design Changes
Section C: Creating a Lookup Table
- Creating a New Table
- Creating a Primary Key
- Creating a Relationship Between Tables
- Cascade Update & Deletes
- Entering Data in a Sub-form
- Creating a Lookup to a Text Key
Section D: Creating Queries
- Sorting & Filtering
- Save as a Query
- Editing a Query in Design View
- Using the Query Wizard to Join Tables
- Changing Values in a Query
Section E: Creating Forms
- Create an AutoForm
- Columnar, Datasheet & Tabular Forms
- Printing Form
Section F: Creating a Measures Table
- Designing a Measures Table
- Using Automatic & Primary Keys
- Specifying Column Data Types
- Creating a Lookup
- Preventing Duplicate Keys
- Relating Tables
Section G: Creating Summary Queries
- Creating Summary Queries
- Crosstab Queries
Section H: Creating Reports
- Create a Tabular Report
- Using the Report Wizard
- Editing the Report
Section I: Discovering More
- Customize Access
- Using the Office Assistant & Help Window
Session 2
Section A: Designing a Database
- Introduction
- Field Names
- Keys
Section B: Importing & Exporting Tables
- Importing from Access
- Exporting
- Copying To & From Excel
Section C: Customizing Field Definitions
- Field Features
- Order Detail Table
Section D: Extending Queries
- Making a New Query
- Filters & Criteria
- Add a Field
Section E: Creating Action Queries
- Create New Query
- Modify Query
- Update Action Query
- Delete Query
Section F: Managing a Database
- Suggestions
- Database Security
- Synchronization
- Linking Databases
Section G: Improving Database Design
- Table Indexes
- Relationships
- Splitting Tables
Session 3
Section A: Creating Report Details
- Creating Forms & Reports
- Queries in Design View
- Creating Reports in Design View
- Linking Reports to Queries
- Altering Labels
- Adding Files
- Converting Text Boxes to Labels
- Refining Label Location
Section B: Creating Report Groupings
- Sorting & Grouping
- Creating Extended Price
- Adding Text Boxes
- Forcing New Pages
- Formatting Reports
Section C: Enhancing the Layout of a Report
- Creating a Page Header
- Adding Logos & Images
- Header & Cover Page Options
Section D: Creating Form Details
- Form & Report Differences
- Copying Controls & Labels
- Headers & Footers
- Linking Data
- Changing Unit Price
- Altering Form List
- Locking & Enabling Form Changes
- Changing Product Name
- Adding a Calculated Field
Section E: Creating Form Grouping
- Renaming & Creating Forms
- Adding & Arranging Controls
- Adding Subforms
Section F: Enhancing the Layout of a Form
- Controlling the Form & Subform Display
Section G: Displaying Data in a Chart
- Creating a Chart
Section H: Automating Access
- Adding Form Controls
- Adding a Graphic Image
- Using the Macro Builder
- Creating a Switchboard
- Splitting the Database
Section I: Integrating with the Internet
- Creating a Hyperlink
- Exporting Queries to HTML Documents
- Creating a Data-access Page
Section J: Tips for the Certification Test
- Key Exam Points
Return To Main Product Page
Price: £149.00
(incl. VAT and Delivery)
for Single User Licence
