Outlines

Course Objectives

The objective of a Microsoft Access intermediate course is to provide participants with a more advanced understanding of the features and functionality of Microsoft Access, a popular database management system. The course typically covers topics such as:

• Creating more complex queries to extract data from tables and other sources.

• Designing more sophisticated forms and reports to display and present data.

• Working with macros to automate repetitive tasks and create custom menus and toolbars.

• Integrating Access with other Microsoft Office applications, such as Excel and Outlook.

• Enhancing database security by setting user-level permissions and implementing other security measures.

• Managing relationships between tables to ensure data integrity and accuracy.

By the end of the course, participants should have a solid understanding of these concepts and be able to apply them to real-world situations. 

Course Outline

Module 1 : Query

• Create Select query using design view

• Sort data

• Hide a field

• Set Criteria

• Create Select query using wizard

• Set multiple criteria

• Create calculation query

Module 2 : Form Design

• Create a form using wizard

• Form views

• Create label control

• Select, resize and move controls

• Formatting controls

• Formatting form

• Insert date

• Create a form in design view

• Control properties

• Form properties

• Create a form using autoform

Module 3 : Report Design 

• Create a Report

• Create a calculated fields

• Create mailing labels