Microsoft Access 2003 – Advanced

Request info

Course duration: 1 Day

Course Overview:

This course covers some of the more complex aspects of building an Access Database. The topics included will help you to create a database for groups of users.

Course prerequisites:

Attendance of the Developing Course or familiarity of all topics covered at that Level.

1 day instructor led

By the end of this course you will be able to:

· Make your queries more powerful by using various types of queries to perform specific functions
· Query data from more than one table at a time to further improve and refine the results of information you are searching for
· Develop relationships that link data and observe the effects they can have when altered
· Develop and use more features within forms and further customise their appearance
· Develop more professional reports from your database by showing groups of information within a report and sorting the report results to make the data more useful
· Use Macros as a method of automating repetitive tasks and create macro buttons on a form making your database far simpler for your and your colleagues
· Set general passwords to ensure the security of your data
· Use the functionality of Microsoft Access in connecting to Microsoft packages such as Word and Excel

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-07-15' ) ) 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 (122) 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