Microsoft Access Techniques—Beginner
This session is available as an online webinar (90-minute webinar) or an on-site session at your organization. Please contact us to request scheduling.
Who should attend?
This workshop is for business users who have been using Excel to manage lists of data, but want to take advantage of the powerful tools. Microsoft Access offers. Microsoft Access provides versatile tools for entering, visualizing, analyzing and understanding with data, and gives you the ability to create database applications that work just the way you want them to, maximizing business efficiency with convenience and ease.
This workshop is offered for users already comfortable with Microsoft Excel, but who have not worked with Access before. This class is conducted as public instructor-led webinars. It is also offered for corporate users in the form of corporate Webinars, and onsite training sessions.
Here are some of the key topics and techniques that are covered
Outgrowing Excel/What Access Can Do: How Access’ organization and presentation of information can improve upon the limitations of keeping data lists in a spreadsheet. Demonstration of custom forms, reports, and automation.
Basic Interface. How to create the different types of objects in Access, and where the various working tools can be found.
Tables. How Access manages data in columns and records. How to think about and organize your data in table form. Creating tables and relationships, different field types, primary keys.
Queries. How to search for just the data you want, using queries that return results from one table or many related tables.
Forms. How to create a visual representation of your data with an on-screen form that displays just what you want it to show, exactly as you want it to be shown. Sorting and filtering data by form.
Reports. Creating a ready-to-print report on your data, customized for the best visual impact. Grouping and Sorting within a report.