This tutorial is to help you understand databases and Microsoft Access. This might help you with various programs or programming languages in the future. This tutorial will focus on Microsoft Access and the terminology and database types and such related to that program.
Before I get started, here is some terminology you might hear through out the tutorial, and need to be aware of when using Microsoft Access. So here it is for you to become more familiar with.
DATABASE - a collection of data and relationships between the data stored in external memory.
FLAT FILE - a stand-alone file that has no relationships with other files.
RELATIONSHIP - a common field between two files.
DBMS (Database Management System) - the software that allows you to create and build databases.
CONTROLS - graphical representations of text, data and images placed on your form.
BOUND CONTROL - a control that is tied to a field from a table. A text box is an example of a bound control.
UNBOUND CONTROL - a control that is not bound to a field in a table. A label is an example of an unbound control.
CALCULATED CONTROL - a control that involves a calculation. This calculation can use formulas involving fields from a table or can be a built-in function using a field from a table.
DATA - characters, numbers, facts and figures that are fed into a program to help it do it's processing.
FIELD -a group of related characters.
RECORD -a group of related fields.
FILE -a group of related records.
TABLE - another name for a file in a relational database.
STRUCTURE - specifies the layout of the file, the field names, the data type for each field and the length of each field.
KEY FIELD - a field within the table that uniquely identifies each record within the table.
DATA TYPE -refers to the type of data stored in each field, whether it is text, a number, a date etc.
Which brings us on to our next topic... Continue on to learn more about data types within Access.
No Comments for this page.