INTRODUCTION TO ACCESS AND PARTICIPATION UPDATE

sunfloweremryologistData Management

Oct 31, 2013 (3 years and 10 months ago)

80 views

INTRODUCTION TO ACCESS

AND

PARTICIPATION UPDATE



1

PARTICIPATION


Up until now, if you received a point for
attendance, you also received a point for
participation


Starting Monday, October 7
th
, participation
points will require a submission of the
demo project done in class

2

WHAT IS ACCESS?


Access is a database creation and
management program



DBMS


Database Management System


MySQL, Oracle, IBM DB2


3

WHAT IS A DATABASE


A structured set of data held in a
computer, especially one that is accessible
in various ways



4

COMPONENTS OF A DATABASE


Object


M
ain components of a database
that is created and used to make the
database function


Tables


Queries


Forms


Reports

5

DATABASE TABLE


Table


The foundation of every database.
It is a collection of related records


EX:


All students are entered into the Class Roster
Table

6

COMPONENTS OF A
DATABASE
TABLE


Field


The smallest data element
contained in a table.


EX:


Last Name

7

COMPONENTS OF A DATABASE
TABLE


Record


Complete set of all of the data
elements (fields) about one person, place,
event, or concept.


EX:


First Name


Last Name


Student ID


Email Address

8

DATABASE


A database consists of:


One or more tables to store data


One or more forms to enter data into the
tables


One or more reports to output the table data
as organized information

9