Introduction To Table Access 2007

Thursday, November 03, 2011 JS Hanniffy 0 Comments

This posting is just to encourage me while doing the MOS course. After successfully finishing the European Computer Driving License (ECDL) I decided to take further course, and this time is I attempt to sit for the Microsoft Office Specialist Certificate and I'm very excited doing this course (although I didn't really like the Access before). As I started with dislike mood when doing Access course (just like most other my classmates), however, after several attempts trying to understand the materials I gradually find that this course is challenging (and no too difficult as well) - I guess everyone is different.

Anyway, lets revise all my previous lessons about how to work with table in Access 2007.

All data in Access store in table. Large database can have hundreds of tables. Table generally contains of data such as customer details, address, phone numbers, date of birth, etc (See the example image below).


Depend what data you want to put on table -  gathering and then deciding all the information before putting them into table is crucial as this can save you from wasting time, energy and money, too.

Creating table can be done through as follow:
  • Blank template
  • Table template
  • Sharepoint Lists
  • Design view
I only cover 3 ways how to make table: blank template, table template and through design view. From those 4 ways, the most easiest way I think is using table template. But it would depend on what type of template and data you want to put as some table templates might not suit for your data needs.

The design view can be very handy too if you want to put additional setting data, such as Validation Rules, Input Mask, or if you want to look for specific information you can put a formula that enable you to find only the information you need.

Whatever ways you want to do when creating a table it's important to remember that table has different types of characteristics. The  table types characteristic as follows:
  • Records
  • Data values
  • Fields
  • A primary key
Knowing these types characteristic is important as this will impact to your data performance. So before adding your data ensure you match the right character to your data.


DBLN, 21.00-021111

Blogger since 2008, writing with a fresh perspective.

Twitter Feeds