Microsoft Access

View:  
Sorted by:  

How to Query an Access Database Table in Excel 2010

Excel 2010 can import data from an Access 2010 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…]

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

Access 2003 General Toolbar Buttons

Access 2003 displays different toolbars depending on the type of object you’re viewing and what you’re doing with it. The following table shows some of the most frequently used toolbar buttons: [more…]

Access 2003 Datasheet View Toolbar Buttons

When you’re looking at one of your Access 2003 datasheets, the Datasheet View toolbar buttons give you easy access to the tools you want to use to create new records, delete old records, and manipulate [more…]

Access 2003 All-in-One For Dummies Cheat Sheet

Access 2003 offers a wealth of ways to build and manage datasheets using the general toolbar buttons, the object toolbar buttons, the design view buttons, and the datasheet view buttons. [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…]

How to Create a Form that Appears When Access 2013 Opens

You can create an unbound form that appears when you open an Access 2013 database. Follow these steps to make your new form and the macro that will open the form automatically: [more…]

How to Convert an Older-Version Access Database to Access 2013

Access 2013 uses the same file format as Access 2007 and Access 2010 for storing its databases, but previous versions of Access use a different format. You can tell what version a database is by opening [more…]

Changing Form Controls with VBA in Access 2013

When an Access 2013 database form is open, you can use VBA code to change the contents and even the appearance of the form, from the big picture down to the individual controls. [more…]

How to Create a New Access 2013 Form

Want to make a brand new form in Access 2013? Here’s how — in less than ten steps — you can create and adjust your Access form to your liking: [more…]

Finding Alternatives to Access Data Projects

If you’re a user of Access 2000 through 2010, you may be familiar with Access Data Project (ADP) files — Access data files that provide access to SQL Server databases. Access 2013 drops support for the [more…]

Getting Help with Functions in Access 2013

Just seeing the name of a built-in function in the third column of the Access 2013 Expression Builder doesn't tell you much. You don't know what the function does or how you use it, but you can get instant [more…]

How to Keep Blank Pages Out of Your Access 2013 Report

Almost every Access user winds up with blank pages in a report; the blank pages appear in Print Preview. What causes these extra pages, anyway — and how do you get rid of them? [more…]

How to Filter Multiple Fields in Access 2013

If you want to filter multiple fields in Access 2013, the flexible Filter by Form feature is what you need. Although you can apply the filters to the various fields by using several different techniques [more…]

Designing a Relational Database in Access 2013

When you use a database program like Access 2013, you can’t just start entering data. Instead, you need to create a relational database design, dividing your information into one or more tables, each made [more…]

Tips for Choosing Field Types in Access 2013

When you design a database in Access 2013, you decide what type each field will be. Access provides 12 field types for you to choose among. Choose the field type that best describes the data you want to [more…]

Handy Access 2013 Keyboard Shortcuts

Some people would rather use the keyboard than the mouse, and Access 2013 has plenty of keyboard shortcuts for those people. The following keyboard shortcuts are especially useful in Access 2013. Some [more…]

Secrets of Access 2013 Database Design

Here are the Five Commandments of database design, whether you use Access 2013 or another database program. A well-designed database makes maintaining your data easier. [more…]

Finding the Right Access 2013 Tool for Keeping Garbage Out

If the data that goes into your database through tables and forms is garbage, any output or analysis you do with queries and reports will give you garbage too. Fortunately, Access offers lots of tools [more…]

Using Visual Basic for Applications Efficiently in Access 2013

When you’re automating an Access 2013 database application by using Visual Basic for Applications (VBA), you can get lost with a blank page to begin writing code. Where do you start? Here are a few simple [more…]

Sharing Data with Other Programs from within Access 2013

Access 2013 is a great database application on its own, but it also plays well with others, allowing you to display and retrieve data from several other programs. If a program supports Visual Basic for [more…]

Access 2013 All-In-One For Dummies Cheat Sheet

Access 2013 makes managing your data easy, combining a visual interface with the power of a relational database. Discover how to organize data into tables, design forms and reports for editing and presenting [more…]

Listings:1-2526-5051-7576-95

Sign Up for RSS Feeds

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

Inside Dummies.com

Dummies.com Sweepstakes

Win $500. Easy.