This is a Paypal Test Course

Onsite
$15$8.85

Paypal Test COURSE DESCRIPTION

This course is designed for beginning Access users to gain essential and practical skills of Database Application and Database Programming that can be used in day to day Business activities.

This course concentrates on basic Access concepts including tables, queries, forms, reports, basic VBA statements and programming skills, Jet SQL and ADO, and Microsoft Office Objects.

Upon completion of this course, students will be able to create, modify and work with tables, queries, forms and reports within Microsoft Access 2003; and build simple VBA projects to associate their special needs in Database development.

    • Totally 30
    • Every Saturday 9:00am – 12:00pm.
    • Easy to get in and start.
    • A newly designed, hands-on focused.
    • Everyone has a computer to practice.
    • Cross-managing Access, Excel and SQL Server.

 

Course Outline

 Class 1. Creating Access Database

Class 2. Handling Data in Access

Class 3. Starting with VBA in Access

Class 4. Forms

Class 5. More Coding in VBA

Class 6. Using ADO in Access VBA

Class 7. Access Reporting

Class 8. Introduction to Excel VBA

Class 9. Coding in Excel VBA

Class 10. Using ADO in Excel

Class 1. Creating Access Database

1.1. Course Objectives

1.2. Database Fundamentals

1.3. Sample Data

1.4. Designing Tables

1.5. Access Database Data Types

1.6. Creating Tables

1.7. Primary Key

1.8. Building Relationships

 

Class 2. Handling Data in Access

2.1. Entering Data

2.2. Importing Data

2.3. Querying Data with SQL

2.4. Update, Insert and Delete

2.5. More Queries – Joining Tables

 

Class 3. Starting with VBA in Access

3.1. What is VBA – VBA Overview

3.2. Objects, Controls and Properties

3.3. Variables and VBA Data Types

3.4. Events and Action Procedures

3.5. If Blocks

3.6. Select Case Structures

3.7. Looping Structures

3.8. Dialog Boxes, List and Combo Boxes

 

Class 4. Forms

4.1. Creating and Modifying Forms

4.2. Unbound Controls

4.3. Graphics

4.4. Calculated Fields

4.5. Combo Box

4.6. Tab Controls

4.7. Subforms

 

Class 5. More Coding in VBA

5.1. VBA Coding Basics

5.2. Calculations and Data Manipulation

5.3. Presenting Data

5.4. Handling Errors, Logs and Messages

5.5. Debugging and Troubleshooting

5.6. Complete Data Maintenance

5.7. User-Defined Procedures and Types

5.8. Code Reusable

5.9. Using Array

 

Class 6. Using ADO in Access VBA

6.1. What Is ADO

6.2. How ADO Works

6.3. Managing Access Database by ADO

6.4. Manipulating Data with ADO

6.5. Accessing SQL Server

6.6. Managing Excel from Access

 

Class 7. Access Reporting

7.1. What is Access Reporting

7.2. Creating/Modifying/Printing Reports

7.3. Header, Footer and Grouping Data

7.4. Calculated Values Using Functions

7.5. Subreport

7.6. Delivery

 

Class 8. Introduction to Excel VBA

8.1. Excel VBA Basics

8.2. Macro v.s VBA

8.3. How VBA Works in Excel

8.4. Access VBA v.s Excel VBA

8.5. Making Calculations

8.6. Moving Data in and out

8.7. Conditions

8.8. Driving Events

8.9. Other Microsoft Office Controls

 

Class 9. Coding in Excel VBA

9.1. Controlling Outside Files

9.2. Importing from Excel Files

9.3. Exporting to Excel Files

9.4. Forms in Excel VBA

9.5. Managing Data in Different Sheets

9.6. Adding/Deleting/Updating Sheets

 

Class 10. Using ADO in Excel

10.1. Talking to SQL Server

10.2. Getting Data from Access

10.3. Handling Excel via ADO

10.4. More Topics before Finishing

  •     10.4.1. Security & Permission Controls
  •     10.4.2. Clean-up, Backup & Restore
  •     10.4.3. Local v.s Network Sharing
  •     10.4.5. Considering Performance
  •     10.4.6. Automation

10.5. Course Review & What is Next