Microsoft Access 2010

View:  
Sorted by:  

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…]

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…]

How to Create a Crosstab Query in Access 2010

In Access 2010, a crosstab query lets you combine two or more fields to compute and display a calculation based on a third field. The Crosstab Query Wizard makes it easy to arrange your Access database [more…]

How to Use the Access 2010 Report Wizard

The easiest way to create a report in Access 2010 is to use the Report Wizard. It guides you step-by-step through arranging and selecting which Access data to print on a report, along with sorting your [more…]
Advertisement

Sign Up for RSS Feeds

Computers & Software
Win $500. Easy. Enter to win now.

Inside Dummies.com