Microsoft Access 2010/2013/2016/2019/365: Intermediate

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