Access 2013

Sorted by:  

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

Microsoft Office 2013 Keyboard Shortcuts

Microsoft Office 2013 provides hundreds of commands, but you'll likely only use a handful of those commands on a regular basis. To save time, use these Office 2013 keyboard shortcuts. With little effort [more…]

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


Sign Up for RSS Feeds

Computers & Software