Course Overview
Would you like to improve your Access skills? Come along to this fabulous Access course - it’s packed full of Access 2016 Tricks & Tips!
You’ll discover some amazing features that will allow you to fly through automating tasks, distributing the database and making switchboards!
Who is this course aimed at?
This course is intended for those who are already using Access and would like to expand their knowledge and be able to work super efficiently with Access 2016.
What does the course offer me?
You’ll gain the skills and practical knowledge to use Access more effectively, to get your work done faster and will less hassle. These are skills for life!
What do I take away?
Practical experience with the different features we cover in Access and the tips and hints we go through in the class.
Course Outline
Each delegate receives a complete set of high quality notes already printed.
1 - Integrating Access into your Business
- Import XML data into an access database
- Export Access data to XML Format
- Export data to the Outlook Address Book
- Collect Data through Email Messages
2 - Automating a Business Process in VBA
- Create a standard module
- Develop Code
- Call a procedure from a Form
- Run the Procedure
3 - Managing Switchboards
- Create a database Switchboard
- Modify a Database Switchboard
- Set the Startup Options
4 - Distributing & Securing Databases
- Split a database
- Implement security
- Set passwords
- Convert an access Database to an ACCDE file
- Package a database with a digital signature
5 - Sharing Databases using a SharePoint Site
- Export a table to a SharePoint list
- Import data from a SharePoint list
- Publish a database to a SharePoint site
- Move a database to a sharepoint site
- Work offline
Throughout the course we will cover the jargon and correct terms, so you can use them efficiently, as we discuss your individual questions.
Class Size
To give you the best learning outcome, we try to limit classes as follows:
- Min: 4
- Max: 12
When a class is too large, we split it into two smaller classes. This maximizes your learning, with your co-workers and colleagues.
Equipment
We make the general assumption that you’ll provide your own computer, laptop etc.
If you need to use one of our computers, please mention it when you book, as there is a nominal extra charge.
We supply everything else, including high quality printed materials.
Duration
This is a one day course. Delivered either on your site or at an off-site location.
Typically, we start at about 09:30 and work through the day until finished.
Adequate time is allowed for breaks, lunch, questions and individual tuition.