Access.01 - Access Tutorial 1 Creating a Database FIRST...

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

FIRST COURSE Access Tutorial 1 Creating a Database
Image of page 1

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

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
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
Image of page 3

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

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
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
Image of page 5

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

XP New Perspectives on Microsoft Office 2007: Windows XP Edition 6 Databases and Relationships
Image of page 6
XP
Image of page 7

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

Image of page 8
This is the end of the preview. Sign up to access the rest of the document.
  • Spring '10
  • Raman
  • Windows XP, Microsoft Office 2007, Windows XP Edition

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern