Access - Intermediate

Deepen your understanding of Microsoft Access with our comprehensive intermediate course designed to enhance your database management and reporting skills. Ideal for professionals, data analysts, and individuals seeking to leverage the power of Access, this course will empower you to harness the full potential of this versatile database software.

In our intermediate Access course, you will dive into advanced concepts and techniques that enable you to design, build, and maintain robust databases. Explore topics such as table relationships, query optimization, form customization, and report generation. You will gain practical skills to efficiently organize data, retrieve information, create intuitive user interfaces, and generate insightful reports.

Learn how to streamline data entry processes, implement advanced queries to extract valuable insights, and leverage Access's powerful reporting capabilities to present data in a clear and visually appealing manner. With our expert guidance and hands-on exercises, you'll develop the expertise to tackle real-world database challenges with confidence and efficiency.

Join our advanced Access course today and unlock the full potential of this powerful database software. Book now to embark on a transformative learning journey that will make you an Access expert and equip you with the skills to design and optimize robust databases. Discover the power of Access and become a master of advanced database development and optimization.


REVISION

  • A quick revision of the basic topics.

CREATING FORMS

  • Add titles, fields and labels
  • Edit and change the appearance of labels
  • Select, size, and move controls (objects)
  • Using your form

PRINTING REPORTS

  • Create, preview, print and save a report
  • Redesign the body of the report, header and footer
  • Grouping information
  • Total and subtotal figures
  • Creating standard letters and mailing labels

RELATING TABLES

  • Creating a relationship between tables
  • Setting Join Properties

ADVANCED FORM DESIGN

  • Showing data from more than one table
  • Using sub-forms and multirecord forms

ADVANCED QUERIES

  • The query window and joining tables
  • Including fields from more than one table

GRAPHING

  • Creating and printing graphs
  • Adding and editing graphs on the report

MACROS AND BUTTONS

  • Creating, saving and running a Macro
  • Making a button using OLE and adding a macro to it

IMPORTING DATA

  • Importing data from Excel

Though previous attendance at our Introductory Access course is assumed those with a comparable understanding are welcome to enrol. Please call a course administrator for clarification.

REVISION

  • A quick revision of the basic topics.

CREATING FORMS

  • Add titles, fields and labels
  • Edit and change the appearance of labels
  • Select, size, and move controls (objects)
  • Using your form

PRINTING REPORTS

  • Create, preview, print and save a report
  • Redesign the body of the report, header and footer
  • Grouping information
  • Total and subtotal figures
  • Creating standard letters and mailing labels

RELATING TABLES

  • Creating a relationship between tables
  • Setting Join Properties

ADVANCED FORM DESIGN

  • Showing data from more than one table
  • Using sub-forms and multirecord forms

ADVANCED QUERIES

  • The query window and joining tables
  • Including fields from more than one table

GRAPHING

  • Creating and printing graphs
  • Adding and editing graphs on the report

MACROS AND BUTTONS

  • Creating, saving and running a Macro
  • Making a button using OLE and adding a macro to it

IMPORTING DATA

  • Importing data from Excel

Class Details

3 hours 10am - 1pm or 1:30 - 4:30
4 or more people - $150 + GST (per person)
3 people - $175 + GST (per person)
1 or 2 people - $205 + GST (per person)
Evening Class 2½ hours 5:30pm - 8:00pm $90 + GST

At Your Site

4 or more people - $225 + GST (per person)
3 people - $250 + GST (per person)
2 or fewer people - $275 + GST (per person)

Venue:

Level 2 Primeproperty House
2 Woodward Street
Corner Lambton Quay & Woodward Street
Wellington

Upcoming Sessions

Date Time Cost excl. GST
Tue 19 - Tue 19 March 1:30 pm - 4:30 pm $205.00
Mon 1 - Mon 1 April 1:30 pm - 4:30 pm $205.00

Dates don't suit? Call or E-mail.