Course duration: 2 Days
Course Overview
This course is ideal for people who wish to create their own databases. It will include creating tables & relationships, forms & reports and querying techniques. The syllabus for ECDL Module 5 and MOUS certification will be covered.
Course prerequisites
A working knowledge of Microsoft Windows
By the end of this course you will be able to:
· Understand the principles of database design and the associated terminology
· Create a database and all the associated elements.
· Understand how the structure of your database can improve information management
· Add to and alter elements of the structure of your database
· Understand Database Relationships and how they can affect data management
· Successfully organise your database to make locating information simpler and clearer
· Create Forms as a main view to accessing and inputting information
· Customise the appearance of forms to add a corporate feel
· Question your data buy using queries. Create and alter their design to improve the results
· Work with report tools to allow you to produce professional looking printouts
· Alter the layout of the reports to your preferences
2 Days Instructor Led