23 Feb

Microsoft Tools: The Little Database That Could – Access!

Microsoft Tools: The Little Database That Could – Access!

Tuesday, February 23, 2016 (11:00 AM) to Tuesday, February 23, 2016 (12:00 PM) (Eastern Time)

User Group Virtual Event Special Interest Group
Beat Bucher, Steve Erbach


You're Registered!

Microsoft Access never caught on like Excel did... but it's been extremely useful in countless business environments and applications. In this session you'll see how powerful yet easy-to-use the Access Report Designer is. While it isn't as powerful as SSRS, it's easier to learn. Access has decent report design wizards; handles properties more intuitively than SSRS; and handles formatted output with much more flexibility and orderliness than Excel.

We'll show you the quirky things about Access, too, and give you the pros & cons of Access vs. Excel vs. SSRS. Microsoft Access fits in perfectly between the loosey-goosey, anything-goes Excel environment and the uptight but extremely powerful SQL Server Reporting Services. And we have a surprise or two in store for you – like how well it can interface with Dynamics GP! Don’t miss this session! Come see why you should be using Microsoft Access: The Little Database That Could!

This is a part of the OneSource Microsoft Tools webinar series.

The goal of the Microsoft Tools series is to spread education regarding Microsoft technologies to all of the Microsoft Dynamics user groups. All webinars are recorded and uploaded along with the power point deck to each user groups’ website under ‘Access Webinars On Demand’.

This is a Members-only event that will be shared with all Dynamic Communities User Groups: AXUG, CRMUG, GPUG, and NAVUG.

This webinar is also part of the System Administration Special Interest Group: Whether your role as System Administrator was on purpose or accidental, come to the front lines to swap experiences and stories from the trenches.

  • Who Should Participate: IT Professionals
  • Leader: John Lowther
  • When We Meet: Every Other Month
  • To continue your learning, become an active member of the System Admin Community: https://www.gpug.com/communities/community-home?CommunityKey=8c62b853-f702-42ed-8b8b-bc8a1afbfc84

Beat Bucher
Beat has been using Microsoft Dynamics Great Plains since version 7.x back in 2003. Learned up the ins & outs of the system, mainly by creating reports and Excel queries linked to the back-end of the Great Plains system. Migrated in one company the Manufacturing system from HLM (Horizon Light Manufacturing) to the Microsoft Manufacturing module with Forecasting and resource planning. Currently running GP2010R2 SP3 and working for the retirement of FRx 6.7 and Forecaster 7.0 as financial reporting solution to replace it with Management Reporter 2012. He has a very good knowledge of the Great Plains security model since the switch from the 'optimistic' mode in GP 9.0 to the 'pessimistic' mode where by default all the resources are denied to a new user. Beat was awarded in April 2015 the prestigious Dynamics GP MVP Award for his contribution to the user community over the past 10 years. He's currently working on the upgrade from GP 2010R2 to GP 2015 with the transition from the Business Portal 5.0 to the Dynamics GP Web client.

Steve Erbach