This is a panel discussion and question and answer session designed to let you get some insight into the dynamic world of Microsoft Access consulting.
Subforms in Microsoft Access are possibly the most effective way to represent one-to-many relationships to your users. DAAUG President, Jim Pilcher, will show you some of the standard practices and hidden surprises that are part of using Access subforms.
Our presenter, James Pilcher, is a prominent Microsoft Access developer in the Colorado–Wyoming region, having worked with Access professionally since its inception in the early 1990s. Jim’s company, DataOne, Inc., maintains a broad clientele base providing database solutions for local enterprises and large international companies. A frequent presenter at DAAUG, Jim is currently serving his sixth term as President of your Denver Area Access Users Group.
See Jim’s company profile on our DAAUG web site in the Consultant list and on his web site at www.DataOneDenver.com .
The last time that Sco showed some of his code snippets was December, 2004. This has always been a popular topic. As in the past, audience interest will dictate the direction of the presentation.
Our presenter, M. L. "Sco" Scofield, is a Microsoft Access trainer and consultant in Denver, Colorado. He is an active member and 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. When he is not training or consulting, Sco spends time helping other Access users in the Access newsgroups on the Internet. 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 he spends helping Access users.
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.
This month’s presentation will demonstrate an application that uses Outlook, Access, Word and Adobe (writer) to create a Bankruptcy (PDF) Invoice. This process reads and modifies Outlook forms while storing the information in an Access database. The process will then pull correct bill information from an Oracle database, calculate the percentage used for the bankruptcy invoice, do the calculations and finally create the appropriate Word and PDF files. A form will then display for the Analyst to verify/change the results and give the option to send the required PDF file back to the requestor.
Our presenter, Mike Nindorf, is currently employed at Sprint and has been automating business processes since 1985- yes, that is pre Windows. Programming knowledge base include VBA, Holos, Excel and SQL. An expert in data-mining and with innovative way of solving business problems, his most recent accomplishments include automating an automated tool that will unzip, balance and burn to CD "electronic bills" for over 2,000 customers per month.
It's not like we live on an island. In fact, even those who live on islands aren't limited to the island anymore. Access developers may now leverage all the power of the Internet from the comfort and convenience of their familiar VBA code modules. Learn how to use Microsoft Access with the Web Services Toolkit to do things like; validate email an address, retrieve stock quotes or display a random Hungarian proverb.
Danny J. Lesandrini, although having programmed in FORTRAN with a keypunch machine and punch cards over20 years ago, became bored and strayed from the path of technology. Then in the mid 90's, prompted by a friend to return to the field of programming, he dove head-first into Microsoft Access. Today, Danny is a Microsoft Certified Professional in Access, Visual Basic and SQL Server, has been programming with Microsoft development tools since 1995. He maintains a web site with free code samples at http://amazecreations.com/datafast and replies to all questions and comments sent to datafast@comcast.net.
If you are building Access applications for anyone other than yourself, you really need to restrict users from things that can break the application, or even destroy it. This presentation will look at a number of features in Access that provide security, and also explore securing your back-end.
After spending 27 years in the telecommunications industry, Wendell Bell began a consulting practice based on Microsoft products in 1991. With the release of Access, he began focusing primarily on database applications, and currently supports several clients in the Denver area, as well as applications deployed in Washington State, Texas and Nebraska. He also serves as a moderator of the WOPR Lounge Access forum.
NOTE: This month we have something different and unexpected for the presentation. We were able to get one of the Access Product Managers from Microsoft Redmond to talk to us this month, via Live Meeting about Access 2007.
Access 2007 provides developers with the ability to build much richer databases much more quickly. This session discusses new functionality for building client databases, and covers Access's new designers, new coding tools, the ability to create custom task panes, collecting data through email, and customizing the ribbon UI. In addition, we show the out-of-the-box "tracking applications" that will ship with Access 2007, and show some of the tools used to build those apps and that will ship in the Access Developer Extensions.
Our presenter, Michael McCormack, is a program manager at Microsoft Corporation working on the Microsoft Access development team. His team is currently working to enhance the overall usability in Access, with a personal focus on navigation, command structure (especially the ribbon) and the shell. Michael has worked at Microsoft since 2000, and prior to working as a program manager, Michael served as a software test engineer, and as a lab manager overseeing a large network. Previous projects include Microsoft Office Excel 2003. Michael holds a Master's of Science in Information Management from the University of Washington. Prior to working at Microsoft, Michael was a Microsoft Partner designing and developing Access Databases, and Visual Basic - SQL Server client server applications as a consultant and developer.
Remember how fun Show 'N Tell was in kindergarten? Well this month you can re-live a bit of your youth. Come to the Denver Area Access Users Group database Show ‘N Tell! We will have short presentations by three members who have volunteered to show off a few cool features in an Access database that they have created.
Duane Hanstein of Dynamic Association Mapping, (DAM) will demonstrate using Access to update a Geographic Information System GIS.
Jim August of CORE, Inc. will talk about his company's reliability database application.
Bruce Handley of Handley Computer Corp. will demonstrate some features of one of his company's products called ClientMinder.
Say goodbye to CommandBars, and say hello to the Ribbon! The Ribbon is at the core of the new user experience in Microsoft Office 2007. The Ribbon provides an innovative way to display and organize commands that improve usability and user productivity. In this session you'll discover how the Ribbon exposes a rich and flexible XML-based extensibility model in Microsoft Office Access 2007. You'll explore the new programming model, learn best practices, and see how to incorporate the Ribbon design philosophy into your applications. You'll look at backward compatibility for custom CommandBars in Access 2007.
Our presenter, Michael McCormack, is a program manager at Microsoft Corporation working on the Microsoft Access development team. His team is currently working to enhance the overall usability in Access, with a personal focus on navigation, command structure (especially the ribbon) and the shell. Michael has worked at Microsoft since 2000, and prior to working as a program manager, Michael served as a software test engineer, and as a lab manager overseeing a large network. Previous projects include Microsoft Office Excel 2003.
Michael holds a Master's of Science in Information Management from the University of Washington. Prior to working at Microsoft, Michael was a Microsoft Partner designing and developing Access Databases, and Visual Basic - SQL Server client server applications as a consultant and developer.
NOTE: This month's meeting is one week early because of the Denver Microsoft Office moving
Everything you ever wanted to know about database normalization and referential integrity.
Jim Pilcher is a prominent Microsoft Access developer in the Colorado front range area, having worked with Access professionally since 1992. A Microsoft Certified Professional, Jim’s company, DataOne, Inc., maintains a broad clientele base providing Access & SQL Server solutions for local enterprises and large international companies.
See Jim’s company profile on our DAAUG web site in the Consultant list and on his web site at www.DataOneDenver.com .
First Meeting at the NEW Denver Microsoft Office!
"Word Automation from Access" by Alan Ruff
How to build Word template forms, automate customer statements, and avoid Word automation pitfalls
Alan Ruff is a Microsoft Access Developer and IT Administrator Consultant in the Denver area. He has worked with Microsoft Access since the early 1990's and has an emphasis in Accounting. He currently has his own consulting business named "Ruff Group" which serves Denver area clients.
"A Variable Declaration Review and Class Module Properties" by M. L. "Sco" Scofield
During the July 2006 Report Tip presentation it became clear that the group needed a refresher on variable declaration, variable scope, and how to create class module properties. Do you know that Public doesn't always mean global? Do you know that you don't always need Property Let and Property Get to create class properties? This is a "back-to-the-basics" presentation of information that every VBA programmer needs to understand cold.
Our presenter, M. L. "Sco" Scofield, is a Microsoft Access trainer and consultant in Denver, Colorado. He is an active member and the current 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 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.
See you in January