Database definition: An organised collection of related data, which can be grouped
together due to their similar characteristics. Describe a DBMS? Database Management System, builds , maintains and
provides access to a database. It is the
software that allows you to manage a database. Structure of a Relational Database A database is made
up of related files or tables, each file/table containing related records, which are
made up of related fields, which are
in turn made up of values that contain related characters(such as dates, time, text, numbers etc).
Data Dictionary It is a
plan/definition of any database. It is
created before the database is built.
Table / File Name
Field Name
Data Type
Size
Description
Example:
Films
Field Name
Data Type
Size
Description
Film_No
Numeric
5
Unique film No
for each film
Film_Title
Text
50
Name of feature
film
Film_Year
Numeric
(Date/Year)
4
Year film was
released
Available on DVD
Boolean
1
Is it available
on DVD?
Query Language
The data in a Database is accessed using a Query Language.
Query Language includes the following types of commands or instructions:
SELECT - get information
UPDATE - update information
INSERT - insert new information
DELETE - delete information
The SELECT & UPDATE can be for many records, but we sometimes need to be more specific, we can use CONDITIONS to filter the records
A Filter is usually for a Field or group of Fields on a Record. These fields are compare against a value (number or letters or boolean, etc.) or another field.
E.g.: Date < "01/01/2013", SIze >= 10
The comparison operators include:
Symbol
<
>
<=
>=
=
<>
AND
OR
Microsoft Access 2013 Beginners Tutorials
Microsoft Access 2013 Tutorial Level 1 Part 00 of 12 - Introduction
Microsoft Access 2010 Tutorial Part 02 of 12 - Planning Your Database
Microsoft Access 2010 Tutorial Part 03 of 12 - The Access Interface
Microsoft Access 2010 Tutorial Part 04 of 12 - Customer Table, Part 1
