1 / 12

Access Database Basics: Opening, Navigating, and Closing

This lesson will teach you how to start Microsoft Access, open existing databases, navigate within tables using mouse or keyboard, view tables in different modes, and close objects.

mhinkson
Download Presentation

Access Database Basics: Opening, Navigating, and Closing

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. After completing this lesson, you will be able to: • Start Access and open an existing database. • Move around in Access. • Open and close a table. (continued)

  2. After completing this lesson, you will be able to: • View a table in Datasheet view and Design view. • Navigate within a table using the mouse pointer. • Navigate within a table using the keyboard.

  3. Starting Access To start Access • On the Windows taskbar, click the Start button. • On the Start menu, point to All Programs and click Microsoft Access.

  4. Opening an Existing Database To open an existing database • If Access is not already open, start Access and, in the New File task pane, click one of the recently used databases listed there or click the More files link to open a dialog box to find the database. Or If Access is already open, click the Open button on the Database toolbar. (continued)

  5. Opening an Existing Database To open an existing database (continued) • Click the Look in down arrow and navigate to the location of the database that you want to open. • Click the database that you want to open and click Open.

  6. Using the Office Assistant To display the Office Assistant 1. On the Help menu, click Show the Office Assistant. To hide the Office Assistant • Right-click the Office Assistant and then click Hide on the shortcut menu that appears.

  7. Moving Around in Access To move around the Database window • On the Objects bar, click the type of object for which you want to view a list of available objects.

  8. Opening an Object in Datasheet View To open an object in Datasheet view • On the Objects bar, click the type of object that you want to open. • Click the name of the object that you want to open. • On the Database window toolbar, click Open. Or Double-click the name of the object that you want to open.

  9. Opening an Object in Design View To open an object in Design view • On the Objects bar, click the type of object that you want to open. • Click the name of the object that you want to open. • On the Database window toolbar, click Design.

  10. Switching Between Datasheet and Design View To switch between Datasheet and Design view for a table • On the Table Datasheet toolbar or Table Design toolbar, click the View button.

  11. Navigating in Datasheet View To navigate in Datasheet view • Use the mouse to click in the cell that you want to select. Or • Use the navigation buttons in the bottom-left corner of the table. Or • Use the shortcut keys.

  12. Closing an Object To close an object • Click the Close button in the top-right corner of the object. Or • On the File menu, click Close.

More Related