Access Workshop (5
days) Learn everything you
need to know in order to prepare yourself to build and maintain a high-end
Access database. Included in the course are all 3 levels of Access, SQL and VBA.
This intense 5 day session is designed for those aggressively seeking Access
database skills.
Cost:
$875/person (Courseware Material Included)
Access - Level 1
Learn what
relational databases are and how to use them efficiently and effectively.
-
Creation of data tables
-
Understanding significance of proper field
type and size
-
Controlling the range of data input
-
Input masks
-
Validation Rules and Validation Text
-
Formatting display of data (reports)
-
Find and sort features
-
Filters
-
Query types
-
Performing queries
-
Creation and use of basic data forms
-
Creating, sorting, grouping and printing
basic reports
Access - Level 2
Learn how to use
data from other sources, and get more complete query and reporting capability
from their databases.
-
Importing data
-
Update queries
-
Make-table queries
-
Append queries
-
Delete queries
-
Parameter queries
-
Linking databases
-
Relationships
-
Database design principles
Access - Level 3
Learn how to use
data from other sources, and get more complete query and reporting capability
from their databases.
-
Switchboard forms
-
Controlling access to database components
-
Adding tab controls to forms
-
Command buttons
-
Basic macros
Intro to SQL
Learn how to
generate queries using the Structured Query Language in order to go above and
beyond what the Access query front-end can provide.
-
Intro
-
Select Statement
-
Select Clause
-
From Clause
-
Where Clause
-
Functions
-
Grouping
-
Having Clause
-
Order by Clause
-
Union Queries
-
Subqueries
-
Joins
VBA
Learn how to use
the code behind the Access interface in order to generate more powerful forms
and database functionality.
-
Intro
-
Controlling Forms with VBA
-
Calculations
-
Functions
-
Event Procedures
