1-a: How Does My Data Get Stored? ( Added: Mon Jun 13 2005   Hits: 56) How the data is stored in a database is probably much simpler than you might think. Databases use a series of Tables to store the data. A table simply refers to a two dimensional representation of your data using columns and rows. For example:

Report Link Rate It Review It Send To Friend!

	1-b: How Do I Organize My Data? ( Added: Mon Jun 13 2005   Hits: 58) The next thing to understand about your table is the Primary Key. The Primary Key simply refers to a column in your table that is guaranteed unique. The Primary Key is then used for the purposes of indexing your table which makes it much more efficient to search, sort, link, etc.

Report Link Rate It Review It Send To Friend!

	1-c: How Does All of This Relate? ( Added: Mon Jun 13 2005   Hits: 59) That's great. I have the people in one table and the newsletters in another table. How the heck am I supposed to know who is subscribed to what? This is the best part. This is where the Relational Database gets its name. Relational Database? You never mentioned that.

Report Link Rate It Review It Send To Friend!

	2-a: What is a Data Type? ( Added: Mon Jun 13 2005   Hits: 58) Well, before we get started making a table there is one thing you need to understand first, Data Types. Data Types are pretty straight forward. They indicate the type of data that you are storing in a given table column. Amazing, huh?

Report Link Rate It Review It Send To Friend!

2-b: How Do I Create a Table? ( Added: Mon Jun 13 2005   Hits: 61) Creating a table is very easy. I'm going to show you 2 different ways to accomplish this task. The first will be to use a SQL statement. The second will be using a Graphical User Interface (GUI) tool. For our GUI example we are going to use Access since it is one of the most common databases out there today and, more importantly, it's already installed on my machine. ?

Report Link Rate It Review It Send To Friend!

	2-c: How Do I Design a Table in a Database Tool? ( Added: Mon Jun 13 2005   Hits: 54) Now we'll use some pretty pictures to illustrate the process of creating a database and table in Access. There are many other DBMS's out there besides Access, so be sure to do a little homework and download some demos before you decide which DBMS is right for you.

Report Link Rate It Review It Send To Friend!