Objective:
Participants will learn the advanced level of Microsoft Access 2007
Course Outline
1. Database Design Basics
- What is good database design
- The Design Process
2. Relationship
- Type Of Table Relationships
- View Table Relationships
- Create A Table Relationship
- Delete A Table Relationship
- Set The Join Type
- Enforce Referential Integrity
- Set The Cascade Options
3. Tables
- Data Types
- Input Maks
- Understand Validation Rules
- Default Value
- Lookup Values
- Multivalued Lookup Column
4. Queries
- Create Query
- Count Data Using Query
- Use Parameters
- Understand Duplicate Data
5. Actions Queries
- Create Make Table Query
- Create An Append Query
- Update Query
- Sum Data Using A Query
- Calculate Group Totals By Using a Total Query
- Crosstab Query
6. Form
- Create Form Using The Form Tool
- Split Form Using The Split Form Tool
- Understand Control
- Understand Control Layouts
- Understand Layout View and Design View
- Add Controls to Your Form
- Using Common Button
- Using Check Boxes, Options Buttons and Toggle Buttons
- Create a Calculated Control
7. Subform
- Create A Form That Contains A Subform
8. Switchboards
- Options For Using Switchboards
- Create a Custom Group of Objects In the Navigation Pane
- Open and Close the Navigation Pane
- Turn Off the Navigation Pane
- Use the Switchboard Manager to Create Or Change a Switchboard
9. Reports
- Create A Report
- Create A Grouped or Summary Report
- Fine Tune Your Report
- Save, Print or Send Your Report
10. Macros
- Learn About The Macro Buider
- Create a Standalone Macro
- Edit A Macro
- Use Conditions To Controls Macro Actions
11. Importing & Exporting of Data
- Import Or Link To Data in An Excel Workbook
- Export Data to Excel
- Edit A Macro
- Use Conditions To Control Macro Actions
12. Secure An Access 2007 Database
- Use An Office Access 2007 Database In A Trusted Location
- Package, Sign and Distribute An Office Access 2007 Database
- Enable Disable Content When You Open A Database
- Use A Database Password To Encrypt An Office Access 2007 Database
- How Security Work With Databases From Earlier Version
- Run Unsafe Expression (Diasble Sandbox Mode)
|