AccessTutoria01epw

AccessTutoria01epw - Access Tutorial 1 Creating a Database...

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

View Full Document Right Arrow Icon
FIRST COURSE Access Tutorial 1 Creating 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
XP New Perspectives on Microsoft Office 2007: Windows XP Edition 2 Objectives Define the terms field, record, table, relational database, primary key, and foreign key Create a blank database Identify the components of the Microsoft Access window Create and save a table in Datasheet view Enter field names and records in a table datasheet Open a table using the Navigation Pane
Background image of page 2
XP New Perspectives on Microsoft Office 2007: Windows XP Edition 3 Objectives Open an Access database Copy and paste records from another Access database Navigate a table datasheet Create and navigate a simple query Create and navigate a simple form Create, preview, navigate, and print a simple report Learn how to manage a database by compacting, backing up, and restoring a database
Background image of page 3

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

View Full DocumentRight Arrow Icon
XP New Perspectives on Microsoft Office 2007: Windows XP Edition 4 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 Record Next, you group related fields together into tables
Background image of page 4
XP New Perspectives on Microsoft Office 2007: Windows XP Edition 5 Databases and Relationships A collection of related tables is called a database , or a relational database You connect the records in the separate tables through a common field A primary key is a field, or a collection of fields, whose values uniquely identify each record in a table When you include the primary key from one table as a field in a second table to form a relationship between the two tables, it is called a foreign key in the second table
Background image of page 5

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

View Full DocumentRight Arrow Icon
XP New Perspectives on Microsoft Office 2007: Windows XP Edition 6 Databases and Relationships
Background image of page 6
XP 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
Image of page 8
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 28

AccessTutoria01epw - Access Tutorial 1 Creating a Database...

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

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