Microsoft Access 2007

View:  
Sorted by:  

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

8 Commonly Used Queries in Access 2007

Queries are important keys that can help you create the types of forms and reports that you want in Access 2007. Here's a list of the eight commonly used queries: [more…]

Access 2007 Form and Report Tools

Creating your first Access form from scratch in Design View can seem a bit daunting. When you select this option, you're faced with a blank grid, a Ribbon full of strange-looking icon tools above it, and [more…]

Useful Functions in Access 2007

Even though Access 2007 has several built-in functions, you may not use more than a few of them in your reports. Still, if you don’t know they're available, you could miss many of the functions that you [more…]

Access 2007 Forms & Reports For Dummies Cheat Sheet

Using Access 2007 to create queries, forms, and reports can be simplified if you know commonly used queries in Access, form and report tools, and a few useful functions. With a powerful tool like Access [more…]

Advertisement

Sign Up for RSS Feeds

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

Inside Dummies.com