Access 2010: Level 1 (Win) (Workbook And CD) BeginnersLoan
The skills and knowledge acquired in Microsoft Access 2010 Level 1 are sufficient to be able to create database systems, enter, edit and delete data in database files, produce information in forms and reports and generate queries on the data. 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 1 assumes little or no knowledge of the software. However, it would be beneficial to have a general understanding of personal computers and the Windows operating system environment.
- Access 2010 Orientation
- Designing A Lookup Database
- Creating A Lookup Database
- Modifying Table Structures
- Adding Records To A Table
- Adding Transactional Records
- Working With Records
- Sorting And Filtering
- Creating Queries
- Creating And Using Reports
- Creating And Using Forms
At the completion of Microsoft Access 2010 Level 1 you should be able to:
- understand how Access is used and how to navigate around it
- design a database with lookup tables
- create a database structure using Access 2010
- modify the structure of an existing table
- add records to a new table
- add transactional records to a lookup database
- work with the records in a database table
- sort and filter records in a table
- create simple and effective queries
- create meaningful reports from tables
- create and use a variety of forms
Many of the topics in Microsoft Access 2010 Level 1 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