Microsoft Access and Microsoft Excel work together seamlessly. However, they are VERY DIFFERENT programs. It is very easy to exchange data between the two programs. But there is a world of difference when in it comes to storing, entering, and analyzing data in each program.
Recently, a number of my viewers have asked me how to create Data Forms in Excel. In almost every case, they want a simple answer – one that does not require them to learn VBA – Visual Basic for Applications. My considered response is that Access is the best way to collect and relate data via Forms. And then, use Excel to analyze the information that you collect from those data forms.
Here is a short – 6 1/2 minutes – video tour of my DVD-ROM, “The 50 Best Tips for Access 2007.” If you have never used Microsoft Access, this video will give you an idea of how it works. If you have tried to use Access, but gave up in frustration, I am confident that my video tutorials will help you to get over the learning curve so that you can use Access to its full potential!
Nine Categories of Video Tutorials for Access 2007
On my DVD-ROM, I have organized the 50 Video Tips into nine categories of lessons:
- Getting Started with Access 2007 – 9 Videos. Perfect introduction for new users of Access as well as a quick guide the the changes and additions in Access 2007 and Access 2010.
- Working with Tables in Access 2007 – 5 Videos. Tables are the essential building blocks in Access. Learn how to create many focused Tables and then create relationships between them.
- Using Filters & Queries in Access 2007 – 8 Videos. Filters are “temporary” or one-time questions. Queries are “saved” or “named” questions about the information in your database.
- Running Action Queries in Access 2007 – 4 Videos. Action queries allow you to quickly make changes to the data in Access. You can update, or delete records; append records or make a new table from a query.
- Working with Access 2007 Forms – 9 Videos. Forms are very easy to create in Excel. Use forms to enter data or to view your data – one record at a time. Gather data via Forms in Access and then export this data to analyze in Excel.
- Working with External Data in Access 2007 – 4 Videos. Did you know that you can use Access to semi-automatically update your Microsoft Outlook contact information? Learn how to integrate the programs in the MS Office Suite.
- Working with Access 2007 Reports – 5 Videos. Reports are designed for printing and distributing the summarized information in you Access database. Learn how to create a mailing label report for your next direct mail campaign!
- Managing Access 2007 Databases – 3 Videos. Learn how easy it is to back up your database. You can even “split” a larger database into smaller, more focused databases.
- Automating Access 2007 – 3 Videos. Learn how to use Macros and Command Buttons that allow less-experienced end-users enter and output the information in your Access database.
Table of Contents for “The 50 Best Tips for Access 2007.”
Purchase my DVD-ROM – “The 50 Best Tips for Access 2007”
To learn more about my DVD-ROM, I invite you to visit my secure online shopping website – http://shop.thecompanyrocks.com I guarantee your satisfaction 100%. If you are not satisfied with any of my products, you may return them – without questions – at any time!
Watch Video in High Definition
Follow this link to watch this video lesson in High Definition – on my YouTube Channel, DannyRocksExcels
Video Tour of my DVD-ROM, "The 50 Best Tips for Access 2007" [ 6:32 ] Play Now | Play in Popup | Download (1268)
will it teach how to dreate a switch board 9template0
Hello Jimmy –
Yes, one of the 50 Tips is focused on how to create a Switch Board Dashboard.
Thanks for your interest in my DVD-ROM, “The 50 Best Tips for Access 2007.”