Microsoft Access 2007 Level 2 Aberdeen, (f1plus): Classroom or E-Learning
Sponsored links
In this course the student learns how ensure that data is entered correctly into a table, how to create more advanced and sophisticated queries, how to develop more complex forms and reports, and is introduced to some basic automation operations using macros. The student also learns how to tie the various elements and objects of a database together using a switchboard form.
At the completion of Microsoft Access 2007 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
•create macros on forms
•export records to and import records from a wide variety of sources and applications
| Delivery: |
|
| Regions: |
|
| Category: |
Further Details
This publication is designed for people who wish to build on the introductory skills of creating a new database, working with data, and producing basic queries, reports and forms. This course will build your confidence and skills by sorting, filtering, and querying data, validating data prior to data entry, and building a small menu system to manage a database.
This publication assumes a basic knowledge of Microsoft Access 2007, especially building a database file and data tables. It would also be beneficial to have a general understanding of personal computers and the Windows operating system as you will be required to start applications, work with and copy files, and locate file folders.
This Training Course is available at the following locations:
Aberdeen
Information provided is for information purposes only and no guarantees are made with regards to accuracy. It is advised that all details are checked prior to making a booking. Contents © 1999 - 2012. All rights reserved.
