Microsoft Access MODULES

Price: CHF 195 per module (3 hours session)

Module 1: Introduction to Access & Creating Tables

• Introduction to database design concepts & terminology
• Become familiar with the Access interface
• Open and examine and existing Access database
• Working with Tables and data records
• Find, sort and filter records in a table
• Create tables using the design view
• Create tables with the Table Wizard
• Introduction to table field properties

Module 2: Working with Relationships & Tables

• Relational database design concepts
• Create table relationships
• Explore relationship types
• Define referential integrity
• How to “Normalize” databases
• Additional table field properties
• Create a lookup list

Module 3: Queries

• Create select queries
• Use criteria to refine query results
• Create multi-table queries
• Create query joins
• Implement query parameters
• Performing calculations in a query

Module 4: Additional Queries, & Importing/Exporting Objects & Data

• Create a totals queries
• Create crosstab queries
• Create Action Queries
• Import/export data
• Linking tables from one database to another
• Use MS OfficeLinks

Module 5: Creating Forms

• Creating an AutoForm
• Using the Form Wizard to design new forms
• Add and modify form controls
• Work with control properties
• Adding images and titles
• Create calculated controls
• Create forms in design view
• Creating Forms with Sub-forms
• Create tabbed forms

Module 6: Creating Reports

• Using the Report Wizard to create new Reports
• Modify report's page setup settings
• Modify report design and layout
• Work with report sections
• Create summary functions
• Create reports in design view
• Use the Mailing Labels Wizard

Module 7: Automating Access Databases

• Create macros
• Implement and run macros
• Event driven macros
• Setting database startup options
• Introduction to VBA concepts and terminology

Module 8: DB Maintenance and Deployment

• Create switchboards
• Discuss deploying Access databases in a multi-user environment
• Explore Microsoft Access security features
• Compact and repair databases
• Using hyperlinks in an Access database
• Overview of Data Access Pages

 

Apply for MS Access Module course>>