Microsoft Access 2003 – Fundamental-Intermediate

Request info

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

SELECT wp_posts.*, wp_p2p.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_p2p WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'start_date' AND CAST(wp_postmeta.meta_value AS DATE) >= '2024-06-13' ) ) AND ((wp_posts.post_type = 'schedule' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled'))) AND (wp_p2p.p2p_type = 'schedule_to_courses' AND wp_posts.ID = wp_p2p.p2p_from AND wp_p2p.p2p_to IN (SELECT wp_posts.ID FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (121) AND ((wp_posts.post_type = 'courses' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled'))) ORDER BY wp_posts.post_date DESC )) GROUP BY wp_posts.ID ORDER BY CAST(wp_postmeta.meta_value AS DATE) ASC