Access 2010: Working with Databases

Access 2010: Working with Databases

In this video we’re going to talk about opening
and saving databases and objects. In Access, this works a little bit differently
from other programs like Word or Excel, and it’s important that you know how it works
before you start editing databases. We’ll start by opening a database. Make sure you’re in Backstage view. If there are any recently opened files, they
will appear here, and you can also click Recent to see more. But if you don’t see the one you’re looking
for, just click Open. And then you can double-click your file to
open it. You may get a warning message here, so if you trust the source of the database,
then click Enable Content. And if you don’t want to see the
warning message again, then you can click Yes to make it a
Trusted Document. Earlier I mentioned that Access is a little
bit different from other programs, and that’s because you’re not going to be
editing the database itself, but rather the objects within the database. Access treats each of these objects as separate
documents, and each one can be opened, saved and
closed individually. So you can think of the database as just a
folder of different objects. Let’s open a few objects. Just double-click on each one. I’ll open a table, a query, and I think I’ll also open a form, and a report. Each of these objects now has a tab on the
Document Tabs bar. If you make any changes, you’ll need to Save
the object before you close it. You can do that by clicking Save on the Quick
Access Toolbar. And this only saves the current object. And to close it, you can click the ‘x’ over
on the right. If you want to rename an object, you can just
right-click the name in the Navigation pane, and select Rename. And then type whatever name you want. To close the database, click the File tab,
and select Close Database. And in Access, you’re not going to be
saving your database because you’re saving each object individually. This may seem a little bit strange at first,
but as long as you remember to think of the database as a folder of objects,
then you’ll be okay.

Danny Hutson

7 thoughts on “Access 2010: Working with Databases

  1. @TheHaakO I'd suggest that you visit our website to be able to view all of the content we've created for our Access 2010 tutorial, which is above and beyond just videos. Specifically, if you go to Access 2010> Lesson 3> Page 7 (Challenge!), there is a link to the existing database that you can use.

    We also have free, online, instructor-supported classes you can register for. All of the content is the same but at the end, you'll receive a certificate of completion.

    Good luck! ^Jess

Leave a Reply

Your email address will not be published. Required fields are marked *