Microsoft Office Tutorials and References
In Depth Information
Opening a Database
Access 2007 introduced a new file format for Access, and Access 2013 uses
the same format. Access 2013, 2010, and 2007 create .accdb files, whereas
Access 2003 and older versions save databases as .mdb files.
Access 2013 can open databases created in Access 2003 and older versions —
in addition, of course, to those created in Access 2007, 2010, and 2013. If you
create new fields or objects that use new features in Access 2013, those
objects won’t work if you open the database later in an older version.
Saving in a different version
If you know someone who has Access 2003 or older and needs to use your
database, you can save it in Access 2002-2003 format or even in Access 2000
format. Click the File tab on the Ribbon to display Backstage View; then
click Save As to see your Database File Types options, which include Access
2002-2003 Database and Access 2000 Database.
You shouldn’t use the new-to-2013 features if you know that you need to
save the database in an older format.
I have that open already!
Access is a multiuser database, which means that more than one person can
open an Access database at the same time. The usual way that this works
is that several computers on a network (usually, a local area network in an
office) run Access, and all the computer users can open the same database
at the same time. Access keeps track of who’s doing what and prevents the
users from (virtually) crashing into one another. If two people are trying
to edit the same thing at the same time, the situation can be tricky; Access
locks out the second person until the first person is done with the edit.
For more information on multiple people using a database at the same time,
see Book VII, Chapter 2.
Creating a sample database from a template
If you want to look around in Access but haven’t created your first database
yet, you can create a ready-made database from one of the templates that
come with the program. Many templates reconfigure the Navigation Pane
and make other changes in the way that Access looks, so you need to give a
command or two to return Access to its usual appearance. Follow these steps:
1. Run Access, using one of the many methods described earlier in this
In Windows 7, you might click Start and choose All Programs ➪ Microsoft
Office ➪ Microsoft Access 2013. In Windows 8, just click the Access 2013
tile on the Start screen.