MS Access

What is Microsoft Access 2007?

Unlike the other programs available in the Microsoft Office 2007 Suite, Access 2007 is largely unused by home users. Here is a simple introduction to Microsoft’s desktop database application.

Published by John Garger (20841 pts) on Oct 31, 2009 to
Windows Platform Articles
Microsoft Access 2007 Tips: Spruce Up Your Custom Switchboard Form

This is Part 3 in our series on Microsoft Access Switchboard forms. In Part 2 we demonstrated how to create a custom switchboard form. This article shows how to add the finishing touches that improve the look and usefulness of a custom switchboard.

Published by Curt Smothers (6121 pts) on Oct 14, 2009 to
Windows Platform Articles
MS Access 2007: Create an Application with a Custom Switchboard

The first article in this series shows how to use MS Access’ built-in Switchboard Wizard. This article goes a step beyond the restrictions of the ready-made switchboard and shows how to create a custom switchboard using a blank form.

Published by Curt Smothers (6121 pts) on Oct 11, 2009 to
Windows Platform Articles

Microsoft Access 2007: How to Create a Tabbed Form

A database form, particularly one with many fields, can quickly become cumbersome and cluttered. By adding tabs to the form structure, you can make the MS Access form more functional and attractive. This article shows your how.

Published by Curt Smothers (6121 pts) on Oct 8, 2009 to
Windows Platform Articles
FileMaker Pro 10 for Windows: Importing Data to a New FileMaker Database

Importing tables of data to a new FileMakerPro 10 database is a straightforward and intuitive process. However, it does require some advance planning both at the data export and import phases. Read this article before you attempt to import a table of data into a new FileMaker database.

Published by Curt Smothers (6121 pts) on Oct 7, 2009 to
Windows Platform Articles
MS Access 2007 Tips: Switch From a Database Report to a Record

MS Access 2007 database reports can display our records in an endless variety of ways. However, there is no automatic method to navigate to a record. This article shows a quick way to go from a report directly to any of its underlying records by using a query, a macro and a command button.

Published by Curt Smothers (6121 pts) on Oct 5, 2009 to
Windows Platform Articles

MS Access 2007: Calculating Mean, Median and Mode

MS Access has built-in mathematical functions to crunch numbers. For statistical data, however, the only handy function is the mean (average). Calculating median and mode, however, requires Visual Basic coding. This article shows some easier ways for calculating statistical functions in Access.

Published by Curt Smothers (6121 pts) on Sep 20, 2009 to
Windows Platform Articles
FileMaker Pro 10 for Windows: Designing Fields and Data Tables

Filemaker Pro 10 for Windows is a robust, user-friendly database that is a cross-platform (Mac/PC) alternative to Microsoft Access. This article demonstrates how to design database fields and tables in FileMaker.

Published by Curt Smothers (6121 pts) on Sep 20, 2009 to
Windows Platform Articles
Microsoft Access 2007: How to Create Dependent Combo Boxes

A combo box is a list of selections that we can attach to a Microsoft Access field. Creating dependent combo boxes and attaching them to fields can result in “cleaner” and more consistent data entry. This article shows how to create combo boxes in MS Access 2007.

Published by Curt Smothers (6121 pts) on Sep 16, 2009 to
Windows Platform Articles
MS Access 2007 Online Learning Resources

Learn MS Access 2007 on line at no cost. Databases in general, and Microsoft Access 2007 in particular, have a rather steeper learning curve than other computer applications. It is fortunate, then, that there are so many online learning resources. This article discusses a few of the best.

Published by Curt Smothers (6121 pts) on Sep 7, 2009 to
Windows Platform Articles