Microsoft Access Advanced
Dates
This intensive course is designed to give existing users an insight
into some of the more advanced features in Access. This entirely
'hands on' course will give participants a further understanding
of database design principles, advanced forms, reports and query
design, including using calculations as well as an understanding
of customizing databases through command buttons, macros and menus
and using the database management tools
Access 2000 Advanced
Year 2000 Best Practice
Database design
Theory of normal forms • De-normalisation • Naming conventions
Access 2000 performance issues
Indexes • Data validation • Table level validation •
Relationships and referential integrity • Relationships •
Field types • Referential integrity options • Join types
• Using Lookups for referential integrity • Multi-table
datasheet view
Building and modifying forms
Using advanced forms features • The form worksurface •
Creating a calculated control • Adding a graphic to a form
• Multi-table forms • Using the Subform control •
Switchboard forms
Access and the Internet
Using hyperlinks • Using hyperlinks in forms • Exporting
datasheet views to HTML • Data access pages
Advanced queries
Filtering query results • Parameter queries • Creating
summary queries • Formatting query output • Query join
types • Self joins and aliases • Cross joins
Action queries
What is an action query? • Planning an action query •
Make table queries • Append queries • Delete queries •
Update queries
Producing reports
Applying sorting and grouping to reports • Performing calculations
on reports • Adding a graphic to a report • Using the
subreport control • Modifying section properties • Using
the Chart Wizard
Database management tools
Database administration • Documenting the database structure
• Backing up and restoring a database • Compacting and repairing
a database • Setting a database password • Encrypting and
decrypting a database
Multi-user databases
Shared databases • Setting default locking properties •
Creating groups and users • Setting user permissions •
Assigning ownership • Splitting an Access database • Changing
the location of the back-end database
Access Macros
What is a Macro? • Creating a Macro • Running a Macro
• Using Macros with events • Macro examples
Analyzing Access data in Excel
Embedding Pivot tables and charts in Access
Designing an Access application
Designing Menus and Toolbars • Customising Menus and Toolbars
• Customising Startup • Adding help screens to an application
|
