Other pages in this set

Page 2

Preview of page 2

Here's a taster:

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 and print reports
The DBMS will
­ allow many users to simultaneously access the central database
­ restrict access for each user to those parts of the database that they
are entitled to view or…read more

Page 3

Preview of page 3

Here's a taster:

Basic Components
Reports…read more

Page 4

Preview of page 4

Here's a taster:

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.…read more

Page 5

Preview of page 5

Here's a taster:

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 of controls…read more

Page 6

Preview of page 6

Here's a taster:

Used to create subsets of data held in tables
Used to combine the contents of more than one
­ 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
­ Delete query
­ Crosstab query…read more

Page 7

Preview of page 7

Here's a taster:

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.…read more

Page 8

Preview of page 8

Here's a taster:

The relational database model depends upon the
creation of relational links between separate entities
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…read more


No comments have yet been made

Similar ICT resources:

See all ICT resources »See all resources »