Course Title: Microsoft Access 97
To get started, simply click one of the topics below.
Course Author/Expert: John Baddeley
Language: english
Full Online Training Available: Yes
Number of Course Movies: 138
Course Duration: 8 hours
Never has it been so easy to learn Microsoft Access 97.
No expensive classroom training courses.
No boring hard to follow books to read.
Learn from your own desk at a pace that suits you.
High quality affordable training that is easy to use and follow.
Use unique training methods, it makes learning easy no matter what your learning style.
Course Outline:
Straight away, you can go through the first three chapters of this tutorial. If you need all the lessons, then join the Online University - complete access to over five hundred and fifty courses right now for as long as you need them and even get an online university certificate. See below for details.
01 Introduction
0101 Introduction
0103 Design Basics
0104 Example Databases
0105 The 6 Access Objects
0106 One to Many Relationships
02 Access Basics
0201 Starting Access97
0202 Screen Tips
0203 Keyboard Setup
0204 Accessing Help
0205 Help Menu
0206 The Office Assistant
0207 Setting Option
03 Table Structure & Data Types
0301 The Structure of a Table
0302 Data Types
04 Field Properties
0401 Intro/Field Size
0402 Format
0403 Input Mask
0404 Caption
0405 Default Value
0406 Validation Rule/Text
0407 Required
0408 Indexed
0409 Primary KeY
05 Working with an Existing DB
0501 Open an Existing Database
0502 Passwords
0503 Relationships
0504 Documenter
06 Working in DataSheet View
0601 DataSheet View
0602 Sort & Find
0603 Filter by Selection
0604 Filter by Form
0605 Saving a Filter
0606 Navigating DataSheets
0607 Adjust Column Width
0608 Freeze/Unfreeze
0609 Appearance
0610 Data Entry
0611 Delete, Copy, Paste
0612 Printing DataSheets
0613 Save & Close DataSheets
07 Using Forms
0701 Introduction to Forms
0702 Form Design Basics
0703 Form Types
0704 Form Views
0705 Data Entry using Forms
0706 Printing Forms
0707 Save and Close Forms
0708 Pop-up and Modal Forms
08 Using Queries
0801 Introduction to Queries
0802 Query Types
0803 Query DataSheet View
0804 Query Design View
0805 SQL View
0806 Saving Queries
09 Using Reports
0901 Introduction to Reports
0902 Viewing a Report
0903 Report Types
0904 Printing Reports
10 Create a New Database
1001 Database Structure
1002 Create a Database
11 Creating Tables
1101 Ways to Create a Table
1102 Creating Fields
1103 Setting Properties
1104 Adding Fields
1105 Setting a Primary Key
1106 Lookup Wizard
1107 Table Wizard
1108 The Contacts Table
12 Setting up Relationships
1201 Relationship - Why?
1202 Prerequisites
1203 The Relationships Window
1204 Referential Integrity
13 Creating Forms
1301 Create Forms Manually
1302 Autoforms
1303 Forms Wizards
1304 Form Design Facilities
1305 Controls Overview
1306 Moving & Sizing Controls
1307 Formatting Controls
1308 Alignment
1309 Add & Delete Controls
1310 Changing Form Size
1311 Headers & Footers
1312 Calculations (1)
1313 Calculations (2)
1314 Calculations(3)
1315 Creating Command Buttons
1316 Add a Combo-box
1317 Create a Main & SubForm
14 Creating Queries
1401 Introduction to Queries
1402 New Query Options
1403 Query Design View
1404 Adding fields to QBE grid
1405 Adding a Table
1406 Running Queries
1407 Sorting in a Query
1408 Entering Criteria
1409 Ranges in Criteria
1410 Tips on Criteria
1411 More Tips on Criteria
1412 And/Or
1413 Calculated Fields
1414 Names & Numbers Query
1415 Saving Queries
1416 Parameter Queries
1417 Totals Queries
1418 Expression Builder
15 Creating Reports
1501 Introduction to Reports
1502 Creating Reports
1503 Report Design View
1504 Sorting & Grouping
1505 More Sorting and Grouping
1506 Layout Problems
1507 Layout Problems, continued
1508 Mailing Labels
1509 Adding Calculated Fields
1510 Adding Group Totals
1511 Adding Sum Totals
16 External Data
1601 Introduction
1602 Importing Data
1603 Importing from Excel
1604 Mailmerging with Word
1605 Linking/Attaching Tables
17 Replication
1701 Replication Introduction
1702 Replication Help
1703 Considerations
18 Security/Backing Up
1801 Security Introduction
1802 Further Information
1803 Everything about backing up
19 Macros
1901 Macro Introduction
1902 Example Macro
1903 Conditional Macros
20 Publish on the Web
2001 Introduction
2002 The Web Wizard
2003 View the Web Page
21 Switchboards
2101 Create a Switchboard
2102 Add Buttons
2103 Improve Appearance
To continue your learning, Click Here for the Online University and get access to all of the training courses, that's over 550 software programmes including 60,000 tutorial videos, for editing, image manipulation and graphics programmes. All for just $30 (approx £16) month. Unlimited access for as long as you need, cancel when you're finished, no contract, no minimum period, no hassle.
or
Click Here and we'll send you the training CD itself for Microsoft Access 97 at £79.95
|
|
Add latest courses to Google Toolbar