Sorted by:  

Securing Your Access 2003 Database as an MDE File

If you make an Access 2003 database for other people — especially people who may be a teeny bit clueless about Access — you may want to lock up your database to prevent other users from making changes [more…]

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

Taking Shortcuts with Macros in Office 2003

Many people dream of the day they can give orders to a computer by talking to it; the current reality is that you still have to type on a keyboard if you hope to use your computer at all. Because most [more…]

Integrating Access 2003 with Other Microsoft Office Applications

Visual Basic for Applications (VBA) isn't a programming language for Microsoft Access 2003 alone. It's a programming language for all application programs that support Automation. [more…]

Creating PivotCharts in Access 2003

You can display the information from any Access 2003 table, query, or PivotTable as a PivotChart. When you create a PivotChart, you actually create a special view of a form, and the PivotChart is stored [more…]

Finding Records in Your Access 2003 Tables

When you want to track down a particular record, creating a query is overkill. Fortunately, Access 2003 has a quick way to find one specific piece of data in your project's tables and forms: the Find command [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…]

Filtering a Datasheet in Access 2003

Filtering an Access 2003 datasheet is a way to focus on specific records, rather than all the records in a table. You can filter out records that aren't relevant to what you're trying to do at the moment [more…]

Pushing Your Access 2003 Data onto the Web

Now that Access 2003 contains all your coolest information, why not share your stuff with others in your company — or even publish it for the world? Whether you're building a commercial site geared toward [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…]

Focusing on Fields in Access 2003

A field is the place where your data lives; one field holds one piece of data, such as Year or Team.

Because there are so many different kinds of stuff in the world, Access 2003 offers a variety of field [more…]

Exporting Access 2003 Data to XML

For those of you who are already familiar with XML in Access 2002, note that the enhanced XML support in Access 2003 enables you to specify XSL (Extensible Stylesheet Language) transform files when importing [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…]

Creating Your Own Toolbar in Office 2003

You can create a new toolbar and put your favorite buttons on it. If you want, you can even create toolbar buttons for styles, fonts, AutoText entries, and macros. Follow these steps: [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…]

Customizing the Menu Bar in Office 2003

Because Office 2003 contains so many different commands, each menu title can display commands in one of three ways: [more…]

Working with the Task Pane in Office 2003

Sometimes when you choose a command in an Office 2003 application, such as the New command in the File menu, Microsoft Office 2003 needs more information from you before it can do anything else. In the [more…]

Making Sense of the Database Window in Access 2002

Most of the time when you open a database, it appears in a window like Figure 1. This window gives you access to all the stuff in your database, provides tools to change displays or create new items, and [more…]

Customizing the Office 2003 User Interface

Microsoft tried to create the easiest, most intuitive collection of programs in the world. Yet chances are good that the programs are still too complicated for most mere mortals to use and understand. [more…]

Sharing Data within Office 2003 with Smart Tags

When you type data into Word, Excel, or PowerPoint, Office 2003 can often recognize what type of data that might be, such as a date, telephone number, or a name. When Office 2003 recognizes specific data [more…]

Watching Out for Macro Viruses in Office 2003

Microsoft Office 2003 gives you two ways to create a macro. The simplest way is to record your keystrokes and then play them back when you need them. The harder way to create a macro is to use the Microsoft [more…]

Customizing Menu Commands in Office 2003

Office 2003 provides two techniques for customizing menus and menu commands. You can start from the Rearrange Commands dialog box or use the drag-and-drop method. Keep reading. [more…]


Sign Up for RSS Feeds

Computers & Software