San Francisco, California
London, United Kingdom
This course is designed for delegates who have been trained in using Microsoft Access and self-taught users who have been working with Access for several years.
Delegates will learn techniques required when creating complex Access database solutions; such as creating macros, writing advanced queries, building complex forms and reports and advanced database maintenance.
The course is held in Peterborough at the following address:
4-5 Newark Rd
The training centre can be reached by car or by a short taxi ride from Peterborough station. If you travel by car, free parking is available at the centre; or, if you take a taxi from the station, we will reimburse your fare. Lunch and refreshments are also provided.
Working With Macros
Creating A Macro, Adding Additional Macro Actions, Running A Macro Step-‐By-‐Step, Assigning A Macro To A Command Button, Creating A Macro Group, Using A Macro Group, Using Macro Conditions, The Autoexec Macro, Creating An Autokeys Macro, Creating A Data MacroOn Your Own
About Action Queries, Creating A Make-‐Table Query, Creating An Append Query, Creating An Update Query, Creating A Delete Query
Importing And Exporting Data
Importing Data From A Text File, Importing Data From Excel, Importing Data From Another Access Database, Linking Data, Exporting Data To Other Formats, Exporting Data To A Pdf File, Exporting Data To Another Access Database, Exporting Data To Excel, Exporting Data To Microsoft Word
Creating A Menu System
Creating A Switchboard, Adding Switchboard Items, Using The Switchboard, Editing A Switchboard, Setting Startup Options
Working With Forms And Reports
Adding A Subform Using The Subform/Subreport Tool, Modifying A Subform, Aligning Controls To Each Other, Creating An Option Group, Edit Sorting And Grouping Levels, Inserting Total Fields, Using Rectangles, Lines And Borders
Database Tools And Maintenance
Using Compact And Repair, Changing Database Properties, Documenting A Database, Analyzing A Database, Viewing Object Dependencies, Backing Up A Database, Splitting A Database, Setting A Database PassWord
When & Where
G Com Solutions Limited
G Com Solutions specialise in providing Microsoft Power BI training, as well as IT training on a variety of web technologies and computer software packages, especially those by Microsoft and Adobe. These software environments have become the standard for business, web and multimedia development since they empower companies to develop web solutions more quickly than ever.
Whether you need IT training as an IT specialist or as one of the many people who need computer training to improve their skills for career advancement, G Com Solutions courses can help you.