Microsoft Access Advanced (1 day – £595, plus VAT)

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.

Microsoft Access Advanced

Microsoft Access Advanced Outline

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.

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

Action Queries

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

Microsoft Access Advanced Locations

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