Microsoft Access is the database management system that is included with the Microsoft Office suite or office 365. It is a program that helps you manage a large amount of data even better than Microsoft Excel can. Many people don’t know how to use Access, and may even be afraid of it. This webinar will really show you the ins and outs of using Microsoft Access tables and queries. Even though Excel gives you some great ways to handle your data, with Access you will be able to handle large amounts of data. If you handle large amounts of data, this webinar will help you tremendously.

Topics: Tour of the Access screen using design view to create a table the lookup wizard importing tables from other data sources linking tables to other data sources exporting data from access into other data types creating table relationships database tools sorting and filtering a table basic queries prompting the user for the criteria calculated field queries totals query using multiple tables in a query viewing the SQL code query wizards subqueries append, make a table, update, and delete queries showing a certain number of records in a query.

Creating a form with auto form using the form wizard changing a form with design view adding form controls subforms creating reports with the auto report using the report wizard changing a report with design view adding calculations grouping, sorting and adding totals to reports using the label wizard form and table properties exporting a report to excel using the switchboard manager to create a nice menu finalizing the application.