Microsoft Access Advanced

GCOM Solutions

Training

In London

£ 595 + VAT

The best Access courses

See all

See all

Description

  • Type

    Training

  • Level

    Advanced

  • Location

    London

  • Duration

    1 Day

  • Start date

    Different dates available

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

Facilities

Location

Start date

London
See map
United House, North Road, Islington, N7 9DP

Start date

Different dates availableEnrolment now open

About this course

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

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Access
  • Database
  • Database training
  • Microsoft Access
  • Exporting Data
  • Macro
  • Data Macro
  • Adding
  • Macro Actions
  • Autoexec
  • Delete Query

Course programme

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

See related categories

Microsoft Access Advanced

£ 595 + VAT

The best Access courses

See all

See all