ArtsAutosBooksBusinessEducationEntertainmentFamilyFashionFoodGamesGenderHealthHolidaysHomeHubPagesPersonal FinancePetsPoliticsReligionSportsTechnologyTravel

Designing A Database Using Microsoft Access 2003

Updated on February 2, 2021
Patkay profile image

Patrick, a computer technician, is a dedicated writer who wishes to make the world better by informing individuals who seek more knowledge.

Designing a Database Using Ms Access 2003

Creating a Database Using MS Access

Having looked at the introduction to the Microsoft Office Access 2003, we can now be able to create or design our first database. To do this we need to launch Microsoft Access and this is how you do it.

  • Go to start button, click on all programs
  • Locate Microsoft Office and click on it,
  • Then click on Microsoft Office Access 2003. You will get a blank page, so to get started,
  • Click on file, new and then select the blank database option on your right-hand side.

Note that we have other powerful programs that we can use to create and maintain a database. For instance, one can make use of MS Access 2007, 2010, 2013, 2016 or any other higher version available.

This tutorial is however intended for Office 2003 users and there is a slight difference with the other advanced programs.

Procedure of Creating a Database in Ms Access

Procedure of creating a database using Access
Procedure of creating a database using Access | Source

Things You Need When Creating a Database

At this stage it would be important to check if you have:

  • Your database name
  • A list of the fields you will use, and
  • The records or information to feed on your database

Now, on the open dialogue window, indicate the name of your database and then select the place where you intend it to be stored. Click on create and your new database is created.

Creating Tables in Ms Access 2003

Creating Table(s)

The first thing you should do is to create a table to have your database running. The table, which is a collection of information organized in rows and columns, will contain the data you need to have in your database.

To create a table, under the objects, click on the table and above the objects click on new. You can create tables in five ways:-

  1. Using datasheet view – This is a direct entry method where you start entering the data on your table. You double click a column header and rename it, or you can right-click and select rename. Then you enter the records (actual data).
  2. Using the design view – The design view method lets you start by designing your table from scratch before you start entering your records.
  3. Using table wizard – In this option, you are guided by a table making wizard on how to come up with a table.
  4. Import table – This option will allow you to import a table from another database or another program, for instance, from Microsoft Excel.
  5. Link table – Use this option to create a link to another table in another database or another program, for example, Microsoft Excel.

Creating a Table in Access Using the Design View Method

  • Under the objects, click on the table and above the objects click on new then click on design view and click okay.
  • Input the field names – these are the titles (headings) of your table. Type them going downwards.
  • Next, in the data fields, specify the data type of each field. These you get from the drop-down button that appears once you click on the data type area.

Entering the Field Names and Their Data Type in Ms Access

Entering the field names and their data type
Entering the field names and their data type | Source

Data Types Used in Ms Access

The following are the available data types

  • Text - these are label entries, for instance, the name of a person “Joan”
  • Memo - this is for long text entries
  • Number - Are value entries for instance 110, 111, 112
  • Date/Time – Use this for date entries
  • Currency - it is used for a field with currency values
  • Auto-number - this is used for automatic listing or ordering
  • Yes/No - it indicates whether the stated condition is true or false
  • O.L.E. Object – (Object linking and embedding). This is for inserting objects and other graphics into the database
  • Hyperlink - connects the current object to other data sources
  • Lookup wizard - It picks its data from other objects, fields or databases that you choose

How to Enter Data on Ms Access Table

Entering data on your table
Entering data on your table | Source

Use of Primary Key in Ms Access

After setting the data type, close your table design page and save your work. Give your table a name.

As you click on save you will be asked if you want to create a primary key, your answer should be yes if you are going to create more than two tables in your database.

The primary key will be useful for defining a relationship between two or more tables.

On the database window, double-click your table and start entering your data. Note that if you created a primary key, a new field called ID (auto number) has been created.

Do not type anything here. Once you are done entering data on your table, click on close.

The Primary Key in Ms Access

The primary key option
The primary key option | Source

Your views

Which Database management program have you used?

