-->

Ads

Cara Membuat Aplikasi Sederhana Menggunakan Microsoft Access 2007

Garicfalo Blogs – Membuat aplikasi mungkin terdengar sulit, namun berbeda dengan membuat aplikasi menggunakan Microsoft Access akan jauh lebih mudah bagi Anda yang kurang mahir menggunakan bahasa pemograman lain. Karena dengan dukungan mesin berbasis data Microsoft Database Jet Engine, dan juga menggunakan tampilan grafis yang intuitif sehingga memudahkan penggunanya.

Para pengguna/programmer yang mahir dapat menggunakannya untuk mengembangkan perangkat lunak aplikasi yang kompleks, sementara para programmer yang kurang mahir dapat menggunakannya untuk mengembangkan perangkat lunak aplikasi yang sederhana. Access juga mendukung teknik-teknik pemrograman berorientasi objek, tetapi tidak dapat digolongkan ke dalam perangkat bantu pemrograman berorientasi objek. 


Daftar bagian dari project yang akan di buat : 

  1. Project Database Microsft Access 2007, membuat nama aplikasi dan tempat penyimpanan project file.
  2. Table, digunakan untuk meyimpan data
  3. Query, berfungsi sebagai manipulasi data
  4. Form, merupakan tampilan yang dari aplikasi yang digunakan untuk menampilkan dan mengelola data
  5. Report, digunakan untuk menampilkan laporan dari data yang telah di masukan ke dalam Table.
Berikut tahap awal membuat aplikasi sederhan dengan menggunakan Microsoft Access 2007, di sini penulis menggambil contoh membuat aplikasi data mahasiswa.
  • Buka Microsoft Access 2007, Start – All Programs – Microsoft Office – Microsoft Access
  • Pilih Blank Database kemudian tulis nama databasenya “mahasiswa” 
Membuat Table 
  • Membuat 2 buah Tabel Mahasiswa dan Tabel Biaya, Pilih Menu Create – Pilih Tabel 
  • Masukan Field Name yang di butuhkan Untuk Tabel Mahasiswa isi dengan NIM, Nama, Alamat, Jurusan, Angkatan dan Kode_Biaya. Save dengan nama “Table_Mahasiswa” 

    Dan Tabel Biaya isi dengan IDBiaya, Nama_MHS Jumlah_SKS, Nilai_Rata, Biaya_Kuliah dan Total_Bayar. Save dengan nama “Table_Biaya” 
  • Selanjutnya mengatur Properties dari tabel tersebut, Pilih Design View 
  • Setting Data Type untuk Table Mahasiswa seperti gambar di bawah ini 
  • Dan untuk Data Type Table Biaya seperti gambar di bawah ini 
  • Kemudian Save kedua tabel tersebut.
Membuat Query

Sebelumnya Anda harus tau apa itu fungsinya Query, fungsinya Query yaitu untuk menampilkan data pada tabel yang telah di masukan sebelumnya. Contohnya kita mencari data dari tabel Mahasiswa dengan menggunakan Kode mahasiswa ”MHS2016001”, atau kita mencari biaya mahasiswa dengan kode biaya “BM201601” maka kita dapat mengetahui biaya dari mahasiswa dengan kode tersebut. Query juga digunakan sebagai sumber data untuk Report dan Form.
  • Membuat Query, Pilih Menu Create – Query Design, kemudian Pilih Add untuk memasukan Tabel 
  • Masukan kedua tabel Mahasiswa dan biaya seperti gambar di bawah ini 
  • Kemudian Save
Membuat Form
  • Pilih Menu Create – Form 
  • Kemudian pilih Desain View, masukan tombol yang di butuhkan seperti TAMBAH, SIMPAN, HAPUS, CETAK, CARI, NEXT dan PREVIOUS. Cara memasukan tombolnya Klik Icon Button kemudian pilih sesuai dengan fungsi tombol yang ada. 
Membuat Report
  • Membuat Laporan dari dua tabel mahasiswa dan biaya , Pilih Menu Create – Report 

Demikian cara membuat aplikasi sederhana dengan menggunakan microsoft office 2007, semoga bermanfaat :)

Baca Juga : Cara Membuat Database Password Pada Microsoft Access 2007

Download File Aplikasi Mahasiswa Di Sini

#garicfalo

