We've noticed this is not your region.
Redirect me to my region
What do you want to learn today?

Details

Level 1 - Access Queries and Report Writing for End Users

Access Course
for End Users

This course will help users to understand how to effectively write queries and run reports using an existing Access Database.

  • Add and append data to existing tables
  • Modify the design of a table, form or report
  • Add new fields
  • Use Sort, Find and Filter
  • Use Filter by Form
  • Design select queries
  • Learn how to specify criteria in a query
  • Design parameter queries to prompt the user to input data
  • Create calculated fields in queries to perform calculations on data
  • Design reports

Level 2 - An Introduction to Access Database Design

Access Course Covering Database Design Basics
  • Overview, the QAT and Ribbon
  • Database concepts and design
  • Creating tables, data types, field properties and data entry
  • Filtering and sorting data
  • Creating select queries for extracting data
  • Designing forms
  • Printed reports

Level 3 - Intermediate Access Database Design

Access Course Covering Intermediate Design Concepts
  • Creating a relational database
  • Understanding and creating table relationships
  • Action queries
  • Crosstab queries
  • Multi table forms
  • Tab forms
  • Form Controls and properties
  • Sub forms and sub reports
  • Simple macros and buttons
  • Mail merge
  • User Interface
  • Macros
  • Lists
  • Object oriented programming and modules control sources
  • Debugging  Functions
Reviews
Be the first to write a review about this course.
Write a Review
Trainers Direct specialises in delivering inhouse Computer training courses in Sydney and across major states in Australia aswell as professional development. Our popular courses include Excel training, Office 365, Microsoft Office, time management, leadership skills plus many more. We also offer one on one training and coaching.
Sending Message
Please wait...
× × Speedycourse.com uses cookies to deliver our services. By continuing to use the site, you are agreeing to our use of cookies, Privacy Policy, and our Terms & Conditions.