Advanced MS Access

Wise

Course

In Gatwick

£ 201-500

The best Access courses

See all

See all

Description

  • Type

    Course

  • Location

    Gatwick

  • Duration

    2 Days

Upon completion of this presentation, the participant should be able to perform complex queries, create efficient forms and reports and create and use macros. In addition, the student will learn about security issues and creating a user-friendly interface.

Facilities

Location

Start date

Gatwick (London)
Regus Centre, First Point, Buckingham Gate, London Gatwick Airport, RH6 0NT

Start date

On request

About this course

Completion of our course Introduction to Access or equivalent knowledge.

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

Course programme

Refining Table Design

  • Lookup Wizard
  • Input Mask Wizard
  • Set a default property
  • Customise AutoNumbers

Advanced Form Design

  • Create a form with a subform
  • Add a calculated field
  • Add control buttons
  • Add an Option Group
  • Using Combo Boxes
  • Control properties
  • Create a Switchboard

Queries

  • Parameter queries
  • Crosstab queries
  • Action queries
  • Totals queries
  • Find top 10

Reports

  • Add an expression to a report
  • Add subtotals
  • Subreports

Macros

  • Create a macro
  • Modify a macro
  • Assign macros to command buttons

Import, Export & Link Data

  • Import from/export to Excel
  • Import from a text file
  • Import from/export to another Access database
  • Link tables

Security

  • Protect the database
  • Set a password
  • Hide the database
  • Create a user-friendly interface

Additional information

Comments: For more information: http://www.wiselimited.com/OFFAC2.htm

See related categories

Advanced MS Access

£ 201-500

The best Access courses

See all

See all