Microsoft Access 2016 Advanced

The Microsoft Access 2016 Advanced will deal with the topics that have been covered in the Microsoft Access 2016 Introduction and Microsoft Intermediate courses but in detail. Delegates will be taught to improve upon the database structure by using the table analyser wizard and creating a junction table. They will also learn how to backup and maintain an Access database and how to use various tools. Delegates will learn how to create and modify Switchboards to switch over from one form to another without having to leave the Graphical Interface. They will also gain the knowledge to configure security options and access for multi-user environments. Finally, they will learn to automate tasks with VBA (Visual Basic for Applications) and Macros. They will conclude the course by learning to use Table Events.

• Module 1: Microsoft Access 2016 –Reviewing The Basics
  • Creating and Modifying Tables
  • Creating and Modifying Queries
  • Creating and Modifying Forms
  • Creating and Modifying Reports
• Module 2: Using Controls in Reports and Forms
• Module 3: Advanced Forms
  • Multi-Item Form
  • Split Form
  • Sub-Form
  • Using Application Parts to Create Blank Forms
  • Create A Navigation Form
• Module 4: Advanced Reports
  • Define Groups
    • Change Grouping Options
    • Create Aggregate Fields
  • Create A Sub-form in a Report
  • Create The Print Layout
  • Create Labels using the Label Wizard
• Module 5: Advanced Queries
  • Creating Crosstab Queries
  • Creating Sub queries
    • Adding and Removing fields to a subquery
    • Group Data using comparison operators
  • Save a Filter as a Query
    • Create Action Queries
  • Understand Advanced Query Modification
    • Group Data using comparison operators
    • Create Multi-Table Queries
    • Add Calculated Fields
    • Format Fields In A Query
    • Group Data Using Logical and Arithmetic Operators
    • Group and Summarize Data
• Module 6: Display and Share Data
  • Create a Chart using the Chart Wizard
  • Format A Chart
    • Modify Data Sources
  • Save A Database Object As another File Type
  • Print A Database Object
    • Print Reports
• Module 7: Importing Data
• Import Data Into Tables
• Append Records From External Data
• Import Tables from Other Databases
• Create A Database by Using Import Objects or Data from other sources
• Create Linked Tables from External Sources
• Module 8: Exporting Data
  • Export to Alternate Formats
• Module 9: Database Tools
  • Maintain A Database
    • Backup A Database
    • Recover A Database
    • Compact A Database
    • Repair A Database
  • Save A Database As A Template
  • Encrypt A Database
  • Configure Database Options
    • Set A Form As The Startup Form
  • Use Database Tools
    • Split A Database