Access 2010 Managing Databases and Objects

Author: mety Nagm Labels::

Access 2010

Managing Databases and Objects


Access 2010
Each Access database consists of multiple objects that let you interact with data. Databases can include forms for entering data, queries for searching within it, reports for analyzing it, and of course, tables for storing it. Whenever you work with your database, you are working with many of these objects at once. Fortunately, Access makes managing these objects pretty easy.
In this lesson, you will learn how to to open and close databases, as well as how to openclose, and save objects.

Throughout this course, we will be using a sample database. If you would like to follow along, download  example and use it to follow the procedures demonstrated in this lesson.

Opening and Closing Databases

Launch video!Watch the video (2:25). Need help?
Before you enter data or otherwise modify your objects, you will have to open your database.

Watch the video to learn about managing databases and database objects in Access 2010.

To Open an Existing Database:

  1. Click the File tab. This takes you to Backstage view.
  2. Select Open. A dialog box will appear.
    Opening a databaseOpening a database
  3. Locate and select the desired database, then click Open.
    Selecting a database to openSelecting a database to open
  4. One or more warning messages may appear when you open your database.
    • If the database contains customized functions, a yellow bar with a security warning may appear below the Ribbon. If you trust the source of your database, click Enable Content for your database to display correctly.
      A security warning for a newly opened databaseEnabling customized functions and other content for the database
    • After enabling all content in the database, you may see a message asking if you want to make the database a Trusted Document. Click yes if you would like all content to be automatically enabled each time you open the database.
      Choosing to make the file a Trusted DocumentChoosing to make the file a Trusted Document
    • You may be prompted to Log In to the database. Select your name from the log in list. If your name does not appear, click Add User to enter your information.
      Logging in to a databaseLogging in to a database
If you have opened the existing database recently, it may be easier to look for your database in the short list that appears in the sidebar or to select Recent and choose a database from the list that appears.
Opening a recently opened database from the sidebarOpening a recently opened database 

To Close a Database:

  1. Click the File tab to go to Backstage View.
  2. Select Close Database.
    Closing a databaseClosing a database
  3. If you have any unsaved objects, a dialog box will pop up for each one asking if you would like to save it. SelectYes to save the object, No to close it without saving, or Cancel to leave your database open.
    Saving changes to unsaved objectsSaving changes to unsaved objects

Working with Objects

It's helpful to think of your database as a large binder or folder in which you store your data. The data itself is contained in database objects. Access 2010 treats each of these objects as separate documents, which means that you will have to open and save them individually in order to work with them.
You may have noticed that this lesson contains no instructions for saving a database. That's because you cannot save an entire database at once. Rather, you must individually save the objects contained within the database.

To Open an Object:

  1. In the Navigation Pane, locate the object you would like to open.
    Selecting an object in the objects paneSelecting an object in the Navigation Pane
  2. Double-click the desired object. It will open and appear as a tab in the Document Tabs bar.
    The newly opened object in the document tabs barThe newly opened object in the Document Tabs bar
By default, the most recently opened object will display in the main window as the current object. To view another open object, simply click its tab in the Document Tabs bar.
The currently open objectThe currently open object

Saving Objects

As in other Microsoft Office programs, you will be prompted to save any unsaved work when you attempt to close your database. However, it is a good idea to save your work as you go along. Saving your work often is the best way to ensure that you don't lose any information if your computer crashes.

To Save a New Object:

  1. Select the object you wish to save by clicking its tab in the Document Tabs bar.
  2. Select the File tab to navigate to Backstage View.
  3. Click Save.
    Saving a new object in Backstage ViewSaving a new object in Backstage View
  4. The first time you save an object, you will be prompted to name it. Enter the desired object name, and clickOK.
    Naming a new tableNaming a new table
To save an existing object, select save in Backstage View, or simply click the Save command in the Quick Access Toolbar.
Saving the current object with the Quick Access ToolbaraSaving the current object with the Quick Access Toolbar

To Close an Object:

  1. Select the object you wish to close on the Document Tabs bar.
  2. Click the  on the far right of the Document Tabs bar.
    Closing the current objectClosing the current object
  3. If there are any unsaved changes to the object, you will be prompted to save it. Select Yes to save, No to close it without saving your changes, or Cancel to leave the object open.
You can also close an object by right-clicking its tab on the Document Tabs bar. A drop-down menu will appear. Select Close to close that object, or Close All to close all open objects.
Closing all open objectsClosing all open objects

To Rename an Object:

  1. If the object you wish to rename is open, close it.
  2. In the Navigation Paneright-click the object you would like to rename.
  3. Select Rename.
    Renaming an objectRenaming an object
  4. Type the new name, then press the Enter key.
    The renamed reportThe renamed report



Blog Archive

Powered by Blogger.

I made these pages for me and my friends to help solving the problem we face regarding Computer & internet, if anyone wants me to answer a question or find out about some information please send me email and I will try to reply.*P.S. some of the article I wrote and the other I found on the internet I posted them in sprit of learning and shearing, please forgive me if you found something you don’t want to be in my blog, email me and I will delete them. Thank you for your interest in my pages.امل نجم Amal Nagm

banner 1 banner 2