Access 2010: Level 3 (Win) (Workbook And CD) BeginnersLoan
This course is primarily designed for people who need to know how to develop relational databases and automate operations in Microsoft Access 2010
The skills and knowledge acquired in Microsoft Access 2010 Level 3 are sufficient to design and create a multi-table database and automate operations using macros and have a general understanding of the programming environment in Microsoft Access 2010. Watsonia workbook tutorials. Files for the exercises are provided on CDs.
- All current Cambridge University members (departments and colleges)
- Further details regarding eligibility criteria are available
Microsoft Access 2010 Level 3 assumes some knowledge of the software and it would be beneficial to have a general understanding of personal computers and the Windows operating system environment.
- Relatioal Database Design
- Creating A Relational Database
- Setting Table Relationships
- Multi-Table Queries
- Aggregation Queries
- Action Queries
- Macro Techniques
- An Introductin To VBA
At the completion of Microsoft Access 2010 Level 3 you should be able to:
- design a relational database project
- create a relational database file 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
93 Page Workbook and CD
Many of the topics in Microsoft Access 2010 Level 3 require you to open an existing file with data in it. These files can be downloaded from our web site, but are also included on a CD at the back of the book.
Please refer to the information page for self-taught loan courses
Booking / availability