Microsoft Access is a great database program that is part of the Microsoft Office 365 Suite. It is very powerful and versatile. But, it is not the most intuitive program, and it has many hidden features that you should know to become more productive in using the program. This course will show you how to be more productive in Microsoft Access. Topics covered in this course: Creating a table from Scratch Changing a table’s design Adding a calculated field to a table Lookup Wizard Importing Linking Data Creating Table Relationships Creating a Query from scratch Creating a prompt Query Creating a calculated field in a Query Creating a Multiple-Table Query Totals Query Find Unmatched Query Find Duplicates Query Crosstab Query Using Autoform and the Form Wizard to make a form Adding Calculations to a Form Adding a Lookup to a Form Calling one form from another form Using Autoreport and the Form Wizard to make a Report Adding Totals to a Report Adding Calculations to a Report Creating a Sub-form Using the Label Wizard Creating a menu with the Switchboard Manager