Covers Access® 2010 and previous versions. Demoed in Access 2010
Microsoft Access has become the software of choice for anyone who needs to organize, manage, store and share vast amounts of information. Organizations of all sizes can benefit from the ability to maintain data such as sales stats, inventory requests, customer records, employee information, mailing lists and much more. With so much information at your fingertips, are you using the power of forms to easily modify your data records? Are you customizing the reporting techniques available to present your data professionally and accurately?
With an application as powerful as Microsoft Access, you can easily store and manage a vast amount of data is one location. However, with so much data in one place, it can be intimidating to try to get the output you're looking for or draw accurate conclusions from the numbers. Forms allow you to quickly and easily view a graphic representation of all the information in a particular table, which can simplify the process of editing and adding data. Once you have manipulated your data as needed, Access reporting tools let you see the information you want in the format you want, for an effective presentation every time.
What You'll Learn
- The essentials of creating effective queries — and why they are the basis for forms and reports
- Tips for modifying data with queries, utilizing the functions of multi-table queries, and incorporating SQL to enhance your queries
- Forms basics and how you can make them work for you
- How to effectively utilize controls to get more from your forms
- Ways to quickly view, modify and add data to existing forms
- Secrets for creating and using multi-table forms with ease
- Tricks for consolidating data for accurate and appropriate summarization
- Troubleshooting tips that eliminate problem forms and reports
- Advanced techniques for improving the look and feel of custom reports
Who Will Benefit
Managers, team leaders, supervisors, administrative specialists, marketers, financial professionals — every Microsoft Access user who wants to get more from this powerful program!