Course Code APR0129
This course is the last of a 3-Level programme which is designed for those who need to know how to automate operations in Microsoft Access 2007 . It is ideal for those who work in an office environment, clubs, and indeed home. This is a direct delivery course that enables you to acquire sufficient skills and knowledge in order to automate operations using macros, secure and protect data and have a general understanding of the programming environment in Microsoft Access 2007. Upon completion of the course you will be able to:
- Design a relational database project
- Create relational database files with multiple tables
- Set table relationships and join tables together
- Create queries based on one or more tables
- Create and work with aggregation queries
- Create and use a series of action queries
- Work with a number of macro techniques
- Create some simple programming code using VBA
|Direct delivery training course, providing you with interactive training in a small classroom setting. Packed with exercises and hands-on experiences, this course enables you to apply what you have learnt back in the workplace and professionally.
|This course assumes that you have some knowledge and experience of using the Microsoft Access 2007 software or have completed the Microsoft Access 2007 Levels 1 and 2 courses. A general understanding of personal computers and the Windows operating system environment would also be beneficial.
|This Direct Delivery offers delegates interactive training in a small classroom setting, enabling them to apply what they have learnt in the workplace. Delegates will receive training materials to support their training.
|Upon completion of this course, delegates can progress onto ECDL Advanced Access.
|9:30 am to 4:30 pm
|Aspyra Training: 46-48 Alfreton Road Nottingham NG7 3NN. Alternatively, we can deliver the training in your location or on your site at a mutually convenient date and time. The onsite rate applies.