Our Workshops

Microsoft Access

Microsoft Access



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


Introduction to Access 

  • The Access Window Components           
  • Exploring Access Databases        
  • Database components 
  • What is an Access Database?     
  • Create a Access Database           


  • Field, Control and Object Names             
  • Create a Data Table        
  • Set Field Properties       
  • Manipulate the Table Design     
  • Manipulate Table Data 
  • Delete a Table  


  • Set Primary and Foreign keys    
  • Create Table Relationships         
  • Edit Relationships           
  • Explore Sub-data sheets              


  • Create Select Queries   
  • Run a Query      
  • Extend Queries with Criteria      
  • Use Calculated fields in Queries               
  • Apply Record Grouping and Calculations              


  • Use AutoForm 
  • Use Form Wizards          
  • Create a Form Manually               
  • Modify a Form 
  • Set Print Options             
  • Print a Form      


  • Explore AutoReports     
  • Use the Report Wizard 
  • Add Calculated fields to a Report             
  • Format a Report              
  • Set Print Options             
  • Print a Report   


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


Workshop Dates