Microsoft Access

Sorted by:  

Taking Your Access 2002 Report to the Design View Tune-Up Shop

The first stop in your quest for a better-looking Access report is Design view itself. After all, you can't change anything in the report until the report is up on the jacks in the Design view. Thankfully [more…]

Naming Database Fields in Access 2002

Of all the Windows database programs out there, Access 2002 has the simplest field-naming rules. Just remember these guidelines to make your field names perfect every time. [more…]

Using Office XP on Your Pocket PC

Laptop computers continue to drop in price and weight, yet increase in power. Some of the latest laptop computers weigh less than three pounds and have enough memory and processing power to run a full-blown [more…]

Solving the Mystery of the Disappearing Record in Access 2002

"The record was there — right there!" The key word in that sentence is the verb, because it indicates that the record isn't there now. Precisely where the record went is a moot point because only the computer [more…]

Improving Speech Recognition in Access 2003

It wasn't long ago that talking to your computer marked you as a disturbed person or a Trekkie — or both. Perceptions have changed. All the Office suite programs, including Access 2003, has the Lernout [more…]

The Microsoft Office Access 2007 Window

After you open Access 2007, and pass the Getting Started window, you’ll find these buttons, bars, and ribbons in the Access 2007 regular window to help organize, create and protect your data. [more…]

Helpful Tools in Access 2007

If you’re working in Microsoft Office Access 2007 and you need help, use these tools to find and sort specific information, manage your data, and answer general help questions: [more…]

Access 2007 All-In-One For Dummies Cheat Sheet

Working in Access 2007 is easier once you understand running the Access 2007 window and using tools to help manage your data and answer your questions. [more…]

Tips for Choosing Field Types in Access 2010

When you design a database in Access 2010, you decide what type each field will be. Here are tips for when to use which type of field. [more…]

Handy Access 2010 Keyboard Shortcuts

These keyboard shortcuts are especially useful in Access 2010. Some keystrokes work anywhere in Access 2010, while others work only in specific views, as noted. [more…]

Secrets of Access 2010 Database Design

Here are the Five Commandments of database design, whether you use Access 2010 or another database program. A well-designed database makes maintaining your data easier. [more…]

How to Keep Garbage Out of Your Access Database

If the data that goes into your database through tables and forms is garbage, then any output or analysis you do with queries and reports will give you garbage too. Fortunately, Access offers lots of tools [more…]

Using VBA Efficiently in Access 2010

When automating an Access 2010 database application using VBA, you can get lost with a blank page on which to begin writing code. Where do you start? Here are a few simple guidelines to follow that will [more…]

Sharing Data with Other Programs from within Access 2010

Access 2010 is a great database application on its own, but it also plays well with others. You can display and retrieve data from a number of different programs. If a program supports VBA, then you can [more…]

How to Design a Relational Database in Access 2010

When you use a database program like Access 2010, you can’t just start entering data. Instead, you need to create a relational database design, dividing your information into one or more tables, each made [more…]

Access 2010 All-In-One For Dummies Cheat Sheet

Access 2010 makes managing your data easy, combining a visual interface with the power of a relational database. Learn how to organize data into tables, design forms, and reports for editing and presenting [more…]

Navigating the Access 2010 Ribbon with Key Tips

If you like to use the keyboard as much as possible when you’re working with software, Access 2010 makes it somewhat easy to do that — somewhat because you need to use a special key in order to make the [more…]

Access 2010 Keyboard Shortcuts to Know

These keyboard shortcuts are especially useful in Access 2010. Some keystrokes work anywhere in Access 2010, while others work only in specific views, as noted. [more…]

Access 2010 For Dummies Cheat Sheet

Access 2010 makes managing your data easy, enabling you to set up a database quickly, build records into that database, and then use that data in several useful ways. With Access 2010, you can organize [more…]

Comparison Operators for Access 2007

The databases you build with Access 2007 are meant to be searchable — or what’s the point? In order to search through an Access database, you need to use comparison operators that will pull up the information [more…]

Access 2007 Key Tips

The Access Key Tips help you create and manage database information quickly and easily. The following figures show the process for using Access 2007's Key Tips feature: [more…]

Keyboard Shortcuts for Access 2007

The keyboard shortcuts available in Access 2007 give you the ability to do basic tasks, such as opening and closing the database quickly. It also gives you tools to accomplish nearly every job with the [more…]

Access 2007 For Dummies Cheat Sheet

With Access 2007, you can create multi-function databases — a task made even easier with the Access 2007 Key Tips feature. You also have a host of keyboard shortcuts to speed up any job. And, when you [more…]

Access VBA Programming For Dummies

Programming Microsoft Access with VBA can be a lot easier if you know the keyboard shortcuts for the most common commands and tasks and the most common bits of code that you'll use in the editor and immediate [more…]

How to Query an Access Database Table in Excel 2010

Excel 2010 can import data from an Access 2010 database table into a worksheet, a process known as making an external data query. After importing the data into Excel, you can then use the Filter buttons [more…]


Sign Up for RSS Feeds

Computers & Software