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
Pricing:
On your premises
3 hours 10am - 1pm or 1:30 - 4:30
4 or more people - $225 + GST (per person)
3 people - $250 + GST (per person)
1 or 2 people - $275 + GST (per person)
Venue:
On your premises or we can arrange a venue to suit.
Upcoming Sessions
Dates don't suit? Call or E-mail.