Microsoft Access Introduction
Access
Training
Provided by Computer Training Source, Inc.
Microsoft s most popular database. You ll learn to design a database, create tables, use forms, use filters, enter and correct information, perform queries by using practical examples and create reports. Our classes are all instructor-led, hands-on learning. Each student has their own computer and is given a student manual with practice files to take home. A free repeat, within six months, is included as well as thirty days of technical support. Class is usually one day from 9am to 4pm (unless it& 39;s an evening class or an accelerated class). Click on any class date below to view a class outline.
|
|
||||||||||
Microsoft Access Introduction
Looking At Access
Examining The Projects
Understanding Database Design
Using Database Wizards
Exploring A Database
Using the Office Assistant
Closing Access
Follow-up
Understanding Tables
Using Design View
Saving And Closing Tables
Opening A Table
Modifying Columns And Rows
Using The Table Wizard
Working With Field Properties
Follow-up
Entering Data
Importing Data
Importing Data To A New Table
Sorting Data
Deleting Data
Follow-up
Establishing Relationships
Enforcing Referential Integrity
Printing And Saving Relationships
Using Subdatasheets
Follow-up
Understanding Forms
Using The Form Wizard
Entering Data In A Form
Working In Design View
Formatting Form Controls
Follow-up
Finding Records
Filtering By Selection
Filtering By Form
Sorting Filtered Records
Follow-up
Understanding Queries
Creating Single-table Queries
Using The Query Wizard
Creating Multi-table Queries
Follow-up
Understanding Reports
Creating AutoReports
Using The Report Wizard
Previewing Multiple Pages
Printing Reports
Follow-up
Create An Employee Database
Using The Help Window
Using The Contents Card
Using The Answer Wizard
Working With The Index
Using Context-sensitive Help
Follow-up
Database Tools
Table Datasheet Tools
Table Design Tools
Query Design Tools
Report Design Tools
Formatting (Form/Report Design) Tools
Toolbox Tools
Web Tools
Print Preview Tools
Navigation Shortcuts
Lesson 1 - Introducing Access
Looking At Access
Examining The Projects
Understanding Database Design
Using Database Wizards
Exploring A Database
Using the Office Assistant
Closing Access
Follow-up
Lesson 2 - Working With Tables
Understanding Tables
Using Design View
Saving And Closing Tables
Opening A Table
Modifying Columns And Rows
Using The Table Wizard
Working With Field Properties
Follow-up
Lesson 3 - Working With Data
Entering Data
Importing Data
Importing Data To A New Table
Sorting Data
Deleting Data
Follow-up
Lesson 4 - Creating Relationships
Establishing Relationships
Enforcing Referential Integrity
Printing And Saving Relationships
Using Subdatasheets
Follow-up
Lesson 5 - Using Forms
Understanding Forms
Using The Form Wizard
Entering Data In A Form
Working In Design View
Formatting Form Controls
Follow-up
Lesson 6 - Filtering Data
Finding Records
Filtering By Selection
Filtering By Form
Sorting Filtered Records
Follow-up
Lesson 7 - Exploring Queries
Understanding Queries
Creating Single-table Queries
Using The Query Wizard
Creating Multi-table Queries
Follow-up
Lesson 8 - Creating Reports
Understanding Reports
Creating AutoReports
Using The Report Wizard
Previewing Multiple Pages
Printing Reports
Follow-up
Lesson 9 - Application Project
Create An Employee Database
Lesson 10 - Using Help Appendix
Using The Help Window
Using The Contents Card
Using The Answer Wizard
Working With The Index
Using Context-sensitive Help
Follow-up
Lesson 11 - Common Tools And Shortcuts Appendix
Database Tools
Table Datasheet Tools
Table Design Tools
Query Design Tools
Report Design Tools
Formatting (Form/Report Design) Tools
Toolbox Tools
Web Tools
Print Preview Tools
Navigation Shortcuts
About The Training Provider: Computer Training Source, Inc.
Computer Training Source, Inc. - Computer Training Source, Inc. has offered computer training classes in Chicago, Il and New York, NY since 1991. We specialize in instructor-led training in all the popular desktop software applications. Training can be held at our training centers, at your location, or via the Internet. We have training rooms in the Chicago area (downtown, Naperville, and Schaumburg), and in the New York area...
