Access 2010: Level 2 (Win) (Workbook And CD) BeginnersLoan
Microsoft Access 2010 Level 2 is designed for users who have an understanding of how tables are created, records are entered, modified and deleted, and how simple queries, reports and forms are created.
The aim of this course is to build on the introductory skills of Level 1. The student learns how to ensure that data is entered correctly, how to create more sophisticated and complex queries, and is introduced to some basic automation techniques involving macros. 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 2 assumes some knowledge of the software to create basic databases and generate reports. It would be beneficial to have a general understanding of personal computers and the Windows operating system environment.
- Data Validation
- Formatting Tables
- Querying Techniques
- Parameter Queries
- Calculatins In Queries
- Modifying Forms
- Creating And Using Macros
- Macro Techniques
- Macros On Forms
At the completion of Microsoft Access 2010 Level 2 you should be able to:
- use various data validation features in Access to protect data
- format the data in a table
- perform more advanced queries using a variety of querying techniques
- create and use parameter queries
- create calculated queries
- modify and adapt an existing form according to specific needs
- create and use macros in Access
- work with a number of macro techniques
- create macros on forms
101 Page Workbook and CD
Many of the topics in Microsoft Access 2010 Level 2 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