Microsoft Access

Sorted by:  

Microsoft Office 2013 Mouse Button Functions

You can control Microsoft Office 2013 with your mouse or your keyboard. The mouse actions in this table work whether you're using Word, Excel, Access, PowerPoint, or Outlook. [more…]

Microsoft Office 2013 Ribbon Tabs

Microsoft Office 2013 displays commands in a series of icons stored on different tabs. This combination of icons and tabs is known as the Ribbon interface, which appears in Word, PowerPoint, Excel, Outlook [more…]

Navigating the Access 2013 Ribbon with Key Tips

If you find that keyboard shortcuts increase your productivity when entering data, Access 2013 has a Key Tips feature you might like. Here's how you use it: [more…]

Handy Access 2013 Keyboard Shortcuts

These keyboard shortcuts are especially useful in Access 2013. Some keystrokes work anywhere in Access 2013, whereas others work only in specific views, as noted. [more…]

Access 2013 For Dummies Cheat Sheet

Access 2013 makes managing data easy, enabling you to set up a database quickly, enter records into that database, and then use the data however you like. With Access 2013, you can organize data into tables [more…]

How to Set Table Relationships in Access 2013

If you want to build a table relationship in Access 2013, you must first open the Relationships window. You do that by following these steps: [more…]

How to Import Data Sources in Access 2013

Access has some great wizards that make the importing process easy. Here are the steps for importing or linking data sources to your Access database: [more…]

How to Run the Query Wizard in Access 2013

With Access' Query Wizard, you enter table and field information, and the Simple Query Wizard takes care of the rest. Here's how you create a query: [more…]

How to Start the Report Wizard in Access 2013

The Report Wizard requires a few more decisions from you than the Report tool, but it’s more flexible than the instant Report tool. Here goes: [more…]

How to Create a Navigation Form in Access 2013

Access 2013 provides several layouts for Navigation forms; which one you choose depends on what you need done. Here’s how you build a Navigation form: [more…]

10 Things You Need to Know about Relationships in Access 2013

Relationships between fields, tables, records and so on are the most common things you deal with in Access 2013. Keep these ten tips in mind: [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…]

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

How to Create a Crosstab Query in Access 2010

In Access 2010, a crosstab query lets you combine two or more fields to compute and display a calculation based on a third field. The Crosstab Query Wizard makes it easy to arrange your Access database [more…]

How to Use the Access 2010 Report Wizard

The easiest way to create a report in Access 2010 is to use the Report Wizard. It guides you step-by-step through arranging and selecting which Access data to print on a report, along with sorting your [more…]

How to Customize the Quick Access Toolbar in Office 2013

You can customize the Quick Access Toolbar in Office 2013 programs to include the options that you use most often. You can decide whether the Quick Access Toolbar so it shows up either above the Ribbon [more…]

How to Create and View Queries in Access 2013

You can create a query in Access 2013 to remember a sort or filter preference that you use frequently. Use the Simple Query Wizard to create a query that shows you just a few fields of data [more…]

Sign Up for RSS Feeds

Computers & Software
Enter now for a chance to win a book bundle and $100