|
|
Our Microsoft Access Basic
course gives you a grounding in access and will enable you to build
simple database systems that can benefit your business. It is
expected that you will have a certain basic knowledge of using a
computers but no prior experience with Microsoft Access.
|
|
Our Microsoft Access
Intermediate course builds on your prior knowledge and enables you to
create a more flexible and robust database system making it much easier
for the user to operate. It is expected
that you will have experience or training within Microsoft Access.
|
|
Our Microsoft Access
Advanced
course introduces techniques employed by professional application
developers providing you with the skills to build feature rich database
systems. It is expected that you will have experience or training
within Microsoft Access.
|
|
| |
Getting started with MS
Access
Database concepts
Exploring the Microsoft Access environment
Getting help
Closing a database and Access
Databases and tables
Planning and designing an
Access databases
Exploring Database tables
Creating Database tables
Fields and records
Changing the design of a
database table
Finding and editing Database records
Organizing Database records
Data entry rules
Setting database field
properties
Working with input masks
Setting validation rules
Using indexes
Simple database queries
Creating and using
queries
Modifying query results and queries
Performing operations in queries
Using MS Access forms
Creating forms
Using the Form Wizard
Using Design view
Finding, sorting, and filtering records
Working with MS Access
reports
Creating reports
Modifying and printing reports |
|
Relational databases
Database normalization
Relating MS Access tables
Implementing referential integrity
Working with related
tables
Lookup fields
Modifying Lookup fields
Subdatasheets
Complex queries
Joining tables in MS
Access queries
Creating calculated fields
Summarizing and grouping values
Advanced form design
Adding unbound controls
Graphics
Adding calculated values
Adding combo boxes
Advanced reports
Customized headers and
footers
Adding calculated values
Sub-reports
Charts
Charts in forms
Charts in reports
PivotTables and
PivotCharts
MS Access PivotTables
Modifying PivotTables
PivotCharts
Internet integration
Hyperlink fields
Working with data access pages |
|
Querying with SQL
SQL and Access
Writing SQL statements
Attaching SQL queries to controls
Advanced queries
Creating crosstab queries
Creating parameter queries
Using action queries
Macros
Creating, running, and
modifying macros
Attaching macros to the events of database objects
Advanced Macros
Creating macros to
provide user interaction
Creating macros that require user input
Creating the AutoKeys and AutoExec macros
Creating macros for data transfer
Importing, exporting, and linking objects
Importing objects
Exporting objects
Interacting with the XML documents
Linking Access objects
Working with Windows SharePoint Services
Database management
Optimizing resources
Replicating and synchronizing databases
Security fundamentals
Protecting databases
Encrypting and decrypting databases
User-level security |
|
