Access.02 - COMPREHENSIVE Access Tutor ial 2 Building a...

Info iconThis preview shows pages 1–9. 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

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: COMPREHENSIVE Access Tutor ial 2 Building a Database and Defining Table Relationships Objectives Learn the guidelines for designing databases and setting field properties View and modify field data types and formatting Create a table in Design view Define fields and specify a tables primary key Modify the structure of a table New Per spectives on M icr osoft Office Access 2007 2 Objectives I mport data from an Excel worksheet Create a table by importing an existing table structure Delete, rename, and move fields Add data to a table by importing a text file Define a relationship between two tables New Per spectives on M icr osoft Office Access 2007 3 Guidelines for Designing Databases I dentify all the fields needed to produce the required information Organize each piece of data into its smallest useful part Group related fields into tables Determine each tables primary key I nclude a common field in related tables Avoid data redundancy Determine the properties of each field New Per spectives on M icr osoft Office Access 2007 4 Guidelines for Setting Field Properties You must name each field, table, and other object Choose an appropriate data type New Per spectives on M icr osoft Office Access 2007 5 Guidelines for Setting Field Properties The Field Size pr oper ty defines a field values maximum storage size for Text, Number, and AutoNumber fields only Byte I nteger Long I nteger Single Double Replication I D Decimal New Per spectives on M icr osoft Office Access 2007 6 Viewing and Modifying Field Data Types and Formatting New Per spectives on M icr osoft Office Access 2007 7 Creating a Table in Design View New Per spectives on M icr osoft Office Access 2007 8 Defining a Field in Design...
View Full Document

This note was uploaded on 06/15/2011 for the course TSTM E264 taught by Professor Crews during the Fall '09 term at South Carolina.

Page1 / 32

Access.02 - COMPREHENSIVE Access Tutor ial 2 Building a...

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

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