Creating a Calculated Field with Access 2007
A calculated field takes information from another field in your Microsoft Access 2007 database and performs some arithmetic to come up with new information. In fact, a calculated field can take data from [more…]
Using the Access 2007 Input Mask Wizard
An input mask helps to prevent users from inputting invalid data in an Access 2007 form or report. No doubt, you put a lot of time and effort into creating your Access databases. But all that time and [more…]
Querying an Access Database Table in Excel 2007
Excel 2007 can import data from an Access 2007 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…]
Adding and Removing Tables in Microsoft Access 2007
The simple interface in Microsoft Access 2007 enables you to add or delete database tables — after all, even seasoned experts forget things now and then. [more…]
Office 2007: Sharing Data with the Office Clipboard
Cutting, copying, and pasting data may be handy within the same file, but Office 2007 also gives you the ability to cut, copy, and paste data between different programs, such as copying a chart from Excel [more…]
Modifying Existing Queries in Access 2007 Forms and Reports
As you work with queries in Access 2007, you may find that the queries you create could use a bit of fine-tuning. Perhaps you want to pare down the results so you don't have to wade through so many records [more…]
Adding a Logo to Access 2007 Reports
If you want to add a nice touch of class to your Access 2007 reports, why not add your own logo? Most companies and organizations have logos they use to add an official-looking appearance to letterheads [more…]
Exporting Access 2007 Tables to Other File Formats
While every Microsoft Access 2007 object can be exported, exporting the data in a table or query to another program — such as a spreadsheet — is the most common export task. Exporting a table or query [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…]
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…]
Common Shortcuts in VBA-Access 2007
Knowing the most popular keyboard shortcuts in VBA-Access 2007 will help you work more efficiently. Use this shortcut chart until you learn the keyboard combinations and their functions: [more…]
Codes for Common VBA 2007 Tasks
This list shows you the most common jobs carried out in VBA 2007 and the code statements you need to type to complete the VBA task, so keep this list handy: [more…]
Access 2007 VBA Programming For Dummies Cheat Sheet
Using VBA (Visual Basic for Application) to program Microsoft Access 2007 is simplified if you use shortcuts for debugging code in VBA and perform common tasks in VBA editor and the VBA immediate and code [more…]
