Pages in this set

Page 1

Preview of page 1
MS Access RDBMS

Page 2

Preview of page 2
Database Management System (DBMS)
A set of programs that permits an organisation to:
­ centralise data
­ create database files
­ manage them efficiently
­ access the data when required
Using a DBMS, users can
­ create new database files
­ add, delete, alter, and sort data
­ make enquiries…

Page 3

Preview of page 3
Basic Components
Tables
Forms
Queries
Reports

Page 4

Preview of page 4
Tables
A table for each separate entity
Design mode allows user to define a data
structure for the table
A primary key ­ which must be a unique
identifier for each record - must be defined.
(Access does provide an Autonumber
function is there is no natural unique
identifier.

Page 5

Preview of page 5
Forms
A user-friendly method of entering data for the
main user(s) of a database
Usually has one data source, which may be a
table or a query
The objects that allow fields to displayed and/or
modified are known as controls
Design is very important
­ Order of controls
­ Layout…

Page 6

Preview of page 6
Queries
Used to create subsets of data held in tables
Used to combine the contents of more than one
table
­ This is achieved via the relational links that are created
between tables
The are several types of query
­ Simple select query
­ Update query
­ Append query
­…

Page 7

Preview of page 7
Reports
Reports are usually used in conjunction
with queries to produce sorted output
satisfying particular criteria
MS Access provides powerful wizards to
produce reports with various sort, grouping
and style options.

Page 8

Preview of page 8
Relationships
The relational database model depends upon the
creation of relational links between separate entities
(tables)
One-to-Many relationship
­ For example in a surgery database, a doctor would have
many patients
Doctors Patients

One-to-one relationship
­ a doctor would have one expense account

Doctors Expenses

Comments

No comments have yet been made

Similar ICT resources:

See all ICT resources »See all resources »