|
|
|
|
Search using the drop down list, or further refine your search using keywords.
|
|
|
|
|
 |
|
|
Microsoft Access: Database Design
Business Skills Courses |
|
|
|
This practical two day course is designed for those who need to create relational databases using Microsoft Access.
The course covers how to plan, design and create a database to a detailed brief. You will learn to create different layouts, summarise information and produce reports. This course is run as a private course in order to tailor the content to your exact requirements.
Feel free to build a new database during the course or work on an existing database if you wish.
|
|
Database design concepts
• Planning a database
• Drawing up a database design
• Checking function meets need
Building components
• Using tables
• Relationships
• Meeting ‘normal forms' rules
• Using forms
Designing Queries
• Parameter queries
• Action queries
• Query joins
• Crosstab queries
Advanced form techniques
• Organising field placement
• Using functions to control data entry
• Adding an option group
• Using a form as a user interface
• Creating a sub-form
Creating macros to use with forms
• Macro introduction
• Attaching a macro to a command button
• Editing a macro |
Macros that add user interaction and automation
• Macros to automatically enter data
• AutoKeys and AutoExec macros
Reporting
• Designing reports
• Editing reports
• Adding functionality to reports
Switchboards
• Creating a switchboard
• Controlling database startup properties
Creating a splash screen
• Using a form as a splash screen
• Automating the splash screen
Database security
• End-user level security
• Password security
Questions and answers |
|
If you'd like to book by phone, or discuss your requirements;
 Courses provided by partners Media Training.
|
|
|
|
|
|
|
