ReviewForFinalPowerPoint04-25-09

ReviewForFinalPowerPoint04-25-09 - ReviewforFinal Exam...

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

View Full Document Right Arrow Icon
COMPREHENSIVE Review for Final  Exam Access & Excel
Background image of page 1

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

View Full DocumentRight Arrow Icon
First Have you submitted the Course Evaluation Go to:  www.hrsm.sc.edu Click on HRSM Course Evaluation Let’s talk about the Final Exam Dr. Gerdes 83 questions = 60 minutes MC/TF Must have password NO books, notes, or online help Let me show you now in Blackboard 2
Background image of page 2
Organizing Data Your first step in organizing data is to identify  the individual__________ fields The specific value, or content, of a field is called  the  field value A set of field values is called a  record Next, you group related fields together into  tables 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
Databases and Relationships Database A collection of related tables You connect the records in the separate tables  through common field A field, or a collection of fields, whose values  uniquely identify each record in a table primary key When you include the primary key from one table  as a field in a second table to form a relationship  between the tables, it is called a _____  _____ in  the second table 4
Background image of page 4
Databases and Relationships New Perspectives on Microsoft Office 2007: Windows Vista Edition 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
Exploring the Microsoft Access  Window New Perspectives on Microsoft Office 2007: Windows Vista Edition 6
Background image of page 6
Creating a Table in Datasheet View 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
Opening a Database 8
Background image of page 8
Navigating a Datasheet The  navigation buttons  provide another  way to move vertically through the records New Perspectives on Microsoft Office 2007: Windows Vista Edition 9
Background image of page 9

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

View Full DocumentRight Arrow Icon
Creating a Simple Query A question you ask about the data stored in a  database Query An object you use to enter, edit, and view  records in a database Form A formatted printout (or screen display) of the  contents of one or more tables in a database Report New Perspectives on Microsoft Office 2007: Windows Vista Edition 10
Background image of page 10
Viewing Objects in the Navigation  Pane 11
Background image of page 11

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

View Full DocumentRight Arrow Icon
Compacting and Repairing a  Database ______ a database rearranges the data and  objects in a database to decrease its file size Compacting New Perspectives on Microsoft Office 2007: Windows Vista Edition 12
Background image of page 12
Backing Up and Restoring a  Database __________  _____ a database is the  process of making a copy of the database file  to protect your database against loss or  damage Backing up New Perspectives on Microsoft Office 2007: Windows Vista Edition 13
Background image of page 13

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

View Full DocumentRight Arrow Icon
14
Background image of page 14
Image of page 15
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 71

ReviewForFinalPowerPoint04-25-09 - ReviewforFinal Exam...

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

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