Microsoft Access 2013 looks different from previous versions, so we created this guide to help you minimize the learning curve.
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.
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
Use the list below to find some of the more common tools and commands in Access 2013.
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.
If you are looking for the Memo data type for longer text fields, try the Long Text data type instead.
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.
Here are some things to keep in mind when sharing or exchanging files with people who are using an older version of Access.
From any open database, select File > Info.
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.
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