|
|
|
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
|
MICROSOFT ACCESS 2007
|
|||||||
|
Level 1: Beginner |
Level 2: Intermediate |
Level 3: Advanced
|
Level 4: XML & VBA |
||||
|
Exploring Access: Database Concepts, Explore User Interface Design a Database: Relational Database Design, Review Existing Data, Group Fields into Tables, Designate Primary & Foreign Keys, Understand Relationships Building a Database: Create a New Database, Create & Manage Tables, Create Table Relationships Managing Data in a Table: Modify Table Data, Sort Records, Subdatasheets Querying a Database: Filter Records, Create Query, Add Query Criteria, Add Calculated Field to Query, Grouping Designing Forms: Create Form, Use Form Wizard, Modify Form Design Generating Reports: Create a Report, Use Report Wizard, Add Calculated Field to Report, Format Report |
Control Data Entry: Restrict Data Entry Using Field Properties, Establish Patterns for Field Values, Create List Values Joining Tables: Create Query Joins, Join Unrelated Tables, Relate Data Within Table Creating Flexible Queries: Set Query Properties, Create Parameter & Action Queries Improving Forms: Change Design Layout, Restrict Data Entry, Add Command Buttons, Create SubForms Customizing Reports: Set Control Properties, Pagination, Create Summary, SubReport, Mailing Labels
Sharing Data: Import & Export Data,
Analyze Data in MS Excel, Export to Text File, Merge With MS Word |
Structure Existing Data: Analyze Tables, Create Junction Table, Improve Table Structure Writing Advanced Queries: SubQueries, Unmatched & Duplicate Queries, Group & Summarize Records, Crosstab Query, PivotTable & Pivot Chart Macros: Create & Attach Macros, Restrict Records Using a Condition, Validate Data Using Macro, Automate Data Entry Using Macro Making Effective Forms: Display Calendar on a Form, Use Tab Pages, Display Summary of Data Making Effective Reports: Add Chart, Columns, Create Report Snapshot Maintain Database: Link Tables to External Data, Determine Object Dependency, Analyze Performance
|
Integrating Access into Your Business: Import XML Data, Export Access Data to XML Format, Export Data to the Outlook Address Book, Collect Data Through Email Messages Automating a Business Process with VBA: Create a Standard Module, Develop Code, Call a Procedure from a Form, Run the Procedure Managing Switchboards: Create a Database Switchboard, Modify Database Switchboard, Set the Startup Options Distributing and Securing Databases: Split a Database, Implement Security, Set Passwords. Convert an Access Database to an ACCDE File, Package Database with a Digital Signature Sharing Databases Using a SharePoint Site: Export a Table to a SharePoint List, Import Data from a SharePoint List, Publish a Database to a SharePoint Site, Move a Database to a SharePoint Site, Work Offline |
||||
|
Each level is a 6-hour training class, and
includes a take-home manual with practice disk, a Certificate of
Completion, and you can contact your instructor after your training with
questions. Contact us at 804-288-8331 for a custom-designed training class, that can mix and match these and additional topics. |
|||||||
|
About Us | How We Help | Courses Offered | Class Schedule | Registration Form Commonwealth
Computer Training Website Design by HunterNet is association with Free Rein Marketing. Hosted by Mediatech Enterprises.
|