2_DB_development_presentation_l1_v1

  • pptx
  • 09.05.2020
Публикация на сайте для учителей

Публикация педагогических разработок

Бесплатное участие. Свидетельство автора сразу.
Мгновенные 10 документов в портфолио.

Иконка файла материала 2_DB_development_presentation_l1_v1.pptx

Access Tutorial 1 Creating a Database

Objectives

Learn basic database concepts and terms
Explore the Microsoft Access window and Backstage view
Create a blank database
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 Access 2010

2

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 compact, back up, and restore a database

New Perspectives on Microsoft Access 2010

3

The Access Window

New Perspectives on Microsoft Access 2010

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
A set of field values is called a record
Next, you group related fields together into tables

New Perspectives on Microsoft Access 2010

5

Databases and Relationships

New Perspectives on Microsoft Access 2010

6

Relational Database Management Systems

A database management system (DBMS) is a software program that lets you create databases and then manipulate data in them
In a relational database management system, data is organized as a collection of tables

New Perspectives on Microsoft Access 2010

7