Microsoft Access Intermediate
Access
Training
Provided by Computer Training Source, Inc.
In this class you ll learn how to use action queries, use calculated fields, adjust data types, set field properties, and perform database maintenance. You will also use input masks, use controls in forms, learn the lookup feature, work with Access and the Internet, and work further with queries and 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 Intermediate
Looking At This Course
Examining The Projects
Examining Tables In Design View
Modifying Tables In Design View
Adjusting Data Types
Changing Field Properties
Using Default Values
Exploring Indexes
Follow-up
Looking At The Office Clipboard
Copying And Pasting Data
Understanding The Lookup Wizard
Using The Input Mask Wizard
Follow-up
Exploring Form Sections
Using Form Sections
Binding Controls And Data
Using Calculated Controls
Adding Other Controls
Follow-up
Using The Query Wizard
Adding Tables And Fields
Specifying Criteria
Working With Query Fields
Creating Action Queries
Creating Calculated Fields
Follow-up
Using Report Sections
Modifying Report Controls
Changing Format Properties
Adding Controls
Using Calculated Controls
Follow-up
Understanding Access On The Web
Creating Web Documents
Understanding Hyperlinks
Follow-up
Backing Up Databases
Compacting And Repairing Databases
Using Name AutoCorrect
Printing Database Objects
Follow-up
Sales Project
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 - Expanding Tables
Looking At This Course
Examining The Projects
Examining Tables In Design View
Modifying Tables In Design View
Adjusting Data Types
Changing Field Properties
Using Default Values
Exploring Indexes
Follow-up
Lesson 2 - Working With Data
Looking At The Office Clipboard
Copying And Pasting Data
Understanding The Lookup Wizard
Using The Input Mask Wizard
Follow-up
Lesson 3 - Modifying Forms
Exploring Form Sections
Using Form Sections
Binding Controls And Data
Using Calculated Controls
Adding Other Controls
Follow-up
Lesson 4 - Creating Queries
Using The Query Wizard
Adding Tables And Fields
Specifying Criteria
Working With Query Fields
Creating Action Queries
Creating Calculated Fields
Follow-up
Lesson 5 - Customizing Reports
Using Report Sections
Modifying Report Controls
Changing Format Properties
Adding Controls
Using Calculated Controls
Follow-up
Lesson 6 - Working With HTML And Hyperlinks
Understanding Access On The Web
Creating Web Documents
Understanding Hyperlinks
Follow-up
Lesson 7 - Looking At Database Maintenance
Backing Up Databases
Compacting And Repairing Databases
Using Name AutoCorrect
Printing Database Objects
Follow-up
Lesson 8 - Application Project
Sales Project
Lesson 9 - 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...
