Produk Terbaru

Add to Cart


  • Nama Produk : Test Produk 6
  • Deskripsi : Isi dengan deskripsi produk
  • Produk variasi : Red textured and blue textured
Rp 19,999

Test
Add to Cart
Test


Overview: Table and field properties
Add to Cart
Overview: Table and field properties

Tables and fields also have properties that you can set to control their characteristics or behavior.

A table open in Design view

1 Table Property
2 Field Property
_________________________________________________________


In an Access database, table properties are attributes of a table that affect the appearance or behavior of the table as a whole. Table properties are set in the table's property sheet, in Design view. For example, you can set a table's Default View property to specify how the table is displayed by default.

A field property applies to a particular field in a table and defines one of the field's characteristics or an aspect of the field's behavior. You can set some field properties in Datasheet view. You can also set any field property in Design view by using the Field Properties pane.

Overview : Introduction
Add to Cart
Overview : Introduction

Create New Database
Add to Cart
Create New Database

These following steps are first step to create a database using Microsoft Access 2007.

Open Microsoft Access 2007


Click Blank Database to create new database.

Database Design
Add to Cart
Database Design

It is a good idea to write down the purpose of the database on paper — its purpose, how you expect to use it, and who will use it. For a small database for a home based business, for example, you might write something simple like "The customer database keeps a list of customer information for the purpose of producing mailings and reports." If the database is more complex or is used by many people, as often occurs in a corporate setting, the purpose could easily be a paragraph or more and should include when and how each person will use the database. The idea is to have a well developed mission statement that can be referred to throughout the design process. Having such a statement helps you focus on your goals when you make decisions.

What is good database design?

Before creating database, first we must know the following things:
  • Duplicate information also called redundant data is bad, because it wastes space and increases the likelihood of errors and inconsistencies.
  • Accurate information is important. If your database contains incorrect information, any reports that pull information from the database will also contain incorrect information. As a result, any decisions you make that are based on those reports will then be misinformed.

Introduction
Add to Cart
Introduction

Subscribe to: Posts (Atom)