START
 

Access Programming

G Com Solutions
Course summary
Length: 2 days
Location: Nationwide
Next available date: Variable depending on group number - Nationwide

Access Programming

In-house computer training courses

GCom Solutions  - On-Site Computer Training Courses in the UK - One-to-one and group training

This course is designed for beginners and covers: creating content in Edge Animate; preparing web assets for use in Edge Animate Projects; working with web fonts; compositing layouts; making your compositions responsive; creating animations; working with actions; the code panel; considering older web browsers and network speed; going beyond the Edge Animate interface; publishing your Edge Animate Project; and adding Edge Animate compositions to existing HTML pages.

Suitability - Who should attend?

This course assumes no knowledge of Visual Basic but requires familiarity with the fundamental features of MS Access. The ability to carry out basic computing tasks, such as saving or copying a file, is also assumed.

Outcome / Qualification etc.

A G Com Solutions Certificate of Attendance is issued on course completion.

Training Course Content

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 Macro, Adding A Macro To The Quick Access ToolbarOn Your Own

Action Queries

About Action Queries, Creating A Make-Table Query, Creating An Append Query, Creating An Update Query, Creating A Delete Query, Creating A Sql 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, Exporting Data To Microsoft Word Mail Merge, Collecting Access Data Via Email

Creating A Menu System

Creating A Switchboard, Adding Switchboard Items, Using The Switchboard, Editing A Switchboard, Setting Startup Options, Creating A Navigation Form

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, Creating A Pivottable Form, Rearranging Pivottable Data, Filtering Pivottable Data

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

Expenses

£900 for one-to-one training

£1,100 for groups of up to 6 people

£1,300 for groups of up to 12 people

Provider: G Com Solutions

G Com Computer Training Solutions

G COM Solutions Limited - On-Site Computer Training Courses

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. Perhaps you need software training to get into...


Read more and show all courses with Provider: G Com Solutions

Request information - obligation free

Fill out your details to find out more about Access Programming.

  Contact the provider

  Get more information

  Register your interest

Errors
Optional
Optional
Optional

Contact information for G Com Solutions

G Com Solutions


Kemp House, City Road
EC1V 2NX London

 Show phone number
gcomsolutions.co.uk
Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

 
Request information

Find out more about this Access Programming course - simply fill out your details:

 
Find more courses here

 
Have your say:

apprenticeships