tblSettings, the first table in our database

A tblSettings table is created in the KCBData database, this table is having the following structure.

Field Name	Data Type	Data Size	Description
ID	Long Integer	4	Autonumbered Index  Field
Company	Text	255	My Access Database
BusinessPhone	Text	255	+6012-3456789
Address	Text	255	Address Line 1
Address2	Text	255	Address Line 2
Address3	Text	255	Address Line 3
City	Text	255	City
StateProvince	Text	255	State and Province
ZipPostal	Text	255	Post Code
CountryRegion	Text	255	Country
ShowStartupScreen	Yes/No	1	yes
WebPage	Hyperlink	-	key in web address here
Email	Text	255	kcbehnet@gmail.com
BusinessFax	Text	255	+6012-3456790
Build	Text	255	2014.11.001

This table is meant for the storage of company related particular, which in the later stage can be used to display as letter head of screen display information if necessary. Thus additional fields can be added if necessary.

As we know, a table is only used to store raw data, without any calculated fields, thus the structure is very clearly self-explanatory.

In this table, there are two fields that play some roles in our database system. The first of them is the ShowStartupScreen. This is a Yes/No field. It is used as a flag to mark the requirement to show the start-up screen if necessary. I use this to pop up the start-up screen so that the users will be able to note there is major change and need to update the system.

The second field that serve this purpose id the Build field which is used to display the version number.

After creating the table, please open it and key in the information of the company as per necessary. We can of course create a form for such job, but I am not preparing to do it at this moment because I want to pay more attention to those tasks that can help to make this database functional as soon as possible. The information I key into my tblSettings table is listed in the description column in the above table structure.