Access.01

Access.01 - AccessTutorial1 CreatingaDatabase COMPREHENSIVE...

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

View Full Document Right Arrow Icon
COMPREHENSIVE 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
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 New Perspectives on Microsoft Office 2007: Windows Vista Edition 2
Background image of page 2
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 New Perspectives on Microsoft Office 2007: Windows Vista Edition 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
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 New Perspectives on Microsoft Office 2007: Windows Vista Edition 4
Background image of page 4
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 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 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
Databases and Relationships New Perspectives on Microsoft Office 2007: Windows Vista Edition 6
Background image of page 6
Relational Database Management  Systems
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 01/11/2012 for the course CIS 240 taught by Professor Last during the Spring '11 term at NYU.

Page1 / 29

Access.01 - AccessTutorial1 CreatingaDatabase COMPREHENSIVE...

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