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