Our Workshops
Microsoft Access
Microsoft Access
Description
TWO DAY WORKSHOP
LEVEL 1 & 2
Master databases of every form
Whether you're processing client records, stock items, or any other information you need, the Microsoft Access workshop makes working with and accessing those data files simpler than ever before. You will learn how to create a database, with emphasis on the creating of Queries and Reports to manipulate your records – in fact everything you need to know to master the uses of Microsoft Access.
Practical learning sessions with templates and exercises
This comprehensive 2-day workshop covers not only the basics, but also advanced functionality of Access. You'll discover the many practical features of Access that can be incorporated into everyday work. In addition, delegates will complete a set of practical exercises that cover the building of databases for Stock Control, Customer Contact/Service Management and Sales over the course of the workshop, to further anchor and practice the new techniques learned.
Detailed Workshop Outline
LEVEL 1
Introduction to Access
- The Access Window Components
- Exploring Access Databases
- Database components
- What is an Access Database?
- Create a Access Database
Tables
- Field, Control and Object Names
- Create a Data Table
- Set Field Properties
- Manipulate the Table Design
- Manipulate Table Data
- Delete a Table
Relationships
- Set Primary and Foreign keys
- Create Table Relationships
- Edit Relationships
- Explore Sub-data sheets
Queries
- Create Select Queries
- Run a Query
- Extend Queries with Criteria
- Use Calculated fields in Queries
- Apply Record Grouping and Calculations
Forms
- Use AutoForm
- Use Form Wizards
- Create a Form Manually
- Modify a Form
- Set Print Options
- Print a Form
Reports
- Explore AutoReports
- Use the Report Wizard
- Add Calculated fields to a Report
- Format a Report
- Set Print Options
- Print a Report
LEVEL 2
Plan the Database
- Plan a database
- Normalization
Wizards, Templates and Relationships
- Database templates and wizards
- Table wizard
- Table relationships (1-1 and 1- many)
- Referential integrity
Advanced Field Properties
- Advanced Field properties
- Input masks
- Lookup fields
Advanced Table Relationships
- Table Filters
- Query joins (inner and outer joins)
- Unrelated tables
- Self joins
Advanced Queries
- Query properties
- Parameters
- Action queries
Advance Form Development
- Combo box controls
- List box controls
- Option groups
- Command buttons
- Subforms
Advanced Report Features
- Pagination
- Summarize information
- Subreports
- Mailing Labels
MS Office Integration
- Export to Word
- Export to Excel
- Import from Excel
_______________________________________________________________________________________________________________________________________________________________
On-Site Workshops
- All workshops are offered in-house at your offices to a minimum of 5 delegates
- You provide the venue and refreshments, Front Foot supply all the workshop material – including laptops for computer-based training sessions
Remote Workshops
- All workshops are offered remotely to a minimum of 5 delegates
- Front Foot supply all the electronic workshop material
________________________________________________________________________________________________________________________________________________________________