Access.03 - Access Tutorial 3 Maintaining and Querying a Database COMPREHENSIVE Objectives Find modify and delete records in a table Learn how to

Info iconThis preview shows pages 1–9. Sign up to view the full content.

View Full Document Right Arrow Icon
COMPREHENSIVE Access Tutorial 3 Maintaining and Querying a Database
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Objectives Find, modify, and delete records in a table Learn how to use the Query window in Design view Create, run, and save queries Update data using a query datasheet Create a query based on multiple tables Sort data in a query Filter data in a query New Perspectives on Microsoft Office Access 2007 2
Background image of page 2
Objectives Specify an exact match condition in a query Change the font size and alternating row color in a datasheet Use a comparison operator in a query to match a range of values Use the And and Or logical operators in queries Create and format a calculated field in a query Perform calculations in a query using aggregate functions and record group calculations Change the display of database objects in the Navigation Pane New Perspectives on Microsoft Office Access 2007 3
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Updating a Database Updating , or maintaining , a database is the process of adding, modifying, and deleting records in database tables to keep them current and accurate Navigation mode Editing mode New Perspectives on Microsoft Office Access 2007 4
Background image of page 4
Finding Data in a Table The Find command allows you to search a table or query datasheet, or a form, to locate a specific field value or part of a field value New Perspectives on Microsoft Office Access 2007 5
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Deleting a Record With the table in Datasheet view, click the row selector for the record you want to delete In the Records group on the Home tab, click the Delete button (or right-click the row selector for the record, and then click Delete Record on the shortcut menu) In the dialog box asking you to confirm the deletion, click the Yes button New Perspectives on Microsoft Office Access 2007 6
Background image of page 6
Deleting a Record New Perspectives on Microsoft Office Access 2007 7
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Introduction to Queries Access provides powerful query capabilities that allow you to do the following: Display selected fields and records from a table Sort records Perform calculations Generate data for forms, reports, and other queries Update data in the tables in a database Find and display data from two or more tables A Query Wizard
Background image of page 8
Image of page 9
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 06/15/2011 for the course TSTM E264 taught by Professor Crews during the Fall '09 term at South Carolina.

Page1 / 35

Access.03 - Access Tutorial 3 Maintaining and Querying a Database COMPREHENSIVE Objectives Find modify and delete records in a table Learn how to

This preview shows document pages 1 - 9. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online