Database Design Specialists

Bringing ideas together, creating new possibilities.

Access Database User Group

A Special Interest Group of the New Mexico Computer Society
Meets 1st Tuesday of the Month, 6:30pm at the Department of Health 17th floor, NE Corner of San Mateo and Central in Albuquerque.

Contact: Neal Mazer for more information

Search for Topics       

Date Program Title Presenter Details
07/01/03 Query Presentation with some code Neal Mazer Demonstrate queries examples and how to create your own via code. Add a form and a user can select query parameters from drop downs. (Presentation will soon be available)
06/03/03 Introduction to Programming Final Segment Neal Mazer This month we finished up a presentation on programming in Microsoft Access.
05/03/03 Introduction to Access Programming - Part 3 Neal Mazer Our presentation entitled "Introduction to Access Programming" continues into it's third month thanks to the fact that the presentation is somewhat group self paced. Intended as a beginning guide to programming and introduces entry level concepts and examples to help you start using VBA.
04/01/03 Introduction to Access Programming - Part 2 Neal Mazer
03/04/03 Introduction to Access Programming Neal Mazer A beginning guide to programming that will introduce entry level concepts and examples to help you start using VBA.
02/04/03 First Access Application Michael Knoepfler Michael discussed his newest (and also first) Access application. Not only was it an impressive first effort, but, once all the functional details were brought out, it provided a rich forum for discussion.
02/04/03 Short Subject: Nested Tabbed Pages Judy Picard Judy showed us how to place one tab control on another. Click here for the pdf version of the instructions.
01/07/03 Restrict user access to your application. Neal Mazer Prevent users from gaining access to your applications as additional security and to prevent unauthorized changes that may prevent your app from running as designed. Download
12/03/02 Access Form Design Judi Picard Judi will show her ideas on good user interface design.
11/05/02 Back to Basics, Table Relationships Martin Haagmans Using a simple doctor, patient, appointment scenario, Martin will talk about the most effective ways to think about table relationships and, even more interestingly, how Access thinks about them.
10/01/02 Automating Back-End Database Changes with Distributed Databases Rayo McCollough, Martin Haagmans I usually cringe when I have to make structural changes to a database that's already deployed. Sometimes I can go to the customers site and make them myself, or talk a competent person into doing them. That's not always an option. Martin Haagmans and I were working on an Access 2000 project I inherited, that required updates to the back-end data file for a customer in Oklahoma. Martin talked me into writing some code and creating a form to automate the process. Since then we've had to use it several times and it's been a big success. I'll be demonstrating our technique.
09/03/02 Software to secure web sites Carlos Pizano www.elisar.com
08/06/02 AppQuest, User Interface Automation Software Kathy Zader, Tom Eytcheson, John Kesler Kathy Zader, Tom Eytcheson, and John Kesler of Dynamic Information Solutions, LLC will present AppQuest, a VB product that provides a complete user interface with auto-generated data entry screens, searching and menus. John and Tom started off as an Access Developers and realized they were rewriting basically the same application over and over. AppQuest was developed to automate the process of creating data entry forms and building in navigation and searching capabilities. I saw a demo of App Quest and was impressed. It's a great way to get a database user interface up and running quickly, and save a lot of development time.
07/02/02 OLAP with Access and Excel Hardin Brothers Hardin will present OLAP, a non-relational method of data aggregation designed/optimized for reporting and analysis. He'll explain what OLAP is and why it's a $6 billion/year industry. OLAP can empower users to develop their own management reports and find the "information" in their data. He'll also show off Data Analyzer, an Office Component. I always thought you had to have SQL Server for OLAP, but Hardin assures me this isn't so.
06/04/02 A History of Database Experiences in the Healthcare Industry Bob Hansen, Presbyterian Healthcare Bob has been working with databases in the healthcare industry for 17 years. Starting from Turbo Image (Cobol database) to DBase III to MUMPS on the mainframe, to Access on the desktop, and moving to SQL Server, Oracle, web-based reporting and Data Cubes. He'll talk to us about the evolution of databases from his perspective and how Access revolutionized data access by allowing users to get to and manipulate data without having to ask the IS Department for every report.
05/07/02 Using XML in VB apps to reduce maintenance and support costs Hank Racette XML has emerged as the new standard for data transfer. Hank will tell us about his experiences using XML in multiple aspects of VB applications, from Help Systems to Hierarchical Data Stores.
04/02/02 The Future of Access and Options - A Comparison of Database Software. Rayo McCollough, Judi Hotsinpilier, Martin Haagmans With the recent "deprecation" of the Jet database engine, and uninspiring new versions of Access, I and others have been wondering what the future of Access will be. Seems like Access has become the "weak sister" to SQL Server and all the database studs (and studettes) at Microsoft have gone to the SQL team. Where does that leave Access users and developers? Although no one has a crystal ball, especially when it comes to technology, I've asked our presenters to tell us the pros and cons of their software, including any suggestions on when to use it and when not to. Of course there will be time for discussion, speculation and questions.
03/05/02 Running Excel from Access Rick Berg We will see how to launch Excel from Access on the click of a button and send over some data from a query. Then we'll learn enough about the object model of Excel to enable us to perform simple calculations on the data, do some formatting, and create a graph based on the data. For all of this, we won't be inserting data into an existing spreadsheet that has the graph premade. Instead, we'll create everything from scratch.
02/05/02 User Customizable Questionnaire Neal Mazer Neal will show us a questionnaire database where the user can add questions and have the questionnaire form dynamically recreated to display the questions, by created and manipulating form fields with code. His code determines the type of field to display (text box, checkbox, etc.) based on user input. It also allows the user to choose different questions to show depending on the situation. Sounds like an interesting user customizable interface.
01/08/02 Access Security versus Roll Your Own Rayo McCollough Demonstration of both Access security and home made security systems and discussion of the pros and cons as I see them. Download an outline of the presentation and code samples (Access2000) used.
12/04/01 When Access Isn't Enough Hardin Brothers Access and its underlying data engine, JET, have definite limitations. Some of those are well documented, some are not, but sooner or later, you may run into them. When you do, you may want the information and views presented by Hardin Brothers at this meeting. Hardin will talk about when and how to move to the many different versions of SQL Server. He'll also discuss when to use Access and when to use an different User Interface tool with SQL Server and Microsoft's latest Office product, the Data Analyzer. He'll give us a short demo of how to set up a database in SQL Server and how to create a user interface for it using today's tools (Visual Studio 6) plus some discussion of tomorrow's tools (Visual Studio Dot Net).
11/06/01 Many things a non-programmer can do with Access Jay Stadler The database he'll present is for registering people for the many events offered by a Senior Center.
10/04/01 Smart Programming Practices (details) Greg Hansen Greg will be talking to us about smart programming practices for Access VBA. His talk will include: - naming conventions and why to use them, - how to write modular code (when and how to group code, create new modules) - basic coding practices. He'll also show us cool coding examples and tricks including: - highlighted menus - navigation routines for forms - edit and save form controls (enabling certain fields for edits) - simple security. Download an outline of the presentation and code samples (Access2000) used.
Greg Hansen, former editor of Computer Scene magazine, is a certified Access programmer, and owner of Distinctive Data Solutions, http://www.distinctivedata.com/. He specializes in MS Access 97/2000, Visual Basic 6, SQL Server 7 development. If you haven't ventured into writing code or are still fairly new at it, this talk should help you see what's possible and how to avoid bad habits.
09/06/01 Scientific Access Applications (details) Tom Ehrhorn "Access, it's not just for lists anymore." Everyone knows that Access is a great way to manage holiday card lists and membership rosters, DVD collection, personnel files, and hundreds of other data-intensive tasks. But, there is a lot more inside Access that not too many tap. Access contains a powerful development environment totally suited to "heavy" scientific programming. Our September speaker will share some of his experiences using Access 97 for not-so-common tasks: computing microbial growth rate over a million years, providing a front end and user interface for a materials degradation program, and computing the rate of radionuclide release from some buried waste.
08/02/01 Data Export from Access (details) Rayo McCollough I've been struggling with creating export files in various formats for clients lately and thought I'd share some hard earned lessons. I'll be showing a user interface for creating export files and the gotchas of using Access Export Specifications (ISAM's). If we have time (or I run out of things to say to quickly) I'll also show a user interface and technique for exporting report data to excel spreadsheets. Some clients love this because they understand Excel and can play with the data to their heart's content. If any of you have tricks or tips on data export, let me know and bring 'em to the meeting.
07/05/01 User Interface Design for Access (details) Dave Stelle David Stelle, will be discussing User Interface Design for Access. He'll show us what he's learned and be asking for our insight. He wants to get the user's perspective as well, so everyone can contribute/complain.
06/07/01 Writing and Implementing Add-Ins for Access (details) Neal Mazer Neal Mazer from the New Mexico Department of Health will demonstrate how to write an Access Add-In and implement it by using the Add-In Wizard and directly manipulating the Registry. He has written an improved Table Link Manager, which is available for download., New Mexico Department of Health
05/03/01 Tips And Tricks from the Masters (details) Rayo McCollough, Rick Berg, Hardin Brothers, Robert Greiff and Martin Haagmans Rayo McCullough, Rick Berg, Robert Greiff, Hardin Brothers, and yours truly, will show you some Tips and Tricks that are easy to use, but hard to find. Example: Did you know you can create a cover page for a report and even put a graphic on it? If you didn't, come join us and see how easy that is.
04/05/01 Freeware for Access (details) Martin Haagmans This month we'll take a look at some freeware available for Access. If you have a favorite, put in your 2 cents tomorrow and give me the URL so I can post it on our web site. We'll look at a form builder, a command wizard, a relationship documenter and a general database documenter.
Links to Freeware sites.
The Access Web (www.mvps.org/access)
Trigeminal (http://www.trigeminal.com)
AAD Consulting (aadconsulting.cjb.net)
FMS, Inc (www.fmsinc.com)
Links to Access Information sites.
Uncle Jim's Microsoft Access Tips
Woody's Access Watch<
Inside Access
Smart Access
03/01/01 Debugging ASP Pages (source code) Martin Haagmans The topic will be "Debugging ASP pages", by Martin Haagmans of DataWizards Computer Consulting, LLC. If you've been writing ASP pages, you know that debugging ASP pages proves to be anything but easy. I'll show you a little utility which I got out of the Visual Basic Programmers Journal (and modified to fit my needs), which helps a great deal when trying to chase a bug, or figuring out why you're not seeing what you thought you should see. It'll be a brief demonstration, but we can continue talking some more about Data driven Web pages, tools, tips, gotchas etc. I'll make the utility available on our web site http://www.datawizards.net after the meeting. . We also have a few give-aways/door prizes. Microsoft sent me a couple of T-shirts and some CDs with Beta versions of SQL-2000 and Studio.Net. Source code and documentation is available for download.
02/01/01 A Visit From an Old Friend, the Query. Martin Haagmans We'll take another look at queries. Starting with Queries 101, your basic meat and potatoes kind of Select Queries. And then we'll build up the suspense. The format will be through scenarios. Like what if the CEO of your company want to see who makes more money than he/she does? Or which salesperson's customers' orders start slacking off after 6 months of first sale? (There is a seminar on customer retention coming to town and the boss wants to send these salespeople there, in case you were worried she was going to fire them.) We'll spend a little time on Action Queries (Update, Insert and Delete). Time permitting, we'll take a look at differences between Access's (read JET) SQL syntax and SQL Server's SQL syntax.
01/04/01 Access2000 ADP Mode (Part 2) (source code and hand outs) Robert Greiff Part 2 of an exploration of Access2000 that Robert Greiff, a local authority on Access2000, gave back in August. It was about using Access2000 in ADP mode vs. MDB mode. Just to refresh your memory. The MDB (Microsoft DataBase) mode is the one that was always there and uses the JET database engine. The ADP (Access Data Project) mode was new in Access2000 and uses a SQL Server database. This is radically different, uses a very different data access technology (ADO vs DAO). Robert talked about ADO and the advantages and disadvantages of the ADP more as well as some security concerns that have been publicized lately. He explained the difference between the MSDE (Microsoft Database Engine), which ships with Office2000 Prof? and the full blown SQL Server.
Source code and documentation are available for download.