In the course MS Access 2016/2019: Advanced, you will familiarise yourself with action queries. You will examine different types of queries in the SQL view and will get acquainted with the essential clauses of this language. You will learn to create and use macros to automate your work with databases. You will explore importing and exporting of objects and their data. You will examine the printing options of different objects in details and you will familiarise yourself with normalisation of data. You will also examine the options of navigation in a database.
OVERVIEW
REQUIREMENTS
- Persons who a lot of experience on Access and want to complete advanced Access to help with Office productivity and advanced database design for the organisation.
- Make sure you have completed the beginners and intermediate course first or make sure you understand how to complete all elements (see other courses to consider under the progression section).
CONTENT
INDICATIVE CONTENT
- Append and update queries.
- Make table and delete action queries.
- SQL language
- Definition of queries in SQL
- Creating a form collecting query parameters
- Macro basics
- Assigning a macro to a button
- Data validation via macros
- Data evaluation via macros
- Exporting data from a database
- Splitting a database
- Automated data import and export
- Import and export in XML format
- Object dependencies and properties inheritance
- Navigation Pane
- Navigation in a database
- Access privacy and security
- Printing database objects and their documentation
- Data normalization
CERTIFICATION
Personalised Certificate of Completion or option to complete QQI accredited course at level 3, 4, 5 and 6, ECDL, MOS
ASSESSMENT
- Online assessment
METHOD OF DELIVERY/DURATION
- Online and Customised for Organisations
COST
€29.95 for one single modules. Check out the great deals on more than one course.
PROGRESSION
This course is for advanced users. – you will be competent in all areas of MS Access on conclusion.
There is the option to purchase: