Objective:
Participants will learn the advanced level of Microsoft Access 2010
Course Outline
Database Design Basics
- What is good database design
- The Design Process
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
Queries
- Create Query
- Count Data Using Query
- Use Parameters
- Understand Duplicate Data
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
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
Subform
- Create A Form That Contains A Subform
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
Reports
- Create A Report
- Create A Grouped or Summary Report
- Fine Tune Your Report
- Save, Print or Send Your Report
Macros
- Learn About The Macro Builder
- Create a Standalone Macro
- Edit A Macro
- Use Conditions To Controls Macro Actions
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
Secure an Access 2010 Database
- Use An Office Access 2010 Database In A Trusted Location
- Package, Sign and Distribute An Office Access 2010 Database
- Enable Disable Content When You Open A Database
- Use A Database Password To Encrypt An Office Access 2010 Database
- How Security Work With Databases From Earlier Version
- Run Unsafe Expression (Disable Sandbox Mode)
|