9-Access-T01 - 9-Access-T01Database Objectives•Define the...

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: 9-Access-T01Database FundamentalsTutorial Objectives•Define the terms field, record, table, relational database, primary key, and foreign key•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 PaneNew Perspectives on Microsoft Office 2007: Windows Vista Edition2Tutorial 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 databaseNew Perspectives on Microsoft Office 2007: Windows Vista Edition3Relational Database Management Systems•A database management system (DBMS) is a software program that lets you create databases, and then manipulate the data contained in them•In a relational database management system (RDBMS), data are organized as a collection of relations•Access 2007 relations are called tablesNew Perspectives on Microsoft Office 2007: Windows Vista Edition4RDBMS SoftwareNew Perspectives on Microsoft Office 2007: Windows Vista Edition5Organizing Data•Your first step in organizing data, is to identify the individual fields, for each entity–Entity: a person, object, or event•Next, you use Access to define each particular set of fields as a table, one table per entity–Each field (i.e., column) has a specified data-type–A set of field values is called a record (i.e., row)•After entering data values into your table(s),...
View Full Document

This note was uploaded on 06/22/2011 for the course COMPUTER S 1B03 taught by Professor Dr.dotler during the Spring '10 term at McMaster University.

Page1 / 26

9-Access-T01 - 9-Access-T01Database Objectives•Define the...

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