MS Access Database for beginners
   
Database vocabulary - glossary of terms
Data
A collection of raw facts and figures
Information
Data that has been sorted, filtered, grouped or in some way organised, processed or put into context in order to give it meaning
Field
A category of information (the columns in a table)
Field name
 The heading of a field (for example; firstname, lastname, address)
Field Entry
 Data entered into one cell in a database
Record
Information about one data subject (the rows in a table)
Data type
 The type of data that can be entered into a field (for example; text, number, data and time, currency)
Data Subject
A single person or object in the database
Data view
Allows you to see actual data in the database
Design view
 Allows you to change the layout of the database (no actual data is shown)
Tabular view
 Seeing all records and fields in a grid
Columnar view
 Only shows the records for one data subject at a time
Sort
 Changing the order of one or more fields in the database (for example put into alphabetical or numerical order)
Filter
 A temporary view of a database which only shows data that meets certain criteria (only certain records will be shown)
Query
 A saved view of a database which only shows data that meets certain criteria (only certain fields and records will be shown)
Report
A printed output from a database based on a query or table
 
Lezynski Reddick Naming Convention

You will have noticed the use of three letter abbreviations used for naming objects in these exercises using the Leszynski naming convention  which is an internationally recognised way of naming objects in databases.
tbl prefix for tables
qry prefix for queries
frm prefix for forms
rpt prefix for reports
 
UK Film Classifications
UK Film Classifications are set by the British Board of Film Classifications (BBFC)
U (1912-present) - This stood for 'Universal' and denoted that a film was suitable for everyone.
PG (1982-present) - Replacing the old A certificate, this stood for 'Parental Guidance'. Although anyone could be admitted, PG certificate films contained an implicit warning that the film might contain material unsuitable for children.
12 (1989-present) - Introduced for cinema films in 1989 and video releases in 1994, this covers films that, while containing material deemed unsuitable for children, were nonetheless considered appropriate for 12-year-olds and upwards.
15 (1982-present) - This replaced the old AA certificate, raising the age limit to 15 in the process.
18 (1982-present) - This replaced the old X certificate, barring people under eighteen.