{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

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 Document Right Arrow Icon

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

View Full Document Right Arrow Icon

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

View Full Document Right 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

{[ snackBarMessage ]}

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 bookmark
Ask a homework question - tutors are online