Mar 24

Starting an AutoNumber Field in MS Access with a Number You Want

In Microsoft Access tables, the AutoNumber field type allows you to automatically assign a unique sequential number to each row in a table. AutoNumber fields are often used as the Primary Key, since they are unique and permanent.

By default, AutoNumber begins with 1. However, you may want to start with another number. Here’s an easy way to set the AutoNumber at a number higher than 1.

(NOTE: This tip was revised on March 26, 2010 to fix a typo in the SQL syntax.)

Mar 24

Office Tip: Introducing Microsoft Office/Access 2010 and SkyDrive

Microsoft Access 2010The release candidate of Office 2010 is now available, and Office 2010 is expected to be shipping by mid-year. Hopefully you take the chance to download it, or at least review some of the many videos and articles about the new features.

For Access enthusiasts, the new version makes Access even more accessible to non-developers by exposing more functionality without requiring code or queries. For example, Reports are much richer, with added calculation tools and the ability to combine data from multiple sources. Microsoft has also created a whole new set of Templates to get users started more quickly, and what can be characterized as data triggers for Jet databases.

Most interesting is the ability to create solutions that can be exposed to the web. There are lots of restrictions and it’s not the same as putting an existing Access application on the web, but by leveraging SharePoint and cloud computing, it’s a whole new option for Access users and developers.

Part of Office 2010 is the Office Web Applications (OWA), a web version of Excel, PowerPoint, Word programs that allows you to create, edit and host Office files on the web without having Office installed locally. Microsoft is actually providing 25GB of space for you for free on their new SkyDrive site (with you Microsoft Live account).

Note: After losing a court case in the UK, Microsoft has renamed SkyDrive to OneDrive.

Mar 24

Paper: Microsoft Access Delete Query and SQL Syntax

Delete Query in Microsoft Access Could not delete from the specified tables.JPG

In our continuing coverage of query tips and techniques, we've create a paper focused on the DELETE query in Microsoft Access. It covers the basics of DELETE query SQL Syntax. It's a very powerful feature and a fundamental part of relational databases since you can remove multiple records at one time, and can specify which records to delete by linking to data in another table.

The paper also covers these more advanced topics:

  • Query fails: "Could not delete from the specified tables"
  • Use DISTINCTROW with Delete Queries for Non-Key Field Joins

Understanding and using Delete Queries improves the performance of your applications and makes them easier to maintain versus doing the same changes manually or in code.

Mar 24

Use Microsoft Access with Exchange/Outlook to manage email list removal

Microsoft Access Email BlasterTotal Access EmailerMicrosoft Access Email Microsoft Access

Many organizations use Microsoft Access to manage a list of email contacts. In conjunction with Total Access Emailer from FMS, it’s easy to send everyone a personalized email (such as a newsletter, order notification, or even a recipient’s individual invoice or sales receipt) in a convenient and automated way. Handling undeliverable emails and unsubscribe requests, however, can be tricky.

Read our new web page on Using Microsoft Access with Exchange/Outlook to Manage Email Lists and Automate Unsubscribe/Removal Requests.

Mar 22

Total Access Statistics User Manual for Microsoft Access

Total Access Statistics is the most advanced and popular data analysis program for Microsoft Access. Total Access Statistics makes it easy to calculate percentiles, regressions, confidence intervals, correlations, t-tests, probabilities, ANOVA, Chi-Square, etc. You can even normalize tables, rank records, and select random records, plus much more without any programming.

To maximize your use of Total Access Statistics for analyzing the data in your Microsoft Access databases, a professionally written and printed user manual is included. The user manual is 176 pages and fully indexed to make it easy to learn about Total Access Statistics, how to use it, definitions of its calculations, its programmatic interface, and tips for optimal use.

The Total Access Statistics user manual is now available for your review. Check it out to see how Total Access Statistics extends the power of Microsoft Access queries so you can analyze your data better than ever. To see it action with your own data, download the trial version.

Mar 03

Updated FMS Consulting Site for Microsoft Services

Microsoft Programming ServicesThe FMS Professional Solutions Group continues to create innovative software solutions that are making an impact on organizations and lives. Check out our updated consulting site to learn more about our solutions in action. See how we are making a difference from disaster relief in Haiti and Chile to the recent snowstorms in Washington DC. Here are some other highlighted solutions:

Let us bring this expertise to help you use data to make better decisions.