Changing the Background Row Color: Use Alternate Fill/Back Color on Home tab.

Freezing Columns: Use Freeze command on Home tab.

Rearranging Columns: Select field selector for column and drag to new location.

Changing Column Width: Drag the column border or specify best fit for automatic adjustment to best column width.

Changing Row Height: Drag the row border up or down, or specify an exact height.

Be careful not to paste data over existing data you want to keep.

The Cut, Copy, and Paste commands work the same way as in other Office programs.

Deleting a record is permanent and cannot be restored with the Undo command.

To delete a record, select the record and press Delete.

Datasheet selector selects the entire datasheet.

If you make a mistake, you can click the Undo button on the Quick Access Toolbar.

To make editing easier, use the record navigation bar.

You can use the pointer or keys to navigate to fields.

In Datasheet view, the table displays data in rows and columns in a datasheet.

The data in the field is the field value.Each record is made up one or more fields.When you double-click an object, it opens in the main part of the Access screen. Navigation Pane: Displays the objects contained in a database.Database Objects: The database file stores the database objects.Access Screen: Has a title bar, Quick Access toolbar, Ribbon, status bar.When you open an existing database from the Open Recent Database pane, the Navigation Pane opens.The object types are tables, queries, forms, reports, macros and modules.The objects work together to store, retrieve, display and summarize data.A database is a collection of objects.A computerized DBMS is much faster, more flexible, and more accurate.A DBMS does not have to be computerized, it can be file folders.A DBMS allows you to store, retrieve, analyze, and print information.

Access is a database management system (DBMS).Datasheet Microsoft Office 2007: IntroductoryДatasheet selector Datasheet view Field Field name Field selector Field value Navigation Pane Record Record selector Vocabulary (continued) Microsoft Office 2007: Introductory.Identify the parts of the Access screen.Start Access, open a database and open an object.Understand databases and database terminology.Access Lesson 1Access Basics Microsoft Office 2007: Introductory

Microsoft access basics