Search
Left Quote    Treat your password like your toothbrush. Don't let anybody else use it, and get a new one every six months.
- Clifford Stoll    
Right Quote
 
[login] | [Register]
 

Databases and Access

by: bs0d
Page: 1 of 6
(View All)

Introduction


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.


TERMINOLOGY:


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.

1  |  2  |  3  |  4  |  5  |  6  |  
Next »


No Comments for this page.

You Must be logged in or a member to comment.


Tutorial Stats

Tutorial Stats

13,766 Views
0 Total Comments
3 Rating of 5 (1 Votes)

Options

Tutorial Options

· Login to Rate This Article
· Login to Post a Comment
· Read more by this author
Digg This Article! Del.icio.us: Bookmark This Article Reddit: Bookmark This Article BlinkList: Blink This Article! YahooMyWeb BlogMarks: Add This Mark! Furl: Save This Article Spurl: Mark This Article

Articles

Related    

· Getting Started with Excel
Your Article Here



"AllSyntax.com" Copyright © 2002-2017; All rights lefted, all lefts righted.
Privacy Policy  |  Internet Rank