TUGAS SISTEM KOMPUTER: Database

<div id="center" style="line-height: 22.390625px; outline: none; padding: 0px 30px 30px;">
<h1 class="post-title entry-title" itemprop="name headline" style="font-weight: 400; line-height: 1.2em; margin-bottom: -27px; padding: 18px 0px 0px; text-align: justify;">
<a href="http://t2.gstatic.com/images?q=tbn:ANd9GcQirvwy6poUsr_z1JxFdpprOm9srV3a7R-ZFyjks-aQYqfR5o3P" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em; text-align: left;"><img border="0" height="200" src="http://t2.gstatic.com/images?q=tbn:ANd9GcQirvwy6poUsr_z1JxFdpprOm9srV3a7R-ZFyjks-aQYqfR5o3P" style="line-height: 22.390625px;" width="200" /></a><span style="font-family: inherit; font-size: small;"><span style="line-height: 22.390625px;">         hey Kembali lagi dengan gue Gigih Prasetyady disini gue mau share tentang <a href="http://tugaskuliah-sk.blogspot.com/2013/11/membuat-database-mudah-menggunakan.html" target="_blank">pembuatan </a></span></span><span style="font-family: inherit; font-size: small; line-height: 22.390625px;"><a href="http://tugaskuliah-sk.blogspot.com/2013/11/membuat-database-mudah-menggunakan.html" target="_blank">aplikasi database dengan mudah</a> dan simple menggunkan Microsoft Access, sebelum memulai nya yuk kita cari tau Apa sih database itu ? Database merupakan sebuah bentuk data atau pengolah data yang secara sistematis urutannya, memiliki sifat mudah di update atau dihapus sesuai dengan kebutuhannya. Untuk manfaat dari databes ini banyak sekali manfaatnya sobb. contoh, membuat absesnsi online, form online, daftar harga pada scanner market, perpustakaan, dan lain-lainnya. untuk tutorial kali ini saya coba untuk membuat contoh sederhana tahap awal membuat database. yaitu membuat tabel pada struktur database, karena didalam database itu ada beberapa struktur database </span><span style="font-family: inherit; font-size: small; line-height: 22.390625px;">seperti :</span></h1>
</div>
<div class="post-body entry-content" id="post-body-8467519368729175269" itemprop="articleBody" style="margin: 1.5em 20px; outline: none;">
<div style="line-height: 22.390625px; text-align: justify;">
<span style="font-family: inherit;">- Table</span></div>
<div style="line-height: 22.390625px; text-align: justify;">
<span style="font-family: inherit;">- Query</span></div>
<div style="line-height: 22.390625px; text-align: justify;">
<span style="font-family: inherit;">- Form</span></div>
<div style="line-height: 22.390625px; text-align: justify;">
<span style="font-family: inherit;">- Report</span></div>
<div style="line-height: 22.390625px; text-align: justify;">
<span style="font-family: inherit;">- Relation</span></div>
<div style="line-height: 22.390625px; text-align: justify;">
<span style="font-family: inherit;">- dan banyak lagi yang lainnya</span></div>
<div style="line-height: 22.390625px; text-align: justify;">
<span style="font-family: inherit;"><br /></span></div>
<div style="line-height: 22.390625px; text-align: justify;">
<span style="font-family: inherit;">kali ini saya akan membuat contoh tabel Mahasiswa dengan MS. accsess 2010 sebener nya sama saja dengan 2007, berikut contohnya :</span></div>
<div style="line-height: 22.390625px; text-align: justify;">
<span style="font-family: inherit;"><br /></span></div>
<div style="line-height: 22.390625px; text-align: justify;">
<span style="font-family: inherit;">tahap awal kita buka program Ms. Accessnya, lalu buat nama <b>databasenya</b>, lalu klik<b>Create</b>, setelah kita klik create maka akan muncul tampilan lembar kerja pada Ms. Access.</span></div>
<div style="line-height: 22.390625px; text-align: justify;">
<span style="font-family: inherit;"><br /></span></div>
<table cellpadding="0" cellspacing="0" class="tr-caption-container" style="border-collapse: collapse; border-spacing: 0px; line-height: 22.390625px; margin-left: auto; margin-right: auto; padding: 4px; text-align: center;"><tbody>
<tr><td style="vertical-align: top;"><a href="http://4.bp.blogspot.com/-Ik90dBWwgEU/UfFlhVDARbI/AAAAAAAAANw/JZZsUOHB3-8/s1600/1.JPG" imageanchor="1" style="margin-left: auto; margin-right: auto; outline: none; text-decoration: none;"><span style="color: black; font-family: inherit;"><img border="0" height="171" src="http://4.bp.blogspot.com/-Ik90dBWwgEU/UfFlhVDARbI/AAAAAAAAANw/JZZsUOHB3-8/s320/1.JPG" style="height: auto !important; max-width: 100%;" width="320" /></span></a></td></tr>
<tr><td class="tr-caption" style="vertical-align: top;"><u><span style="font-family: inherit; font-size: small;">Tampilan lembar kerja Ms. Access 2010</span></u></td></tr>
</tbody></table>
<div style="line-height: 22.390625px; text-align: justify;">
<br /></div>
<table cellpadding="0" cellspacing="0" class="tr-caption-container" style="border-collapse: collapse; border-spacing: 0px; line-height: 22.390625px; margin-left: auto; margin-right: auto; padding: 4px; text-align: center;"><tbody>
<tr><td style="text-align: center; vertical-align: top;"><a href="http://1.bp.blogspot.com/-L9gLgtWEe-U/UfFliEQsKKI/AAAAAAAAAOA/o9urGggkKik/s1600/2.JPG" imageanchor="1" style="margin-left: auto; margin-right: auto; outline: none; text-decoration: none;"><span style="color: black; font-family: inherit;"><img border="0" height="295" src="http://1.bp.blogspot.com/-L9gLgtWEe-U/UfFliEQsKKI/AAAAAAAAAOA/o9urGggkKik/s320/2.JPG" style="height: auto !important; max-width: 100%;" width="320" /></span></a></td></tr>
<tr><td class="tr-caption" style="text-align: center; vertical-align: top;"><span style="font-family: inherit; font-size: small;">Buat Nama Tabelnya, lalu klik Create</span></td></tr>
</tbody></table>
<div style="text-align: center;">
<span style="line-height: 22.37847328186035px;"><br /></span></div>
<table cellpadding="0" cellspacing="0" class="tr-caption-container" style="border-collapse: collapse; border-spacing: 0px; line-height: 22.390625px; margin-left: auto; margin-right: auto; padding: 4px; text-align: center;"><tbody>
<tr><td style="vertical-align: top;"><a href="http://4.bp.blogspot.com/-av-bB78JThs/UfFlij_Y8KI/AAAAAAAAAOI/lw-DkV5wIsU/s1600/3.JPG" imageanchor="1" style="margin-left: auto; margin-right: auto; outline: none; text-decoration: none;"><span style="color: black; font-family: inherit;"><img border="0" height="170" src="http://4.bp.blogspot.com/-av-bB78JThs/UfFlij_Y8KI/AAAAAAAAAOI/lw-DkV5wIsU/s320/3.JPG" style="height: auto !important; max-width: 100%;" width="320" /></span></a></td></tr>
<tr><td class="tr-caption" style="vertical-align: top;"><span style="font-family: inherit; font-size: small;">Tampilan Lembar Kerja Ms. Access 2010</span></td></tr>
</tbody></table>
<div style="line-height: 22.390625px; text-align: justify;">
<span style="font-family: inherit;"><br /></span></div>
<div style="line-height: 22.390625px; text-align: justify;">
<span style="font-family: inherit;">Setelah terlihat tampilan lembar kerjanya, sekarang kita ubah tampilannya menjadi<b>Design View</b> dengan cara : arahkan kursor ke arah menu View, lalu pilih <b>Design View</b></span></div>
<table cellpadding="0" cellspacing="0" class="tr-caption-container" style="border-collapse: collapse; border-spacing: 0px; line-height: 22.390625px; margin-left: auto; margin-right: auto; padding: 4px; text-align: center;"><tbody>
<tr><td style="text-align: center; vertical-align: top;"><a href="http://1.bp.blogspot.com/-uFBbHRR3F6g/UfFliq7VyMI/AAAAAAAAAOM/pACrz59cwNA/s1600/4.JPG" imageanchor="1" style="margin-left: auto; margin-right: auto; outline: none; text-decoration: none;"><span style="color: black; font-family: inherit;"><img border="0" height="315" src="http://1.bp.blogspot.com/-uFBbHRR3F6g/UfFliq7VyMI/AAAAAAAAAOM/pACrz59cwNA/s320/4.JPG" style="height: auto !important; max-width: 100%;" width="320" /></span></a></td></tr>
<tr><td class="tr-caption" style="text-align: center; vertical-align: top;"><span style="font-family: inherit; font-size: small;">Tampilan Design View</span></td></tr>
</tbody></table>
<div style="line-height: 22.390625px; text-align: justify;">
<div style="text-align: center;">
<span style="font-family: inherit;">Setelah memilih tampilan Design View, akan muncul kotak dialog untuk merubah/menyimpan nama table, dan isi nama table nya, sesuai data yang akan kita buat. disini saya membuat tablenya dengan nama<span style="background-repeat: no-repeat no-repeat; display: inline-block; left: 0px; margin-right: 12px; overflow: hidden; position: relative; top: 0px; vertical-align: middle;">"ekonomi"</span></span></div>
</div>
<div style="line-height: 22.390625px; text-align: justify;">
<span style="font-family: inherit;"><br /></span></div>
<div class="separator" style="clear: both; line-height: 22.390625px; margin: 0px 5px; outline: none; text-align: center;">
<a href="http://4.bp.blogspot.com/-lwRuhlR1s0c/UfFljLjNSYI/AAAAAAAAAOg/CBPFQX3h24E/s1600/5.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em; outline: none; text-decoration: none;"><span style="color: black; font-family: inherit;"><img border="0" height="148" src="http://4.bp.blogspot.com/-lwRuhlR1s0c/UfFljLjNSYI/AAAAAAAAAOg/CBPFQX3h24E/s320/5.JPG" style="height: auto !important; max-width: 100%;" width="320" /></span></a></div>
<div style="line-height: 22.390625px; text-align: justify;">
<span style="font-family: inherit;"><br /></span></div>
<div style="line-height: 22.390625px; text-align: justify;">
<span style="font-family: inherit;">setelah menyimpan table, sekarang kita akan membuat/mengisi field pada tablenya.</span></div>
<div style="line-height: 22.390625px; text-align: justify;">
<span style="font-family: inherit;">pada bagian table ini ada beberapa bagian struktur seperti, Field Name, Data Type, Description</span></div>
<div style="line-height: 22.390625px; text-align: justify;">
<span style="font-family: inherit;"><br /></span>
<div style="text-align: center;">
</div>
<div style="-webkit-text-stroke-width: 0px; color: black; font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 22.390625px; orphans: auto; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
</div>
<br />
<table cellpadding="0" cellspacing="0" class="tr-caption-container" style="-webkit-text-stroke-width: 0px; border-collapse: collapse; border-spacing: 0px; font-family: 'Times New Roman'; letter-spacing: normal; line-height: 22.390625px; margin-bottom: 0.5em; margin-left: auto; margin-right: auto; orphans: auto; padding: 4px; text-align: center; text-indent: 0px; text-transform: none; widows: auto; word-spacing: 0px;"><tbody>
<tr><td style="text-align: center; vertical-align: top;"><div style="margin: 0px;">
<a href="http://1.bp.blogspot.com/-YHOUetuK4pU/UfFljvTnmII/AAAAAAAAAOc/371tsY1-788/s1600/6.JPG" imageanchor="1" style="margin-left: auto; margin-right: auto; outline: none; text-decoration: none;"><span style="color: black; font-family: inherit;"><img border="0" height="169" src="http://1.bp.blogspot.com/-YHOUetuK4pU/UfFljvTnmII/AAAAAAAAAOc/371tsY1-788/s320/6.JPG" style="height: auto !important; max-width: 100%;" width="320" /></span></a></div>
</td></tr>
<tr><td class="tr-caption" style="font-size: 13.333333015441895px; padding-top: 4px; text-align: center; vertical-align: top;"><div style="margin: 0px;">
<span style="font-family: inherit; font-size: small;">Tampilan membuat Table</span></div>
</td></tr>
</tbody></table>
</div>
<div style="line-height: 22.390625px; text-align: justify;">
<div style="text-align: center;">
<span style="font-family: inherit;">Beriukutnya isilah bagian field, data type, dan descriptionnya, seperti ini :</span></div>
</div>
<div style="line-height: 22.390625px; text-align: justify;">
<span style="background-repeat: no-repeat no-repeat; display: inline-block; font-family: inherit; left: 0px; margin-right: 12px; overflow: hidden; position: relative; top: 0px; vertical-align: middle;">catatan : untuk bagian description boleh dikosongkan, karena sifatnya adalah sebagai penjelasan saja.</span></div>
<div style="line-height: 22.390625px; text-align: justify;">
<span style="font-family: inherit;"><br /></span></div>
<div style="line-height: 22.390625px; text-align: justify;">
<span style="font-family: inherit;"><br /></span></div>
<div class="separator" style="clear: both; line-height: 22.390625px; margin: 0px 5px; outline: none; text-align: center;">
<span style="color: black; font-family: inherit; margin-left: 1em; margin-right: 1em;"><img border="0" height="211" src="http://2.bp.blogspot.com/-D51_7hJ-dVI/UfFlj9XVZ_I/AAAAAAAAAOk/qLSF0qpa7Bg/s320/7.JPG" style="height: auto !important; max-width: 100%;" width="320" /></span></div>
<div style="line-height: 22.390625px; text-align: justify;">
<span style="font-family: inherit;"><br /></span></div>
<div style="line-height: 22.390625px; text-align: justify;">
<span style="font-family: inherit;">Setelah kita buat bagian table ini, sekarang kita akan isi bagian tablenya, dengan cara mengubah tampilan viewnya menjadi <b>Data Sheet View</b> dengan cara klik menu <b>View</b>, pilih <b>Data Sheet View.</b></span></div>
<div style="line-height: 22.390625px; text-align: justify;">
<span style="font-family: inherit;"><br /></span></div>
<table cellpadding="0" cellspacing="0" class="tr-caption-container" style="border-collapse: collapse; border-spacing: 0px; line-height: 22.390625px; margin-left: auto; margin-right: auto; padding: 4px; text-align: center;"><tbody>
<tr><td style="text-align: center; vertical-align: top;"><a href="http://2.bp.blogspot.com/-M_JQb-qaT0c/UfFlkdUeldI/AAAAAAAAAOw/9yEWLOCqtc8/s1600/8.JPG" imageanchor="1" style="margin-left: auto; margin-right: auto; outline: none; text-decoration: none;"><span style="color: black; font-family: inherit;"><img border="0" height="240" src="http://2.bp.blogspot.com/-M_JQb-qaT0c/UfFlkdUeldI/AAAAAAAAAOw/9yEWLOCqtc8/s320/8.JPG" style="height: auto !important; max-width: 100%;" width="320" /></span></a></td></tr>
<tr><td class="tr-caption" style="text-align: center; vertical-align: top;"><u><span style="font-family: inherit; font-size: small;">Tampilan Menu View</span></u></td></tr>
</tbody></table>
<br /><table cellpadding="0" cellspacing="0" class="tr-caption-container" style="border-collapse: collapse; border-spacing: 0px; line-height: 22.390625px; margin-left: auto; margin-right: auto; padding: 4px; text-align: center;"><tbody>
<tr><td style="vertical-align: top;"><a href="http://2.bp.blogspot.com/-Zd7R2AdDPTo/UfFlhW_lLdI/AAAAAAAAAN0/P8j88HEbt-I/s1600/10.JPG" imageanchor="1" style="margin-left: auto; margin-right: auto; outline: none; text-decoration: none;"><span style="color: black; font-family: inherit;"><img border="0" height="170" src="http://2.bp.blogspot.com/-Zd7R2AdDPTo/UfFlhW_lLdI/AAAAAAAAAN0/P8j88HEbt-I/s320/10.JPG" style="height: auto !important; max-width: 100%;" width="320" /></span></a></td></tr>
<tr><td class="tr-caption" style="vertical-align: top;"><u><span style="font-family: inherit; font-size: small;">Tampilan data Sheet View</span></u></td></tr>
</tbody></table>
<div style="line-height: 22.390625px; text-align: justify;">
<span style="font-family: inherit;"><br /></span></div>
<div style="line-height: 22.390625px; text-align: justify;">
<span style="font-family: inherit;">Sekarang kita isi fieldnya seperti ini :</span></div>
<div style="line-height: 22.390625px; text-align: justify;">
<span style="font-family: inherit;"><br /></span></div>
<div class="separator" style="clear: both; line-height: 22.390625px; margin: 0px 5px; outline: none; text-align: center;">
<span style="color: black; font-family: inherit; margin-left: 1em; margin-right: 1em;"><img border="0" height="147" src="http://3.bp.blogspot.com/-p-b7xGLg4Io/UfFlhTAs-_I/AAAAAAAAANo/ANEGS0ngfVg/s400/11.JPG" style="height: auto !important; max-width: 100%;" width="400" /></span></div>
<div style="line-height: 22.390625px; text-align: justify;">
<span style="font-family: inherit;"><br /></span></div>
<div style="line-height: 22.390625px; text-align: justify;">
<span style="font-family: inherit;">Nah! itulah <a href="http://tugaskuliah-sk.blogspot.com/2013/11/membuat-database-mudah-menggunakan.html" target="_blank">cara-cara sederhana membuat Database</a>, khusunya tabel pada program Ms. Access 2010. cara ini juga dapat diterapkan pada Office 2007/2013, karena teknis pembuatannya tidak berbeda, yang membedakan hanya interfacenya saja.</span></div>
<div style="line-height: 22.390625px; text-align: justify;">
<span style="font-family: inherit;">jika sudah selesai sobbat muda bisa langsung <b><span style="background-repeat: no-repeat no-repeat; display: inline-block; left: 0px; margin-right: 12px; overflow: hidden; position: relative; top: 0px; vertical-align: middle;">Save</span></b> saja datanya dengan mengklik icon <span style="background-repeat: no-repeat no-repeat; display: inline-block; left: 0px; margin-right: 12px; overflow: hidden; position: relative; top: 0px; vertical-align: middle;">save</span> atau menekan tombol <b>Ctrl+S</b>.</span></div>
<div style="line-height: 22.390625px; text-align: justify;">
<span style="font-family: inherit;"><br /></span></div>
<div style="line-height: 22.390625px; text-align: justify;">
<span style="font-family: inherit;"> nah gimana cukup mudah kan ? </span></div>
<div style="line-height: 22.390625px; text-align: justify;">
<span style="font-family: inherit;">ayo lebih semangat sobat buat berlatih untuk mencoba nya :)  sampai jumpa kembali dengan saya sebelum nya ini adalah tugas kuliah saya.. :)</span><br />
<span style="font-family: inherit;"><br /></span>
<span style="font-family: inherit;">Semoga Bermamfaat..</span></div>
</div>

Membuat Database Mudah Menggunakan MS.Access 2007/2010

hey Kembali lagi dengan gue Gigih Prasetyady disini gue mau share tentang pembuatan aplikasi database dengan mudah dan simple m...

Baca selengkapnya »