{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Access.02 - Access Tut or ial 2 Building a Dat abase and...

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

View Full Document Right Arrow Icon
COMPREHENSIVE Access Tutorial 2 Building a Database and Defining Table Relationships
Background image of page 1

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

View Full Document Right Arrow Icon
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 table’s primary key Modify the structure of a table New Perspectives on Microsoft Office Access 2007 2
Background image of page 2
Objectives Import 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 Perspectives on Microsoft Office Access 2007 3
Background image of page 3

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

View Full Document Right Arrow Icon
Guidelines for Designing Databases Identify 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 table’s primary key Include a common field in related tables Avoid data redundancy Determine the properties of each field New Perspectives on Microsoft Office Access 2007 4
Background image of page 4
Guidelines for Setting Field Properties You must name each field, table, and other object Choose an appropriate data type New Perspectives on Microsoft Office Access 2007 5
Background image of page 5

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

View Full Document Right Arrow Icon
Guidelines for Setting Field Properties The Field Size property defines a field value’s maximum storage size for Text, Number, and AutoNumber fields only Byte Integer Long Integer Single Double Replication ID Decimal New Perspectives on Microsoft Office Access 2007 6
Background image of page 6
Viewing and Modifying Field Data Types and Formatting New Perspectives on Microsoft Office Access 2007 7
Background image of page 7

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

View Full Document Right Arrow Icon
Creating a Table in Design View New Perspectives on Microsoft Office Access 2007 8
Background image of page 8
Image of page 9
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}