Find Courses Find Providers Providers - Promote Your Courses About Us

MS Access Level 4

Training Courses

Would you like to see more Microsoft Access courses?

Training course summary

Sponsored links

Must be a fairly confident Access user. You’ve created databases a few times and know about relating tables. Queries are a breeze to you. This course looks at setting databases up for other people to use. You will learn how to automate the flow of your database using a start up screen (or Switchboard), and learn how to use macros in Access. Please note that macros are not VBA.

Regions:
  • London
Delivery:
  • Public
Category:
Difficulty:
  • Advanced

Further Details

Multi User Databases · Splitting the database into a front and back end · Creating a security file so users have to log-in to the database Working with macros (Not VBA) · Understanding and Exploring Macros · Using the Macro window Toolbar · Creating New Macros - Open a form read only - Open a form for data entry only - Export a table to Excel - Send a report via Email - Copy table to another database - Print a Report · Running a macro · Stepping through a macro · Modifying a macro · Adding Conditions to Macros · Using the Expression builder to create Conditions · Running macros with conditions · Attaching Macros to a Form · Attaching Macros to a Report · Filtering Records · Commenting Macros · Macro Names · Printing Macro Definitions · Viewing Macro Definitions Working with Switchboards · Creating a Start-up Screen (Switchboard) using the wizard · Editing a Switchboard Item · Setting the properties of the form so it stays on top · Deleting a Switchboard

Guide price

£150

 

Sponsored links

Interested in this course?

 

 

Information provided is for information purposes only and no guarantees are made with regards to accuracy. It is advised that all details are checked prior to making a booking. Terms of use
Website design by Brit-net