Access.01 - Access Tutorial 1 Creating a Database FIRST COURSE Objectives XP Define the terms field record table relational database primary key

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 New Perspectives on Microsoft Office 2007: Windows XP Edition
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.

This note was uploaded on 12/08/2010 for the course USE 3425 taught by Professor Raman during the Spring '10 term at Punjab Engineering College.

Page1 / 28

Access.01 - Access Tutorial 1 Creating a Database FIRST COURSE Objectives XP Define the terms field record table relational database primary key

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