Basic Microsoft Access 2007

Open the Microsoft Access 2007 page work on your computer. Select Blank Database and Database name you Latihan.accdb.

You can change the storage directory of your liking and if you do not change the default storage directory Latihan.accdb will be stored in C: \ Users \ LUKMAN \ Documents.

Click the Create button.

 

Once you hit the button Create new table will be automatically made ​​and to save and change the name to your liking that is by pressing View.

In this case the table is saved with the name Biodata Students.

Continue by filling Field, Data Type, and Caption on the table.

Input Field Name, Data Type, Field Size, Caption as you have previously compiled.

Work with the database at the Sex.

Click the arrow on the Data Type and select Lookup Wizard jns_Kelamin

Choice I Will type in the values that I want. Klik Next

 Number of columns : 2

Your complete Sex and the notes are in accordance with the drawings. click Finish

Designing forms display Form

Entering Field to Form

Click on Icon Add Existing Fields to issue Field List.

 Double Click on the field one by one to enter into the form field.

Creating Command Buttons

Button is useful to create a command button on the form. Button button will execute the instruction in accordance with the appropriate command Button button which you choose in order to facilitate the operation at the time of data entry.

In the Command Button Wizard there are a lot of functions - functions that are ready-made starting from Operation Record:

Add New Record: Adding New Data

Delete Record: Deletes Data, etc. ..

This time we will try to make a button function to add new data. Click Next.

 Select Text and Change its name to ADD. Click Next.

 This is the Variable Name, fill with cmd Add. Click Finish

Model designing Record Print Out

 Move all the files to the right except No.. click Next.

 

 Creating Data Group. Click Next

 Make Form Sort Order

Set the Position Paper

Select Office. Klik Next.

 Click Finish.

Below is the report from the table that already has data

designing a Menu

Making a program menu button menu that is declared with others using the menu button Menu Switchboard

If there are questions to create a switchboard as shown below then click yes.

Click Edit to change the name of the menu and Adding Menu Item

Click New to add a Menu Item

Here is the view Switchboard.

share this article to: Facebook Twitter Google+ Linkedin Technorati Digg

Posted by Unknown, Published at 20:17 and have 0 comments