#Microsoft access 2013 tutorial 7 case problem 4 how to#
Presentation on theme: "Access Tutorial 1 Creating a Database"- Presentation transcript:Ģ 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Ĭopy 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Ĥ 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Ī 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 New Perspectives on Microsoft Office 2007: Windows Vista Edition