This course is designed for those who would like to gain a comprehensive understanding of the advance features of the MS Access database programme. There are no formal entry requirements for the course, however you should already have skills equivalent to those gained from our Access Introduction course. If you are unsure please speak to a member of our team.
This course has been specifically designed to give users a solid foundation in using advance database features thus enabling them to use Access efficiently and effectively in the workplace.
The course covers a broad range of skills to encompass the fundamental and most commonly used features of the programme. Upon completion of this course, you should be competent in: Access basics Planning a database Creating and modifying table structures and relationships Finding, filtering and formatting data Data validation Creating and extracting information using effective querying techniques. Using operators in query Working with forms and reports Formatting forms and reports Creating subforms Importing and exporting records
1 day course (6 hours). Candidates will be awarded a college certificate of attendance upon completion of the course. Progression opportunities: Level 3 in Database Software.
CON/ITOC_MA2Coleg Gwent Business (Short Course)
All courses may be subject to change. Coleg Gwent reserves the right to withdraw courses should they no longer be deemed viable to run.
Gall yr holl gyrsiau fod yn destun newid. Mae Coleg Gwent yn cadw'r hawl i dynnu cyrsiau yn os ystyrir nad yw bellach yn ddichonadwy i'w rhedeg.
Visit our campuses and speak to staff