Access.01 - COMPREHENSIVE Access Tutorial 1 Creating a...

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

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: COMPREHENSIVE Access Tutorial 1 Creating a Database Objectives Define the ter ms field, record, table, relational database, pr imar y key, and foreign key Creat e a blank database I dentify the components of the Microsoft Access window Creat e and save a table in Datasheet view Ent er field names and records in a table datasheet Open a table using the Navigation Pane New Per spectives on M icr osoft Office 2007: Windows Vista Edition 2 Objectives Open an Access database Copy and paste records from another Access database Navigat e a table datasheet Creat e and navigat e a simple quer y Creat e and navigat e a simple for m Creat e, preview, navigat e, and pr int a simple repor t Lear n how t o manage a database by compacting, backing up, and rest or ing a database New Per spectives on M icr osoft Office 2007: Windows Vista Edition 3 Organizing Data Your first step in organizing data is to identify the individual fields The specific value, or cont ent, of a field is called the field value A set of field values is called a r ecor d Next, you group relat ed fields t ogether int o tables New Per spectives on M icr osoft Office 2007: Windows Vista Edition 4 Databases and Relationships A collection of related tables is called a database , or a r elational database You connect the records in the separate tables through a common field A pr imar y key is a field, or a collection of fields, whose values uniquely identify each record in a table When you include the pr imar y key from one table as a field in a second table to for m a relationship between the two tables, it is called a for eign key in the second table New Per spectives on M icr osoft Office 2007: Windows Vista Edition 5 Databases and Relationships New Per spectives on M icr osoft Office 2007: Windows Vista Edition 6 Relational Database Management...
View Full 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 / 29

Access.01 - COMPREHENSIVE Access Tutorial 1 Creating a...

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

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