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.

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.

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.

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?

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.