|
Training Classes
| Learning and Development Resources
| Training Directory
| New Training Seminars
| New Training Providers
| Site Map
| Promote Training Seminars
|
Training Keywords
|
| Training Providers
| Regions
| Training Search
| Advertise Training Seminars
| Login
|
||||||||||||||||
Provided by: Advanced Concepts
MS Access Basic - AdvancedClick here for more information or to take this course
Training Provided by Advanced ConceptsMS Access 2000 BasicCourse Specification: Course Length: 3 Days Course Level: Basic Software: MS Access 2000 Professional Course Description: MS Access allows students to develop a database from scratch. Handling Queries and Simple Reports Target Students: Stock Controllers, Database Developers, Human Resource Mangers, Client Liaisons etc. Prerequisites: Windows 2000/ MS Word 2000 Basic Delivery Method: Instructor-led, group-paced, classroom-delivery learning model with structured hands-on activities. Benefits: Developing a simple database What s Next: MS Access Intermediate Course content: X What Is a Database? X Designing Your Database X Working in Access X Creating a New Database X Creating a Table with the Table Wizard X Creating a Table from Scratch X Editing Tables X Entering Data into a Table X Editing Data in a Table X Making Tables look great X Creating Relationships between Tables X Creating a Simple Form X Modifying a Form X Adding Controls to Forms X Searching for Information in Your Database X Sorting, Filtering and Indexing Data X Creating a Simple Query X Creating Queries from Scratch X Creating a Simple report X Customizing a Report X Taking Advantage of a Database Relationships X Understanding Relationships and Foreign Keys X Creating relationships X Setting Referential Integrity X Cascading Updates and Deletes X Working with Relationships X Creating Select Query X Create a Query with Single Criteria X Create a query using Wildcards Forms X Creating a form using Wizard X Entering and Editing in Forms X Searching for Records X Delete a Record X Close the form X Modifying form Design X Working with Text X Formatting Text X Changing Borders X Form X Importing Data from an Excel Spreadsheet X Exporting Data from Access X Merging access with Word MS Access 2000 Intermediate Course Specification: Course Length: 1 Day Course Level: Intermediate Software: MS Access 2000 Professional Course Description: The Intermediate concentrates more on the Table Analyzer, Managing Workgroups, En- & Decrypting Databases and developing Macros Target Students: Stock Controllers, Database Developers, Human Resource Mangers, Client Liaisons etc. Prerequisites: MS Access 2000 Basic Delivery Method: Instructor-led, group-paced, classroom-delivery learning model with structured hands-on activities. Benefits: Developing a more advanced database with more control What s Next: MS Access Advanced Course content: X Copying a Database Object X Deleting a Database Object X Compacting a Database File X Preparing a Database X Converting a Database X Table Analyzer X Using the performance Analyzer X Using the Database Documented X Setting a Database Password X Removing a Database Password X Managing the Workgroup X Setting User and Group Accounts X Setting User and Group Permissions X Encrypting and decrypting a Database X Encrypting a Database X Decrypting a Database X Creating a Macro X Running a Macro X Creating Macro Groups X Running Macro s in Macro Groups X Assigning Macros to Keys and the Toolbar X Assigning a Macro to a key combination X Assigning a Macro to a Toolbar X Creating a Macro that runs automatically X Building an automated form with Macros X Working with an Open Event X Working with the Click Events MS Access 2000 Advanced Course Specification: Course Length: 1 Day Course Level: Advanced Software: MS Access 2000 Professional Course Description: Additional functions e.g. Queries, Intro to SQL, Hyperlinks, Properties etc, to enhance a full fletch database developed on MS Access 2000 Target Students: Stock Controllers, Database Developers, Human Resource Mangers, Client Liaisons etc. Prerequisites: MS Access Intermediate Delivery Method: Instructor-led, group-paced, classroom-delivery learning model with structured hands-on activities. Benefits: Developing a complete database using most of the functions What s Next: VB on Access/ SQL Server 2000 Database Design Course content: X Autolook Query X Using Joins in Queries X Union Queries X Nested Queries X If Statements in Queries X SQL X SQL Defined X Writing Queries with SQL X The SELECT Command X The Predicate Option X SQL Aggregate Function X Advanced Forms X Tab Controls X Adding a Hyperlink to a Form X Adding Graphics to a Form X Modifying Default Control Properties X Properties of Forms X Setting the Format Properties X Setting the Data Properties X The Record set Type Property X The Cycle Property X Setting the Tab Order X Handling Edit Collisions X Working with Command Bars X Creating a Menu Bar with the Access 2000 User Interface X Editing a Menu Bar X Using the New Menu Bar X Customizing Reports X Advanced Reports Customization with Properties Training Avaliability and Delivery
Related Keywords: access About Advanced Concepts - Training Provider
Advanced Concepts - We are an accredited training provider with local authorities in SA. We have been in the training industry for the past 9 years.
We offer international and national course, instructer led or virtual.
Main source of training is IT and Softskill.
More Training from Advanced Concepts
Click here for more information or to take this course | ||||||||||||||||
Custom Search
| ||||||||||||||||
| Training Directory | New Training Seminars | New Training Providers | Search | Site Map | Promote Training | Login | Links | ||
|
| ||
| Training-Classes.com by Skillbox® 07/19/08 Copyright 1998-2008 skillbox, inc. All rights reserved |
 |
|
| Are you an Access training provider? |
| You could be on this page today - for FREE! |
