|
Provided by: Computer Training Source, Inc. Microsoft Access AdvancedAccess |
 |
In this class you ll learn the principles of table relationships; advanced query techniques; an introduction to functions, macro actions, advanced form techniques including using macros in forms; database security, and advanced report techniques. 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.
|
|
||||||||
Training
Provided by Computer Training Source, Inc.
Microsoft Access Advanced
Lesson 1 - Modifying Tables
Looking At This Course
Examining The Projects
Using Validation
Modifying Input Masks
Creating Lookup Fields
Optimizing Data Type Usage
Follow-up
Lesson 2 - Defining Relationships
Assigning Multiple-field Primary Keys
Establishing One-to-one Relationships
Establishing Many-to-many Relationships
Defining Cascade Updates And Deletes
Specifying Join Properties
Follow-up
Lesson 3 - Modifying Forms
Creating Forms In Design View
Modifying Control Properties
Customizing Form Sections
Modifying Form Properties
Using The Subform Control
Creating Switchboards
Follow-up
Lesson 4 - Refining Queries
Modifying Queries
Creating Totals Queries
Creating Parameter Queries
Creating Action Queries
Modifying Query Properties
Looking At Optimizing Queries
Follow-up
Lesson 5 - Producing Reports
Creating Reports In Design View
Modifying Report Properties
Modifying Control Properties
Setting Section Properties
Using The Subreport Control
Follow-up
Lesson 6 - Working With Macros
Understanding Macros
Running Macros
Creating Macros
Setting Startup Options
Follow-up
Lesson 7 - Utilizing Web Capabilities
Understanding The Web
Creating Data Access Pages
Grouping And Sorting Data Access Pages
Creating Hyperlinks
Follow-up
Lesson 8 - Using Access Tools
Using The Table Analyzer Wizard
Replicating Databases
Using Database Security
Using The Database Splitter
Using The Linked Table Manager
Converting Databases
Follow-up
Lesson 9 - Integrating Access
Dragging-and-dropping Data
Exporting Data To Excel
Creating Data Charts
Linking Existing Data
Follow-up
Lesson 10 - Application Project
Develop A Database
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
Looking At This Course
Examining The Projects
Using Validation
Modifying Input Masks
Creating Lookup Fields
Optimizing Data Type Usage
Follow-up
Lesson 2 - Defining Relationships
Assigning Multiple-field Primary Keys
Establishing One-to-one Relationships
Establishing Many-to-many Relationships
Defining Cascade Updates And Deletes
Specifying Join Properties
Follow-up
Lesson 3 - Modifying Forms
Creating Forms In Design View
Modifying Control Properties
Customizing Form Sections
Modifying Form Properties
Using The Subform Control
Creating Switchboards
Follow-up
Lesson 4 - Refining Queries
Modifying Queries
Creating Totals Queries
Creating Parameter Queries
Creating Action Queries
Modifying Query Properties
Looking At Optimizing Queries
Follow-up
Lesson 5 - Producing Reports
Creating Reports In Design View
Modifying Report Properties
Modifying Control Properties
Setting Section Properties
Using The Subreport Control
Follow-up
Lesson 6 - Working With Macros
Understanding Macros
Running Macros
Creating Macros
Setting Startup Options
Follow-up
Lesson 7 - Utilizing Web Capabilities
Understanding The Web
Creating Data Access Pages
Grouping And Sorting Data Access Pages
Creating Hyperlinks
Follow-up
Lesson 8 - Using Access Tools
Using The Table Analyzer Wizard
Replicating Databases
Using Database Security
Using The Database Splitter
Using The Linked Table Manager
Converting Databases
Follow-up
Lesson 9 - Integrating Access
Dragging-and-dropping Data
Exporting Data To Excel
Creating Data Charts
Linking Existing Data
Follow-up
Lesson 10 - Application Project
Develop A Database
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 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, Northbrook, and Schaumburg). Instructor-led distance...
