Training
Provided by Advanced Concepts
MS Access 2000 Basic
Course
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
| This is primarily ilt training |  | Contact Advanced Concepts for more information |
|
| Duration: | 3 days | | Training Presented in: | English |
|
