In this course MS Access 2016: Introduction, you will familiarise yourself with the terminology concerning relational databases and with the basics of working in the Access programme. You will try various ways of creating tables and setting the properties of their fields. You will learn to further analyse the data in tables through select queries, including the creation of calculated fields in them. You will set relations between tables and ensure their referential integrity. You will also familiarise yourself with an easy way of creating simple forms and reports.
OVERVIEW
REQUIREMENTS
- Individuals who have no experience of the basics of Microsoft Access and needs to understand how to use the software from beginning.
- This course will help you start from scratch to support the beginner on their Information Technology journey and understanding databases.
- You can upgrade from the beginners’ course on conclusion to intermediate and advanced (see other courses to consider under the progression section).
CONTENT
INDICATIVE CONTENT
- Introduction to databases and their objects
- Access environment
- Creating a table in the Datasheet View
- Design view of tables
- Advanced field data types
- Restricting data input in tables
- Analysis of relationships between tables
- Relationships between tables
- Referential integrity
- Navigation in tables
- Searching for records and editing them
- Sorting and filtering data in tables
- Select queries.
- Creating a select query
- Criteria in select queries
- Calculated fields in queries
- Joining tables for the purpose of a query
- Lookup columns in tables
- Editing a lookup column
- Automatic creation of forms
- Report creation
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 beginners as an introductory course on Access 2016.
There is the option to purchase: