Access 2003 & Earlier

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

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

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

Creating a Primary Key in Access 2002

A table's primary key is a special field in your tables. Just about every table you create should have a primary key. Why? [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…]

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

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

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

Taking Your Access 2002 Report to the Design View Tune-Up Shop

The first stop in your quest for a better-looking Access report is Design view itself. After all, you can't change anything in the report until the report is up on the jacks in the Design view. Thankfully [more…]

Naming Database Fields in Access 2002

Of all the Windows database programs out there, Access 2002 has the simplest field-naming rules. Just remember these guidelines to make your field names perfect every time. [more…]

Using Office XP on Your Pocket PC

Laptop computers continue to drop in price and weight, yet increase in power. Some of the latest laptop computers weigh less than three pounds and have enough memory and processing power to run a full-blown [more…]

Solving the Mystery of the Disappearing Record in Access 2002

"The record was there — right there!" The key word in that sentence is the verb, because it indicates that the record isn't there now. Precisely where the record went is a moot point because only the computer [more…]

Improving Speech Recognition in Access 2003

It wasn't long ago that talking to your computer marked you as a disturbed person or a Trekkie — or both. Perceptions have changed. All the Office suite programs, including Access 2003, has the Lernout [more…]

Access 2003 Object Toolbar Buttons

The Database window of Access 2003 gives you, er, access to the Objects toolbar. You can then use the object to organize your database, initiate queries, and do all the functions you use Access 2003 to [more…]

Access 2003 Design View Buttons

With the Access 2003 Design View buttons, you can make your datasheet pages look like you want them to as well as make choices about what data and tools to display. The following table shows the buttons [more…]

Listings:1-2526-28

Sign Up for RSS Feeds

Computers & Software

Inside Dummies.com

Dummies.com Sweepstakes

Win $500. Easy.