Microsoft Access 2007

Microsoft Access is a computer program relational database application that is used to design , create and process a variety of data types with capacity besar.Aplikasi uses Microsoft Jet database engine Database Engine , and also uses an intuitive graphical interface making it easier for the user . The latest version is Microsoft Office Access 2007 is included in the Microsoft Office System 2007 .

Microsoft Access can use data stored in Microsoft Access , Microsoft Jet Database Engine , Microsoft SQL Server , Oracle Database , or all containers database that supports ODBC standard . The user / programmer who can proficiently use it to develop complex software applications , while the less proficient programmer can use it to develop software applications that simple . Access also supports the techniques of object -oriented programming , but can not be classified into object -oriented programming toolkit .

Main Components ( Object )

1 . Table

Table is the main object in the database that is used to store a set of similar data in an object . Table consists of :

a. Field Name: The attribute of a table that occupies part of the column .

b . Record : The contents of fields or attributes that are interconnected which occupies part of the line .

 2 . Query ( SQL / Structured Query Language )

Query is a language to manipulate the database . Used to display , modify , and analyze a set of data . Queries can be divided into 2 , namely :

a. DDL ( Data Definition Language ) is used to create or define the database objects such as creating tables , relations between tables and so on .

b . DML ( Data Manipulation Language ) is used for database manipulation , such as : add , modify or delete data and retrieve the required information from the database .

3 . form

Form is used to control the process of data input ( input ) , data display ( output ) , check and update the data .

4 . Report

Form is used to display the data that has been summarized and print data effectively .

C. Data types

Field - a field in a table data type must be specified . There are several types of data in Access , namely :

1 . Text

Text used for alfanumeric field ( eg name , address , zip code , phone ) , about 255 characters per fieldnya .

2 . memo

Memo can accommodate 64000 characters for each fieldnya , but could not sorted / indexed .

3 . Number

Numbers are used to store numeric data that will be used to process mathematical calculations .

4 . Date / Time

5 . currency

6 . Auto Number

7 . Yes / No

8 . OLE Object

OLE Object used for external objects , such as bitmaps or sound files .

9 . hyperlink

10 . Lookup Wizard

If using this data type for a field , it can choose a value from another table or from a list of values ​​displayed in the combo box .

D. Create Database ( New Project ) with Microsoft Access

Steps - steps to open Microsoft Access and create a database :

1 . Click Start - > All Programs - > Microsoft Office - > Microsoft Access

2 . Then will appear the Microsoft Access window , then click Blank Database to create a database .

3.Ketik database name that you want and then click the create button .

 E. Create a Table

Steps - steps to create a table :

1 . Click the Create tab on the window

2 . Click on the ribbon Tables Table Design

3 . Enter the field name and its data type , then save the table ( Ctrl + S ) .

4 . View ribbon and then click on the Home tab , and select Datasheet View to enter data into a table .

 F. Table Relationship

Table Relationship is the relationship between multiple tables . Relations between tables linked by primary key and foreign key . To make the relationship of each table should have a primary key and a foreign key to be able to connect between the parent table to the child table . So that the necessary normalization techniques first before making relationships between tables . Normalization is the process of grouping the data elements into a table showing the entities and their relationships .

a. primary Key

The table has a primary key , which is an attribute that uniquely identifies not only an event but also represent each occurrence of an entity .

b . Foreign Key

Is a foreign key relationship attributes that complement and demonstrate the relationship between the parent table to the child table . Foreign key is placed in the child table .

Relational Database in Microsoft Access

a) Name Database

In this case I would build inter Relational tables that are integrated in the database named database . As for the tables that will be related in a table of contents and Employees , Visitors table , table Room , Tables and table booking facilities .