Course description
Microsoft Access 2019
Microsoft Access is Microsoft's popular database creation and management program. Databases are widely used to collate and manage customer information and survey results. They’re used in any situations where you need to store and analyse large amounts of data, reliably and efficiently.
Do you work at this organisation and want to update this page?
Is there out-of-date information about your organisation or courses published here? Fill out this form to get in touch with us.
Upcoming start dates
Suitability - Who should attend?
This Microsoft Office Access 2019 course is ideal for you if you want to quickly understand Microsoft Access 2019 and help towards a potential job, promotion, running your own business, or for personal use.
Outcome / Qualification etc.
Accreditation: Microsoft - Training and Certification Courses
Training Course Content
- The basics of working in the Access program
- Key database terminology
- Various ways of creating tables and practise setting the properties of their fields
- Further analyse the data in a table through select queries, including the creation of calculated fields
- Understand how to set relations between tables and ensure their referential integrity
- Create simple forms and reports
- Create calculated fields in queries that operate with functions
- Practise creating totals queries and parameter queries
- Properties of table joins and examine how they can affect the result of queries
- Create forms in the Design view and insert calculated fields into them
- Design and edit reports, and learn to perform various calculations in them
- Learn how to insert controls into forms and reports, including subforums and sub reports.
- Action queries
- Different types of queries in the SQL view and get acquainted with the essential clauses of this language
- Create and use macros to automate your work with databases
- Importing and exporting of objects and their data
- Printing options of different objects in detail
- The normalisation of data
- The options of navigation in a database
Why choose e-Careers Ltd
We have successfully trained over 610,000 learners, from over 50 countries, and growing.
We are industry leaders, with multiple awards and over 10 years experience.
Our Trainers and Tutors are industry experts in their fields
Expenses
Tuition Fee: £ 45Inc. VAT
Continuing Studies
This course will help any Office Administrator or IT Administrator who utilises the Microsoft Access software to manage relational databases that are at the heart of business operations.