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