Training Course:Access advancedSchool/Trainer:City Lit
London, United Kingdom
Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced
Course Description:
'' Learn the more advanced features of databases - relationships, data validation, advanced form design, subforms, multiple queries, advanced reports, macros and switchboard. Knowledge required: beginner’s course or equivalent experience. See also ’ECDL advanced: Excel’.
What is the course about?
The course builds on the Access Beginners course. You will be introduced to some of the more advanced features and explore macros for automating tasks. You will be given prepared files for use and will not be required to enter large amounts of data.
--------------------------------------------------------------------------------
What level is the course?
You should have completed the Access for Beginners course or have equivalent knowledge. If you have not done the Access beginners course, please check the course outline to see that you are familiar with what was covered.
--------------------------------------------------------------------------------
What will the course cover? (contents,themes,projects)
Cascade update and delete relationships.
Advanced table features.
Queries using multiple tables, parameter queries, action queries.
Advanced form design features.
Subforms, command buttons.
Reports using groups and expressions using multiple tables.
Macros.
Switchboards.
--------------------------------------------------------------------------------
What can I expect to achieve?
By the end of this course you should be able to:
Understand the need for data analysis as a prelude to setting up a database.
Understand more fully the role of forms and developed additional form functionality.
Understand the need for and use data validation to ensure accurate data capture.
Formulate complex queries to extract and manipulate data.
Produce reports which group and sort data transforming data into information.
Use macros to automate functions and processes.
...''
Please go to the school's official website for training price and schedule:
http://www.citylit.ac.uk
Phone:020 7831 7831
School Address:
City Lit, Keeley Street, London WC2B 4BA
Jobs & Resumes: London
Houses & Roommates: London
Other training courses offered by City Lit:
Performance dance workshop
Tango argentino
Tap workshop
Circus skills
Clowning and performance
Physical comedy and clowning
Stand-up comedy workshop
Theatre workshop
Drama foundation
Actors workshop
Access database project with Visual Basic
web design (HTML) and hosting
Apple Works OSX
Illustrator CS
ECDL advanced - Access
ECDL advanced - Excel
ECDL advanced - Word
ECDL certificate
QuarkXPress
Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
Facts:
We provide free training course catalog service since 2003, in English and Chinese. Tens of thousands of visitors search our database from our portal and partners' websites each day. |
|
|