See results

© 2012 Patrick Kamau


This website uses cookies

As a user in the EEA, your approval is needed on a few things. To provide a better website experience, uses cookies (and other similar technologies) and may collect, process, and share personal data. Please choose which areas of our service you consent to our doing so.

For more information on managing or withdrawing consents and how we handle data, visit our Privacy Policy at:

Show Details
HubPages Device IDThis is used to identify particular browsers or devices when the access the service, and is used for security reasons.
LoginThis is necessary to sign in to the HubPages Service.
Google RecaptchaThis is used to prevent bots and spam. (Privacy Policy)
AkismetThis is used to detect comment spam. (Privacy Policy)
HubPages Google AnalyticsThis is used to provide data on traffic to our website, all personally identifyable data is anonymized. (Privacy Policy)
HubPages Traffic PixelThis is used to collect data on traffic to articles and other pages on our site. Unless you are signed in to a HubPages account, all personally identifiable information is anonymized.
Amazon Web ServicesThis is a cloud services platform that we used to host our service. (Privacy Policy)
CloudflareThis is a cloud CDN service that we use to efficiently deliver files required for our service to operate such as javascript, cascading style sheets, images, and videos. (Privacy Policy)
Google Hosted LibrariesJavascript software libraries such as jQuery are loaded at endpoints on the or domains, for performance and efficiency reasons. (Privacy Policy)
Google Custom SearchThis is feature allows you to search the site. (Privacy Policy)
Google MapsSome articles have Google Maps embedded in them. (Privacy Policy)
Google ChartsThis is used to display charts and graphs on articles and the author center. (Privacy Policy)
Google AdSense Host APIThis service allows you to sign up for or associate a Google AdSense account with HubPages, so that you can earn money from ads on your articles. No data is shared unless you engage with this feature. (Privacy Policy)
Google YouTubeSome articles have YouTube videos embedded in them. (Privacy Policy)
VimeoSome articles have Vimeo videos embedded in them. (Privacy Policy)
PaypalThis is used for a registered author who enrolls in the HubPages Earnings program and requests to be paid via PayPal. No data is shared with Paypal unless you engage with this feature. (Privacy Policy)
Facebook LoginYou can use this to streamline signing up for, or signing in to your Hubpages account. No data is shared with Facebook unless you engage with this feature. (Privacy Policy)
MavenThis supports the Maven widget and search functionality. (Privacy Policy)
Google AdSenseThis is an ad network. (Privacy Policy)
Google DoubleClickGoogle provides ad serving technology and runs an ad network. (Privacy Policy)
Index ExchangeThis is an ad network. (Privacy Policy)
SovrnThis is an ad network. (Privacy Policy)
Facebook AdsThis is an ad network. (Privacy Policy)
Amazon Unified Ad MarketplaceThis is an ad network. (Privacy Policy)
AppNexusThis is an ad network. (Privacy Policy)
OpenxThis is an ad network. (Privacy Policy)
Rubicon ProjectThis is an ad network. (Privacy Policy)
TripleLiftThis is an ad network. (Privacy Policy)
Say MediaWe partner with Say Media to deliver ad campaigns on our sites. (Privacy Policy)
Remarketing PixelsWe may use remarketing pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to advertise the HubPages Service to people that have visited our sites.
Conversion Tracking PixelsWe may use conversion tracking pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to identify when an advertisement has successfully resulted in the desired action, such as signing up for the HubPages Service or publishing an article on the HubPages Service.
Author Google AnalyticsThis is used to provide traffic data and reports to the authors of articles on the HubPages Service. (Privacy Policy)
ComscoreComScore is a media measurement and analytics company providing marketing data and analytics to enterprises, media and advertising agencies, and publishers. Non-consent will result in ComScore only processing obfuscated personal data. (Privacy Policy)
Amazon Tracking PixelSome articles display amazon products as part of the Amazon Affiliate program, this pixel provides traffic statistics for those products (Privacy Policy)
ClickscoThis is a data management platform studying reader behavior (Privacy Policy)