Consider a few good things with Access to Word (mail merge), Excel (data presentation), and Outlook (calendar reminders, email, adding an Excel file). I could even get into the discussion late/early binding, and how to version proof your Automation.
Access allows developers to create dashboards that give database users greater insight into their data. Functionality built into Access allows developers to create the same look and feel that they get using expensive third-party programs. This presentation will describe how a customized Access application was built using colored text boxes and a set of gauges to help students prepare for a national test.
Our presenter, David Nealey, owns WordSmart Business Services, a local small business. He has developed Access applications for proposal development, project management, membership management, software requirements analysis, and test preparation. David also serves as Vice President of Marketing for a GIS consulting company in Parker where uses his applications to pursue new business and efficiently perform projects.
If "necessity is the mother of invention", then Microsoft Access add-ins should be getting a Mother’s Day card this year. Add-ins allow easy access to tools, created by you or someone else, in virtually all of your database projects. Aaron will be showing some Access add-ins that he created. (And maybe a couple that he stole.)
Our first presenter, Aaron Kogan, is the owner of SLM Data LLC. He has been developing databases for the National Park Service, The Nature Conservancy, The Maui Invasive Species Committee and many other companies since 2000. Aaron also dabbles in Geographical Information Systems (GIS) when he has a free moment. Aaron can be contacted at Aaron@SLMData.com or check out SLM Data LLC’s website at www.SLMData.com.
Because the group likes seeing other member’s applications, Sco will be demonstrating another one of his production Access applications. After an introduction to the application and a walkthrough of how it works, Sco will show some of the not-so-everyday code used in this application.
Our second presenter, M. L. “Sco” Scofield, is a Microsoft Access trainer and consultant in Denver, Colorado. He is an active member and past President of our group. Sco is also a frequent speaker at our group. He has been using Access since version 1.0. Sco spends a large amount of his time as an instructor training all levels of Access from the introductory level all the way through advanced programming. He is a “Microsoft Certified Solution Developer,” a “Microsoft Certified Professional,” and is A+ certified. Sco was awarded the prestigious “Microsoft MVP” award from 10/1/2001 through 10/31/2005 in recognition of the time that he has spent helping Access users in the Access newsgroups on the Internet. See Sco’s company profile on our DAAUG web site Consultants list at www.daaug.org/consultants.asp and on his web site at www.ScoBiz.com. Contact Sco at Sco@ScoBiz.com.
No member of the traditional Microsoft Office suite of products has been affected more by SharePoint integration capabilities than Access 2007. Developers have a whole new set of tools at their disposal to share, collect, or store Access data on corporate SharePoint web sites. New SharePoint integration abilities make an entirely new type of solution possible where Access 2007 serves as a desktop client for information and workflows stored on a SharePoint server. These Access/SharePoint solutions will be easy to build, offer a wide range of desktop and browser functionality and provide powerful off-line capabilities.
The presentation will include:
Our presenter, Cliff Burton, has enjoyed a career spanning twenty years of Information Technology experience as a developer and consultant. He has been an architect for SharePoint solutions and implementations since 2004, but his current focus is on providing business process automation solutions based on the Microsoft Office 2007 and SharePoint platform. He has created a company, BPFast LLC, dedicated to rapidly delivering cost effective custom business solutions with Office 2007 and SharePoint and is actively involved in providing services, managing, and developing people for BPFast LLC. His web site is www.BPFast.com.
Have you ever wondered how the Office Fluent interface can into being? Jensen Harris, Principal Group Program Manager Office User Experience Team, made a presentation at Microsoft's MIX08 conference this year titled "The Story of the Ribbon." He talked about the general design process they used to come up with the Office 2007 user interface, to iterate on it, and to evaluate it. As part of the discussion, he showed for the first time some of the early prototypes they worked on (and abandoned or refined) along the way.
We will be playing the video of Jensen's presentation this month.
See a demonstration of the various techniques used in creating an automatic-grading educational application. Some of the topics discussed will be: How to use unbound forms, and how to process data imported from other applications, and how to create and export objects into VBA created databases.
Our presenter, Louie Walker, Jr., is an Accounting Professor Specializing in teaching Accounting Information Systems. Currently developing an Access 2007 automatic grading application to be used by college/University Professors. Louie Walker, Jr. was founder, President and CEO of TriSys Software Solutions, Inc. He has over 25 years of business and IT industry experience. He has a BA, from Colorado State University and a MBA in information systems from Regis University. He was a two-time president of the Denver Area Access Users Group. He has been using and developing with MS Access since version 1.0 and developing with SQL Server since version 7.0.
Kevin will give a brief overview of what comes in the package with SQL Server. Then he will dive into What’s new in SQL 2008.
Our presenter, Kevin Cox, Microsoft, has been working in the database field for over 30 years, of which the last 20 with SQL Server. He is currently a member of the Microsoft SQL Server product group in the Customer Advisory Team. In this job, Kevin feels very lucky to be able to work on the largest database projects in the world.
Learn how to use Access to rapidly prototype applications that can save the world! OK maybe they won’t save the world, but they can impress your clients or boss. This month Kevin will show off a prototype he worked on for a local franchise with 70 locations across the US and soon Canada. By combining several different Access tools, creating a few custom forms, and focusing on the short comings of the current platform they created an impressive demo that went well beyond the traditional smoke and mirror presentation.
Our speaker, Kevin Bell, has been developing custom business solutions for over 15 years, since the days of Access on 1.0 and SQL Server 4.21. Over the years he and his partner Wendell, have deployed more than 100 production databases in Colorado and other cities around the world. Visit his web site at www.accessui.com to learn more.
Long-time member Kevin Bell is joining the Microsoft Access Development Team in Redmond this November and he has offered to listen to our opinions about where we think the future of Microsoft Access should take us. If you have an idea that would make Access easier for developers or users or if there is a great feature that you’ve seen in other products that is missing from Access, let Kevin know. While there is no guarantee of adding any idea or suggestion to Access, Kevin will take your feedback with him and do his best to get them implemented.
Our speaker, Kevin Bell, has been developing custom business solutions for over 15 years, since the days of Access on 1.0 and SQL Server 4.21. Over the years he and his partner Wendell, have deployed more than 100 production databases in Colorado and other cities around the world. Visit his web site at www.accessui.com to learn more.
In March, Aaron showed us some of his Access Add-ins. Add-ins allow easy access to tools, created by you or someone else, in virtually all of your database projects. This month, Aaron will be showing some more of the Access add-ins that he has created.
Our presenter, Aaron Kogan, is the owner of SLM Data LLC. He has been developing databases for the National Park Service, The Nature Conservancy, The Maui Invasive Species Committee and many other companies since 2000. Aaron also dabbles in Geographical Information Systems (GIS) when he has a free moment. Aaron can be contacted at Aaron@SLMData.com or check out SLM Data LLC’s website at www.SLMData.com.
The Denver Area Access User Group hosts its annual Holiday party on Novenber 20th. This is the annual "let your hair down" user group meeting. Holiday refreshments and goodie give-aways rule the evening.
This meeting is for members and visitors to meet, relax, and chat. Door prizes and an evening-long drawing highlight the gathering.
See you in January