Skip navigation

iTech

Microsoft Access

Access 2013

Quick Start Guide

Microsoft Access 2013 looks different from previous versions, so we created this guide to help you minimize the learning curve.

Quick Start Guide

What can I find on the Account tab?

Select File > Account in Access 2013 to manage your user information, change the background or theme, view and add available web services, display information about your Office products, and manage your product subscriptions.
Account tab

Where did the Back Up option go?

It's always a good idea to back up your important data. To do this in Access 2013, select File > Save As. Then, under Save Database As > Advanced, select "Back Up Database."
Back up option

Things you might be looking for

Use the list below to find some of the more common tools and commands in Access 2013.

  • To open, close, create, save, print, publish, or manage your database, select "File" and look in the Backstage view (select the links in the left pane).
  • To view objects, cut, copy or paste data, format text, add a totals row or find data, select "Home" and look in the Views, Clipboard, Sort & Filter, Records, and Text Formatting groups.
  • To add application parts, tables, queries, forms, reports, or macros, select "Create" and look in the Templates, Tables, Queries, Forms, Reports, and Macros & Code groups.
  • To bring in files or send data or link to external sources, select "External Data" and look in the Import & Link and Export groups.
  • To compact and repair a database, work with Visual Basic code, macros, relationships, and analyze or move data to SharePoint, select "Database Tools" and look in Tools, Macro, Relationships, Analyze, and Move Data groups.
  • To view and use the objects in the database, select the "Navigation Pane" and look in the All Access Objects group.
  • To correct file problems or add a password to a database, select "File" and look in the Info, Compact & Repair, and Encrypt with Password groups.
  • To create an access app, select "File" and look in the New, Custom web app, or web templates options.

What happened to the Pivot Chart feature?

You can't create pivot charts or tables in Access 2013, but you can import them from Excel and other applications, and then add them with the Chart control.
Pivot Chart feature

Long Text is the new Memo

If you are looking for the Memo data type for longer text fields, try the Long Text data type instead.
Long Text is the new Memo

What is an Access app?

Access apps are like web databases that you can use to view and share your data in the cloud. With Access apps, you'll have secure, centralized data storage and management options.

With Access 2013, you can easily create and modify the design of an app. Get started with an app template or create your own custom web app.
What is an Access app?

Template names that begin with the word "Desktop" will create a client database. To create Access apps, use any template that's marked with a globe icon.

How to work with people who don't yet have Access 2013

Here are some things to keep in mind when sharing or exchanging files with people who are using an older version of Access.

  • In Access 2013, when you open a database file that was created with Access 2007, you can open and use the file, but you will not be able to view or use features like Pivot Tables or conditional formatting. What you should do is import just the tables and reapply formats in Access 2013.
  • In Access 2013, when you save your database as an Access 2007 file, you will be able to open and use the database.
  • In Access 2013, when you save your database as an Access 2010 file, you will only be able to view it. You will not be able to modify it. If you published an Access 2010 database as a web database and want to later change it to an Access app, import the data into a custom web app.

What's on the Info tab?

From any open database, select File > Info.
Info tab

Compact & Repair Database can prevent and fix database problems or compact files to save space.

Files saved in Access 2007 or in a newer format are already encrypted, but you can add an optional password to further secure your data by selecting "Encrypt with Password."

Selecting "View and edit database properties" displays information about objects in the database, revision tracking, and database size. You can also change the database title, author, company, and hyperlink information from the "Summary" tab.

Can I convert my Access database into an Access app?

Though Access apps are also used for tracking data, you cannot convert a desktop database into an Access app or vice versa. However, you can use data from a desktop database in an Access app.

Select New > Custom web app > Create a table from an existing data source
Convert Access database into an Access app

Contact Us

iTech
103 Cook Library
118 College Drive #5181
Hattiesburg, MS 39406  

Hattiesburg Campus

Campus Map

Email
helpdeskFREEMississippi

Phone
601.266.4357

Contact Us

310 Fleming Education Center (FEC)
730 East Beach Boulevard
Long Beach, MS 39560

Gulf Park Campus

Campus Map

Email
helpdeskFREEMississippi

Phone
601.266.4357