Course Title: Microsoft Access 2000
Microsoft Access 2000 gives you powerful new tools for managing your data. You can share your database with coworkers over an intranet, find and retrieve information quickly, and take advantage of pre-packaged automated solutions to quickly create databases. In Virtual Training Company's tutorial, author Lorie Flenner begins very basic, explaining the key concepts behind Access and relational database theory. Go through using an existing database, then smoothly into creating a new database and new forms, queries, and reports. Click any of the topics below to get started right away.
Course Author/Expert: Angie Rawling/NMG
Language: english
Full Online Training Available: Yes
Number of Course Movies: 132
Course Duration: 12 hours
Never has it been so easy to learn Microsoft Access 2000.
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:
The FIRST THREE chapters of this online training course can be viewed right now!
Click Here Now To View the First Three Chapters of Microsoft Access 2000 Online Training For Free
If you then need all the lessons or complete access to over seven hundred different courses then join the online university for as long as you need them and even get an online university certificate.
Introduction
Introduction
Design Basics
Example Databases
The 7 Access Objects
Relationships
Access Basics
Starting Access 2000
Screen Tips
Keyboard Setup
Accessing Help
The Office Assistant
Setting Options
Table Strcuture and Data Types
The Structure of a Table
Data Types
Field Properties
Intro/Field Size
Format
Input Mask
Caption
Default Value
Validation Rule/Text
Required
Indexed
Primary Key
Working with an Existing Database
Open an Existing Database
Passwords
Relationships
Documenter
Working in Datasheet View
DATASHEET VIEW
Sort & Find
Filter by Selection
Filter by Form
Save a Filter
Navigating Data Sheets
Adjust Column Width
Freeze & Unfreeze
Appearance
Data Entry
Delete, Copy, Paste
Printing Datasheets
Selecting Records To Print
Using Forms
Introduction to Forms
Form Design Basics
Form Types
Form Views
Data Entry Using Forms
Printing Forms
Save & Close Forms
Pop-up & Modal Forms
Using Queries
Intro to Queries
Query Types
Query Views
Calculation Queries
Saving Queries
Usign Reports
Intro to Reports
Viewing a Report
Report Types
Printing a Report
Create a New Database
Database Structure
Create a Database
Creating Tables
Ways to Create a Table
Creating Fields
Setting Properties
Adding Fields
Setting a Primary Key
Lookup Wizard
Table Wizard
The Contacts Table
Setting up Relationships
Relationships - Why?
Prerequisites
The Relationships Window
Referential Integrity
Creating Forms
Create Forms Manually
Auto Forms
Form Wizard
Form Design Facilities
Form Controls Overview
Moving & Sizing Controls
Formatting Controls
Alignment
Add & Delete Controls
Changing Form Size
Headers & Footers
Create a Main and Sub-Form
Calculations (1)
Calculations (2)
Creating Command Buttons
Add a Combo Box
Creating Queries
Intro to Queries
New Query Options
Query Design View
Adding Fields to QBE Grid
Adding a Table
Running Queries
Sorting in a Query
Entering Criteria
Ranges in Criteria
Tips on Criteria
More Tips on Criteria
AND/OR
Calculated Fields
Saving Queries
Parameter Queries
Totals Queries
Expression Builder
Creating Reports
Intro to Reports
Creating Reports
Report Design View
Sorting & Grouping
Layout Problems
Mailing Labels
Adding Calculated Fields
Adding Group Totals
Adding Sum Totals
Creating Data Access Pages
Intro to Pages
Creating Pages
Use the Page Wizard
Accessing Data from the Web
External Data
Introduction
Importing Data
Importing from Excel
Mail Merging with Word
Linking & Attaching Tables
Replication
Replication Overview
Setting Up Replicas
Types of Security
User-Level Security Wizard
Backing Up Data
Macros
Introduction
Example Macro
Conditional Macros
Switchboards
Create a Switchboard
Add Buttons
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 2000 at £79.95
|
|
Add latest courses to Google Toolbar