G Com Solutions Limited deliver onsite Microsoft Access Advanced all over the UK. We customize our Microsoft Access Advanced to match our client’s specific requirements. If you are looking to extend your knowledge of Microsoft Access, then this may be just the course you are looking for.
Access is much more than a way to create desktop databases. It’s an easy-to-use tool for creating applications that help you run your business.
This course is suitable only for those with considerable prior experience and covers: ‐ working with macros; ‐ action queries; ‐ importing and exporting data; ‐ creating a menu system; ‐ working with forms and reports; and ‐ database tools and maintenance.
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 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 Switchboard, Adding Switchboard Items, Using The Switchboard, Editing A Switchboard, Setting Startup Options
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
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
We can deliver training on Microsoft Office at your offices, anywhere in the UK, or at our training centre in Peterborough:
Pinnacle House, 4-5 Newark Rd, Peterborough PE1 5YD