small business hr software,small business help desk software,small business lending software,small business onboarding software,small business budget software,small business erp software,small business dispatch software,small business manufacturing software packages,small business manufacturing software,small business timekeeping software,timekeeping software for small business,small business accounting software with inventory management,small business mrp software,antivirus software for small business,small business sales software,payroll for small business software,small business software for payroll,small business software payroll,small business software with payroll,small business logistics software,small business expense software,small business intranet software,small business bookkeeping software canada,small business software inventory,small business software with inventory,small business accounting software with payroll,small business software for contractors,small business inventory software mac,small business pos software,small business backup software,accounting for small business software,small business software accounting,small business loan software,small business software for inventory and sales,small business recruiting software,small business software suite,small business backup software reviews,small business accounting software with inventory,small business retail software,small business ledger software,small business software customer database,small business quotation software,small business billing software,small business tax software sole proprietor,small business database software,small business workflow software,small business accounting software comparison,small business tax software for mac,small business organization software,small business job tracking software,small business payment software,small business software development services,small business management software,small business accounting software for mac,small business dashboard software,small business scheduling software,best bookkeeping software for small business,small business software uk,invoice for small business software,small business software for invoicing,small business software invoice,bookkeeping for small business software,small business bookkeeping software,small business job costing software,small business ecommerce software,small business software package,small business software systems,small business job scheduling software,small business routing software,small business operations software,small business job management software,small business server software,small business receipt software,small business software online,small business virus software,google small business software,small business coaching software,small business software programs,small business tax software,software for small business taxes,small business accounting software linux,small business warehouse software,small business record keeping software,small business accounting software 2019,small business procurement software,small business owner software,small business software,small business tracking software,small business software free,small business booking software,best small business software 2019,small business software tools,small business software open source,small business software for mac,small business software 2018,small business software reviews,quicken small business software,small business legal software,small business software free download,small business software comparison,small business software mac,small business valuation software,xero small business software,small business tax software 2019,small business software needs,small business software download,small business estimating software,small business accounting software no monthly fee,small business planning software,small business tax software 2018,small business register software,small business accounting software canada,small business accounting software google,top 10 small business software,small business office software,best small business software 2018,small business general ledger software,small business accounting software windows 10,small business hr software uk,small business loyalty software,small business payroll software canada,small business reporting software,small business software for accounting,small business tax software canada,very small business accounting software,software for small business india,small business accounting software australia,small business management software open source,small business encryption software,small business network software,small business software recommendations,small business email software,small business invoicing software reviews,small business software applications,small business accounting software free download windows 7,sap for small business software,small business software linux,thryve small business software,small business software development,small business startup software,small business software cloud,small business software australia,small business payroll software australia,small business software canada,small business wiki software,small business security software,small business accounting software uk,small business record keeping software free,small business software india,small business accounting software 2018,best small business software 2017,gentec small business software,quicken small business software for mac,small business accounting software mac os x,small business accounting software new zealand,small business accounting software nz,small business billing software 3.0.1.5,small business software for windows 7,small business software south africa,best small business quoting software,best small business record keeping software,best small business software uk,best small business valuation software,best small business vat software,grants for small business software,inventory for small business software,kiplinger's small business attorney software,managing a small business software,microsoft for small business software,microsoft small business software licensing,office 365 small business software,quickbooks small business software review,small business account keeping software,small business accounting software gst,small business accounting software hmrc,small business accounting software not cloud based,small business accounting software quebec,small business accounting software quicken,small business accounting software uk reviews,small business accounting software with job costing,small business accounting software xero,small business accounting software zoho,small business barcode software,small business bookkeeping software australia,small business employee software,small business epos software,small business good software,small business graphic design software,small business gst software,small business healthcare software,small business hr software canada,small business hra software,small business hrm software,small business hvac software,small business ideas software engineers,small business inventory software quickbooks,small business invoicing software australia,small business invoicing software nz,small business invoicing software uk,small business it software,small business knowledge management software,small business kpi software,small business landscaping software,small business payroll software uk,small business rental software,small business software 1099,small business software 2017,small business software all in one,small business software app,small business software best,small business software collection,small business software commercial,small business software consultant,small business software cost,small business software crm,small business software defined networking,small business software deployment,small business software depreciation,small business software design,small business software examples,small business software excel,small business software for billing,small business software for sales,small business software ideas,small business software maker,small business software market,small business software meaning,small business software must have,small business software near me,small business software news,small business software nz,small business software office 365 business essentials,small business software offline,small business software options,small business software order management,small business software providers,small business software quickbooks,small business software quote,small business software requirements,small business software service,small business software stock control,small business software thryve,small business software where to buy,small business tax software uk,small business top 50 software,small business underwriting software,small business useful software,small business vat accounting software,small business vat software,small business visitor software,small business vpn software,small business wages software,small garage business software,software small business grants,top small business software 2017,very small business software,what is best small business software,what small business accounting software,which small business accounting software review,why small business software,zktime small business software,small business quickbooks,small business 3d printing,quickbooks for small businesses,small business 3d printer,why small businesses fail book,which small business is best,small business loans 0 interest,small business management 6th edition,small business 800 number service,small businesses loan,small business loans 600 credit score,small businesses health insurance,small business 401k plans,small business server vs cloud,small business 401k,how much small business insurance cost,small businesses looking for bookkeepers,small businesses looking for investors,small business 504 loan program,small business for sale in bali,small business 401k providers,small business 401k options,small businesses opportunities,small businesses database,how much small business loan can i get,small business 3pl,small business 7a loan program,how much small business loan,small businesses nz,small businesses for sale in ohio,small businesses for sale near me,small businesses near me for sale,small business 7a loans,small business plan,small businesses for sale in north carolina,small businesses benefits,small business iso 9001,small businesses and cyber security,small businesses website,small businesses online,which small business to start,small businesses under 10k,small business 401k cost,small businesses dc,small business for sale,small businesses for sale,small businesses grants,small businesses to invest in,small businesses for sale in colorado,small businesses to buy,small business ideas,small business iso 9001 certification requirements,small business accounting,small business 20000,small businesses for sale in bc,small businesses and health insurance,small business partnership agreement,small businesses to start,small businesses marketing,small business management,small businesses management,how much small business taxes,how will small business be affected by tax reform,small business under 50000,small businesses for sale in uganda,small businesses to start in kenya,small businesses help,small businesses to start in 2019,small business chapter 7,small businesses list,small businesses start up,small business at home,small businesses from home,small businesses using social media,a small business plan,small businesses gdpr,small business ideas list,how often does a small business have to pay taxes,small business 401k fees,small business xero,small business 8a certification,small business ideas 2019,can small businesses charge for card payments,can small businesses get grants,small business for sale indonesia,small businesses that make money,small businesses without websites,what small businesses make money,how small businesses grow,small businesses to start at home,for small business owners,small businesses and gdpr,small businesses run by a couple,small business partnership agreement doc,small businesses looking for help,small businesses easy to start,small businesses to start in uganda,what small businesses are the most profitable,small business xfinity,small business 401k rules,small businesses on social media,small businesses social media,small business 1099 forms,small businesses 2018,small businesses and taxes,small business proposal template word,small business 101 how to get started,small businesses london,why small businesses need a website,small business administration,small businesses growing,what small businesses are most successful,small business in indonesia,small businesses administration,small businesses you can start with little capital,small business entrepreneurship,small businesses for sale nz,small business quarterly taxes,which small business can i start,how much small business pay in taxes,why small businesses need digital marketing,small businesses and social media,small businesses employment,small businesses jacksonville fl,small businesses hiring near me,small businesses australia,small businesses you can start,how small businesses can save money,small businesses you can start on your own,small business management 6th edition pdf,how small businesses use social media,small businesses 2019,for small businesses,small business resources,small businesses directory,small businesses near me hiring,small business questions and answers,small businesses vancouver,small businesses growth,small businesses around me,small businesses you can start from home,small businesses names,small businesses on amazon,small business kpis,small businesses on facebook,small business 8a,small businesses houston,small businesses victoria,small business questions,small businesses for students,small business in usa,small businesses raleigh nc,small business 50 employees,small businesses calgary,small businesses in the philippines,small businesses philippines,small business 8a program,small businesses columbus ohio,small business 1099,small businesses,small businesses jobs,small businesses with low overhead,small businesses lexington ky,small businesses and technology,small businesses going out of business,small businesses manchester,how much small business make,small businesses in india,small businesses on the rise,small businesses that make millions,small business 8a requirements,small businesses kenya,how many small businesses in the uk,why small businesses succeed,small businesses with high margins,small businesses south africa,small business knowledge center,small businesses for sale melbourne,small business exchange,small businesses us,how small businesses succeed,small businesses on instagram,small businesses nearby,small businesses los angeles,small businesses rochester ny,how often do small businesses pay taxes,small businesses san diego,can small businesses use venmo,small businesses dallas,small business 101,a small business example,when is small business saturday 2018,small businesses are those that employ,small business $20 000 tax break,small business 20000 write off,small business 20k,small businesses in south africa,small business $20 000 tax right off,small businesses closing,small businesses of the future,small business quotes,small businesses quotes,small businesses challenges,small business 20 percent tax deduction,small business job titles list,small businesses with best margins,small businesses canada,small businesses philadelphia,small business nearby,small businesses minimum wage,small businesses nyc,small businesses by industry,what is small business saturday,how many small businesses in the world,small businesses edinburgh,small businesses chicago,small businesses denver,small businesses uk,small businesses selling on credit find that,small business 13 cfr part 121,small businesses boston,small businesses problems,small businesses statistics,small business questionnaire sample,small businesses near me,why small businesses fail,what small businesses are in demand,a small business advantage is,when is small business saturday,small businesses and the economy,why small businesses need social media,small businesses in australia,small businesses working together,are small businesses profitable,small businesses most likely to succeed,are small businesses growing,how many small businesses in the us 2019,of small businesses that fail,in.small business.yahoo.com,small businesses economy,small business ideas in indonesia,small businesses edmonton,small businesses melbourne,small businesses uk statistics,what small businesses need,small businesses examples,small business qualifications,small businesses support,how often do small businesses get audited,small businesses vs corporations,small business partnership examples,entrepreneur vs small business owner,for small businesses product differentiation,small businesses commonly employ,small businesses meaning,small businesses going global,small business 2018 tax changes,which small businesses make the most money,small businesses are typically managed by,small businesses synonym,small business vs startup,small businesses vs large businesses,how many small businesses fail in the first year,how small businesses help the economy,small business 8a definition,small businesses vat,small business definition,small businesses definition,how many small businesses fail,why small businesses are important,how many small businesses in the us,when is small business week 2019,when is small business week,very small business,small businesses should view distribution costs as,small businesses are usually,how often do small businesses fail,small business jobs survival act,small businesses vs big businesses,small business 20 deduction,small businesses are prone to failure,when is small business month,when is small business week 2018,how many small businesses in america,small businesses sydney,small businesses by state,are small businesses dying,small business knowledge center junk mail,small businesses and maternity leave,small businesses brisbane,small business 1099 requirements,are small businesses good for the economy,are small businesses on the rise,can small businesses discriminate,how many small businesses in australia,how many small businesses in canada,how often are small businesses audited,how will small businesses be affected by brexit,in small business development center,on small business,small business $20 000,small business $20 000 instant asset write-off,small business $20 000 write off,small business 100,small business 15 year exemption,small business 20000 tax break explained,small business 20k write off,small business 50 active asset reduction,small business management 6th canadian edition,small business management 6th canadian edition pdf,small business w-9 requirements,small business xerox machine,small business xls,small business xmas party ideas,small business zimbabwe,small business zionsville in,small business zoning,small businesses and brexit,small businesses and the uk economy,small businesses brexit,small businesses contribute to an economy by,small businesses for sale in gauteng,small businesses glasgow,small businesses job creation and growth,small businesses new zealand,small businesses perth,small businesses to start in nigeria,small businesses winnipeg,which small business is best to start,which small business to start from home,why small businesses fail in south africa,will small business rate relief be extended,are small business corporation,are small businesses,are small businesses exempt from ada,are small businesses exempt from cas,are small businesses exempt from fmla,are small businesses exempt from osha regulations,are small businesses open on labor day,are small businesses successful,can small businesses charge for carrier bags,can small businesses claim back ssp,can small businesses hire foreign workers,can small businesses issue bonds,can small businesses use zelle,for small business accounting software,for small business and entrepreneurship,for small business bookkeeping,for small business grants,for small businesses are the heart of the financial market,for small businesses ideas,for small businesses the inputs of an operating system,how many small businesses in australia 2019,how much small business cost,how much small business insurance do i need,how much small business server,how much small business tax do i pay,how often do small businesses file taxes,how often do small businesses get hacked,how often should a small business give raises,how often should small business post on facebook,how often should small businesses post on instagram,how small businesses cheat on taxes,how small businesses compete with larger businesses,how small businesses start,is small business a startup,is small business administration,is small business loan,is small business profitable,is small business taxes,on small business apps,small business $20 000 tax benefit,small business $30 000 write off,small business $30000 asset write off,small business 11th class,small business 30000 write off,small business 30k write off,small business 5 year survival rate,small business 50 reduction,small business 50k capital,small business 51 percent rule,small business 5k capital,small business 6 million asset test,small business 6m,small business 90 day plan,small business adalah,small business administration 7a loan,small business administration adalah,small business chapter 9,small business chapter 9 class 11,small business i-9,small business loan 650 credit score,small business versus hobby,small business w-9 form,small business xero training,small business xerox shop,small business xls template,small business xmas party saskatoon,small business zambia,small business zelle,small business zero investment,small business zero percent credit card,small business zero rated,small business zurich,small businesses 07712,small businesses 15 minimum wage,small businesses 30339,small businesses 33023,small businesses 33716,small businesses 35242,small businesses 44077,small businesses 46250,small businesses 48858,small businesses 55106,small businesses 55416,small businesses 60 percent,small businesses 60638,small businesses 77060,small businesses 77077,small businesses 77092,small businesses 85013,small businesses 85027,small businesses 85254,small businesses 85308,small businesses 97229,small businesses account for the majority of the industry sector,small businesses and minimum wage increase,small businesses bank,small businesses birmingham,small businesses bristol,small businesses canada vs us,small businesses cape town,small businesses credit cards,small businesses development,small businesses dublin,small businesses durban,small businesses dying,small businesses economic impact,small businesses employees,small businesses every town needs,small businesses for sale in durban,small businesses gold coast,small businesses government contracts,small businesses greenville nc,small businesses hamilton,small businesses have traditionally added,small businesses hawaii,small businesses hiring in austin,small businesses hiring in orlando,small businesses hull,small businesses in 75227,small businesses in indonesia,small businesses jackson tn,small businesses jacksonville nc,small businesses jamaica,small businesses japan,small businesses johnson city tn,small businesses kansas city,small businesses kelowna,small businesses kent,small businesses kingston,small businesses knoxville,small businesses knoxville tn,small businesses like avon,small businesses like independent bookstores,small businesses london ontario,small businesses looking for websites,small businesses miami,small businesses milwaukee,small businesses mississauga,small businesses nashville,small businesses near 08021,small businesses near 77092,small businesses near cleveland ohio,small businesses near durham nc,small businesses near minneapolis,small businesses near philadelphia,small businesses near toledo ohio,small businesses needed,small businesses new orleans,small businesses newcastle,small businesses one can start,small businesses ottawa,small businesses portland oregon,small businesses quad cities,small businesses quizlet,small businesses reddit,small businesses rely heavily on long-term financing,small businesses responsibility in relation to privacy,small businesses revenue,small businesses richmond va,small businesses under 5000,small businesses under socialism,small businesses under trump,small businesses us economy,small businesses vancouver wa,small businesses vat threshold,small businesses vermont,small businesses versus,small businesses versus large corporations,small businesses video,small businesses vs company,small businesses western sydney,small businesses with good profit,small businesses with high returns,small businesses you can do from home,small businesses you can open,small businesses you can start in nigeria,small businesses you can start in south africa,small businesses you can start with less than $1000,small firms and businesses,the small business 7(a) guaranty program quizlet,what small businesses are trending,what small businesses can i start,what small businesses make the most millionaires,what small businesses need to know,what small businesses need to succeed,when do small businesses fail,when small businesses fail,when will small business rate relief end,which small business credit card is best,which small business is best in india,which small business is most profitable in canada,which small businesses are profitable,who do small businesses fail,who is small business growth alliance,who is small business loans,who is small businesses,who small business owner,why small businesses are better,why small businesses are important to a community,will for small business owners,will gardner small business investor alliance,will my small business get audited,will my small business succeed,will small business benefit from tax reform,will small businesses benefit from brexit,with small business loan,with small businesses in very competitive industries,without investment small business,without investment small business ideas,99designs small business,small businesses backbone of economy,small businesses represent the majority of firms in the

CommentClosePost

Pencarian Google