CMDBID: 100944 | Course Code: ACC16-L1 | Duration: 1 Days
The skills and knowledge acquired in Microsoft Access 2016 - Level 1 are sufficient to be able to create database systems, enter, edit and delete data in database files, produce information in forms and reports and generate queries on the data.
At the completion of this course, participants will be able to:
understand how Access is used and how to navigate around it
design a data-base with lookup tables
create a data-base structure using Access
modify the structure of an existing table
add records to a new table
add transactional records to a lookup database
work with the records in a database table
sort and filter records in a table
create simple and effective queries
create meaningful reports from tables
create and use forms.
Our clients have included prestigious national organisations such as Oxford University Press, multi-national private corporations such as JP Morgan and HSBC, as well
as public sector institutions such as the Department of Defence and the Department of Health.