mopcv.blogg.se

1. Microsoft access 2013 tutorial 1 case problem 2 how to#
2. Microsoft access 2013 tutorial 1 case problem 2 full#

If the condition is true, one result will be displayed, and if the condition is false a different result will be displayed.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 Based on the doctor's requirements for the report, Marie must create a query on which to base the report.īecause the doctor wants all data entered for parents and guardians regardless of the data in the field, Marie must create a calculated field in the query with a function that tests the Mother, Father, and Guardian fields for a condition that is either true or false. She would also like to see the data for the fields Mother, Father, and Guardian, regardless of whether or not data is actually entered in those fields.

Microsoft access 2013 tutorial 1 case problem 2 full#

The doctor would like to see the patient's full name in the format Lastname, Firstname even though they are separate fields in the database.

The doctor for whom she works is participating in an academic study, and she needs a report that lists the patient's name, date of birth, and the names of parents or guardians. The practice has a sophisticated database for all records and information that pertain to the practice. Marie works for a busy pediatrician's office.