Define the term database
Describe a database using the terms File, Record and Field
Discuss the advantages of electronic databases over manual systems
Information systems (IS) are formal, sociotechnical, organisational systems designed to collect, process, store, and distribute information.
Data are individual units of information.
A structured collection of similar information which can be searched and sorted. A database is an organised collection of data, generally stored and accessed electronically from a computer system.
Databases are everywhere, but some big examples include:
There are many different areas of database engineering that offer many jobs.
A file is a collection of structured data on a particular topic. A file is made up of 1 or more records.
A record is a collection of structured data on a particular person or object. A record is made up of 1 or more fields. A "record" is the technical name for a database table row and contains the actual data in a table. Each record in a table contains the same fields but (usually) has different data in those fields.
A field is an area of a record that contains an individual piece of data. A “field” is the technical name for a database table column and is used to denote a specific type of data. The “Sex” field (column) contains text data denoting customer gender: Each field on a table holds only one type of data (for example, text data describing gender)
A field is a single piece of information;
A record is one complete set of fields;
A file is a collection of records.
For example, a telephone book is basically the file. It contains a list of records, each of which consists of three fields: name, address, and telephone number.
When you create a database, one of the first things you have to do is choose ‘types’ for the Fields.
There are several types to choose from:
Your first step in organising data is to identify the individual fields
The specific value, or content, of a field, is called the field value
Next, you group related fields together into tables
You are now going to play Top Trumps.
Microsoft Access is typically launched by clicking the Microsoft Access item on the Windows Start menu, to open the “Start” screen.
Here you see a range of ready-made templates and a list of recently-opened Access files that you can click to reopen:
Click on the Blank database template icon to begin creating a brand-new Access database.
You can edit the dialog Box (Default name, Default location) to provide your preferred name and location on your computer.
Datasheet View is the default data entry view for Microsoft Access 2016. Using the Datasheet View to build and manage your tables couldn’t be simpler:
Before you can save a table it must first contain at least one field.
Microsoft Access automatically creates a field called “ID”, which can be renamed or deleted to suit your requirements and provides a “Click to Add” heading that is prompting you to add fields.
Create New Database called My classmates
Create a new table in Datasheet View called Classmates
Insert the following fields into the table
Add a field or two of your choice.
Enter the data and save your database.
You've created a database that contains the names of several pupils in the class and you've added at least 3 fields.
You've created a database that contains the names of several pupils in the class and have added all 6 listed fields
You've created a database that contains the names of several pupils in the class and have all 6 listed fields and several more fields you have added yourself