To begin developing your programming skills, start with Level 1, Creating Applications in Microsoft Access. Build on your programming skills with Level 2 and learn advanced development techniques in Level 3.
Course includes 60+ hours of total training time...
Level 1 CD-ROMs introduce you to application development using Microsoft Access 2000. You’ll learn the tools you need to create a simple Microsoft Access application including tables, queries, forms, reports, and just enough VBA code to get you started. By the end of Level 1, you’ll lean how to put an application together, including how to create menus and how to launch your application from a startup form.
In Level 1 you will learn...
Design tables and queries so you can store and retrieve your information the best way possible.
Create useful, attractive form for data input and application navigation.
Create reports that display the data you want, formatted the way you want it.
Use hyperlinks and the Access Wizards to help create a full Access application without writing any code.
Prerequisites:
To get the most out of Creating Applications in Microsoft Access, you should be familiar with the basics of creating tables and entering in Microsoft Access. Experience in creating and maintaining forms, reports, and queries is helpful, but not required.
SESSION 1
Creating Tables and Relationships
1.1 A Few Words About Database Design
1.2 Creating Tables
1.3 Creating Tables Using Design View
1.4 Creating Relationships
1.5 Importing and Linking to External Data
Creating Queries
2.1 Query Basics
2.2 Creating Query Criteria
2.3 Fine Tuning Your Queries
2.4 Multi-Table Queries and Joins
SESSION 2
Getting Started with Forms
3.1 Why Use Forms?
3.2 Getting Started
3.3 Creating a Bound Form
3.4 Working with Properties
3.5 Working with Other Control Types
3.6 Creating an Unbound Form
3.7 Managing Your Form’s Interface
SESSION 3
Displaying Data with Reports
4.1 Comparing Forms and Reports
4.2 Creating a Basic Report
4.3 Introducing the Sorting and Grouping Window
4.4 Performing Calculations on Reports
4.5 Making Sections Behave
4.6 TextBox Properties
4.7 Performing More Complex Calculations
4.8 Print Setup/Output
Building a Simple Application
5.1 Putting Together an Access Application
5.2 Using Hyperlinks in Access Applications
5.3 Using the Command Button Wizard
5.4 Creating Custom Menus, Shortcut Menus, and Toolbars
5.5 Creating a Startup Form
Level 2 looks at the critical aspects of application development using Microsoft Access. You’ll dig deeper into forms, tables, queries, and reports, and explore modules as you learn to use Visual Basic for Applications (VBA). Level 2 teaches you both how to design effective database applications, including database normalization and relationships, rules, and indexes; and how to work with VBA to manipulate objects and data. You’ll learn how to programmatically display and manipulate data on forms and reports, and you’ll begin to work with the Internet features in Microsoft Access as you create and deploy Data Access Pages.
In Level 2 you will learn...
Start using VBA in Microsoft Access.
Design efficient table structures to organize your data.
Create relationships between tables and set up referential integrity.
Display filtered and sorted data on forms and reports.
Master tips and tricks that create great reports.
Publish live Access data on the Web using Data Access Pages
Work with forms’ recordsets.
Prerequisites:
To get the most out of Programming in Microsoft Access, you should understand how to create and use all the interactive Access objects: Tables, queries, forms, and reports. Programming experience in any language is helpful, but not required.
SESSION 4
Making Forms and Controls Work
6.1 Modifying a Form’s Caption
6.2 Validating a Form’s Data
6.3 Using a Control’s Data Events
6.4 Introducing the Combo (and List) Box
Working with the VBA IDE
7.1 A Quick Tour of the VBA IDE
7.2 Writing Code
7.3 Testing Code
SESSION5
Effective Database Design
8.1 Why Bother with Design?
8.2 Relational Model Basics
8.3 Normalization
Making the Most of Your Tables
9.1 Building the Rules of the Business into the Database
9.2 Relationships and Referential Integrity
9.3 Creating Indexes
Creating Data Access Pages
11.1 Introducing Data Access Pages
11.2 Working with Data Access Pages
11.3 Creating a Data Access Page with Groups
11.4 Deploying Data Access Pages
SESSION 7
Investigating VBA
12.1 Why Use VBA?
12.2 Introducing Modules and Procedures
12.3 Calling Procedures
12.4 Creating Your Own Procedures
12.5 Using Variables
12.6 Variable Data Types
12.7 Finishing the Age Function
12.8 Using Constants
Programming Objects
13.1 Working with Objects
13.2 Working with Collections
13.3 Using Object Variables
SESSION 8
Report Tips and Tricks
14.1 Getting Just the Data You Want
14.2 Creating Reports with Multiple Columns
14.3 Numbering Items on a Report
14.4 Using BackColor to Create Alternate Gray Lines
Controlling Controls
15.1 Using Subforms
15.2 Using MultiSelect ListBox Controls
15.3 Handling New Entries in a Combo Box
15.4 Working with Tab Controls
SESSION 9
Programming Forms' Data
16.1 Filtering and Sorting Forms
16.2 Finding a Row on a Form
16.3 Mark a Row and Return to It Later
16.4 Using a Form’s Recordset Property (Access 2000)
Form Tips and Tricks
17.1 Creating a Splash Screen
17.2 Using Popup Forms
17.3 Controlling a Form’s Closing
17.4 Tapping into Keyboard Events
17.5 Using ActiveX Controls
Level 3 shows you how to move from creating simple applications to creating enterprise-wide, robust applications for multiple users. You’ll learn how to debug and handle errors, how to use ADO to work with data programmatically, how to secure your data with Microsoft Access security, and how to scale up to an Access client/server solution.
In Level 3 you will learn...
Debug applications and handle errors.
Master Microsoft Access security.
Use Replication to synchronize data among multiple sites.
Design client/server applications with Microsoft Access.
Use Automation to incorporate other Windows applications into your Access solutions.
Manipulate data using ActiveX Data Objects (ADO).
Prerequisites:
To get the most out of Advanced Development in Microsoft Access, you must be very familiar with creating and using all of Access' interactive objects: Tables, queries, forms, and reports. You must also understand how to use VBA to create event procedures in Access forms and user-defined functions that can be used in queries and form controls.
Session 10
Mastering Debugging
18.1 Why Do You Need Debugging?
18.2 Getting Started with Debugging
18.3 Stepping Through Code
18.4 Evaluating Expressions
18.5 Tips on Effective Debugging
Managing Data with ADO
20.1 Introducing ActiveX Data Objects
20.2 Retrieving Data with ADO
20.3 Searching for Data in a Recordset
20.4 Updating Data with ADO
Using Error Handling to Bullet-Proof Your Code
21.1 Handling Run-Time Errors
21.2 The Error Handling Standard
21.3 Taking a Closer Look
21.4 Who Handles Errors?
Exploring Replication
23.1 Replication Basics
23.2 Replicating a Database
23.3 Changes Access Makes to a Database When You Replicate it
23.4 Synchronizing Replicas
23.5 Conflict Management
23.6 Partial Replication
SESSION 13
Automating Office Applications
24.1 What Is Automation?
24.2 Working with Other Applications
24.3 Example: Building an Excel Chart
24.4 MailMerge with Word
24.5 Access as an Automation Server
SESSION 14
Securing Your Applications
25.1 Choosing the Right Security System
25.2 Workgroups
25.3 Users and Groups
25.4 Permissions
25.5 Using the Security Wizard to Properly Secure Your Database
Building Access Data Projects
26.1 Introduction to Access Projects
26.2 Creating a New Project
26.3 Creating SQL Server Objects
26.4 Creating SQL Server Database Diagrams
26.5 Creating SQL Server Views
26.6 Creating SQL Server Stored Procedures
Ken Getz (MCSD, MCP) and Paul Litwin (MCSD, MCP) are your instructors for Microsoft Access 2000 Professional Training via Video and CD-ROM™. Both are Senior Consultants with MCW Technologies, a Microsoft Certified Solution Provider. Ken and Paul specialize in application development, training, and writing about Microsoft Access, Visual Basic, Visual InterDev, and related technologies.
They speak frequently at industry conferences, write articles for various publications, and are co-authors, along with Mike Gilbert, of the best-selling Access 97 Developer’s Handbook and Access 2000 Developer’s Handbook, as well as several other books.
Ken and Paul developed the courseware used in these videos. In addition, Ken is the author of Visual Basic courseware and videos and CD-ROMs, and Paul is the author of Visual InterDev and Active Server Pages (ASP) courseware and videos and CD-ROMs.
