Description
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
| Type | Details | |
| Delivery Method | 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. | |
| Entry Requirements | 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. | |
| Learning Method | 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. | |
| Progression | Upon completion of this course, delegates can progress onto ECDL Advanced Access. | |
| Duration | 9:30 am to 4:30 pm | |
| Location | 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. | |
Reviews
There are no reviews yet.