{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Access.03 - Access Tutorial 3 Maintaining and Querying a...

Info icon This 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
Image of page 1

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

View Full Document Right 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
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
Image of page 3

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

View Full Document Right 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
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
Image of page 5

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

View Full Document Right 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
Image of page 6
Deleting a Record New Perspectives on Microsoft Office Access 2007 7
Image of page 7

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

View Full Document Right 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
Image of page 8
Image of page 9
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern