There are three courses dedicated to this programme, you will learn step by step to create relationship databases and to process their data. Within the first lessons, you will get acquainted with the programme environment and the used terminology. You will learn to design tables, set the properties of their fields, and try the entry of data to them. You will link the individual tables with each other via relations and will set the relation properties. You will also learn how to structure the entire database to be able to use it efficiently. Then you will learn to select specific data from the created tables via queries, in combination with calculations to achieve new data. You will also learn to use special action queries. You will examine how to arrange the data from tables and those derived by queries using forms and reports in order to print them or to make the entry of new data easier even to other users. You will learn to create macros that will automate the work in a database and will control whether the entered data comply with the set rules. You will also familiarise yourself with the options of importing and exporting data in databases and saving their individual objects.
OVERVIEW
REQUIREMENTS
- Individuals who want to gain a full knowledge of Microsoft Access from beginners’ level to advanced level.
- Learn at your own pace.
- 12-month access duration
- Can upgrade to a customised pack – tutor led training.
- Option to undertake accredited training
CONTENT
LIST OF COURSES
- MS Access 2016/2019: Introduction
- MS Access 2016/2019: Intermediate
- MS Access 2016/2019: Advanced
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
€75 for all three courses. Check out the great deals on more than one course
PROGRESSION
Microsoft Access is a program designed for creating and managing relational databases. This course takes you through all levels so that on conclusion you are proficient in using the MS Access programme.
There is the option to purchase:
- This course – MS Access 2016/2019: Set of 3 Interactive courses.- Introduction, Intermediate and Advanced
- The Full Microsoft Office 2016: Library of 16 Interactive Courses
- MS Office 365 – 5 in 1 – Tools for online Activity
- MS Word 2016: Set of 3 Interactive courses.- Introduction, Intermediate and Advanced
- MS PowerPoint 2016: Set of 3 Interactive courses.- Introduction, Intermediate and Advanced
- MS Outlook 2016:Set of 3 Interactive courses.- Introduction, Intermediate and Advanced
- MS Excel 2016: Set of 3 Interactive courses.- Introduction, Intermediate and Advanced
- MS Excel 2016: Set of 4 Interactive courses.- Introduction, Intermediate, Advanced and Expert