- Messages
- 59
- Reaction score
- 0
- Points
- 26
Mga sir patulong naman po pano gumawa ng database sa Dental Clinic wala po ako alam sa programming masyado na po kasi luma yung MS Access and hindi rin ako marunong ng MySQL please help me need ko sa trabaho.
Most of our features and services are available only to members, so we encourage you to login or register a new account. Registration is free, fast and simple. You only need to provide a valid email. Being a member you'll gain access to all member forums and features, post a message to ask question or provide answer, and share or find resources related to mobile phones, tablets, computers, game consoles, and multimedia.
All that and more, so what are you waiting for, click the register button and join us now! Ito ang website na ginawa ng pinoy para sa pinoy!
Paanong database ng Dental Clinic? App ba yan na pag-ssave at retrieve (CRUD) lang ang gagawin? May log-in system din ba? Paki-state yung mga functions / features ng gagawin / pinagagawa sayo.
Download ka ng XAMPP (pwedeng WAMP, LAMP, or MAMP kung naka mac ka)
Installation (Windows 10)
https://www.youtube.com/watch?v=-f8N4FEQWyY
Creating Database and Table(s)
https://www.youtube.com/watch?v=n7c5zMk8cx4
bale ang function nya is for doctor/clients na mag papa order ng dental parts,may Sales Invoice, Job Order, Prices,Doctor List and then the photo of the (Dental Thing)which is the Crown na nakikita ng doctors kung tama yung Crown na ginawa namin.and then gusto rin ng may ari na kami lang makaka access nung application/database which means hindi nila pede ma edit/delete yung data.pasenya na po kung medyo magulo yung explaination ko sana naintindihan nyo po and matulungan nyo ko
Malaki-laki pala task mo, sir.
"bale ang function nya is for doctor/clients na mag papa order ng dental parts,may Sales Invoice, Job Order, Prices,Doctor List and then the photo of the (Dental Thing)which is the Crown na nakikita ng doctors kung tama yung Crown na ginawa namin."
Alamin mo kung paano yung process kapag magpapa-order yung doctor/clients ng dental parts. Paano yung process nyo ng pagbibigay ng sales invoice pati laman nito, process ng job order (ito kasi yung gagamitin mo sa pag-dedesign ng form/page/report mo para sa mga ito).
Yung sa prices? Prices ng ano yun? Service(s)? Dental parts / products (may stock kayo?)?
Photo of the Dental Thing? Ano ito? Gumagawa ba kayo ng false teeth or part ng dental service(s) nyo na kailangan nito? Or both?
"and then gusto rin ng may ari na kami lang makaka access nung application/database which means hindi nila pede ma edit/delete yung data."
Pwede naman itong standalone or accessed by multiple computers / users within your LAN, tapos may user-level.
PS:
Di po ako pro programmer (aspiring) pero try ko na din tumulong.
Bawal ba gamitin MS Access kung ito ang gagamitin mo? May latest naman 'to. Tables, Queries and Forms lang gagamitin mo. I-establish mo lang maayos relationships ng tables. Mas mabilis kung dito mo gagawin. Madugo kung tatalon ka pa sa iba. It will take time lalo kung web-based at wala ka pa kamong masyadong alam. Kung need mo na talaga, I suggest i-Access mo muna. Pwede mo naman i-network thru ODBC gradually gamit ibang programming language. Habang inaaral mo pa.
1) Kailagan mo munang kunin specifical requirements at gawan ng flowchart ng mga process.
2) Decide what programming language dependingnon the learning curve and ease of use.
Pwedeng maging standalone ang web application pero madami kang aaralin like the UI-part (HTML/CSS/Javascript &/or Bootstrap) at back-end language (PHP/ASP.NET C#).
Pwede ding VisualBasic or VisualBasic.net kasi ang coding environment nila ay mag drag and drop na user interface at icocode mo nalqng functionalities without coding the design too much.
Pwede ding Python Programming language whereas things are easy but manually in everything to be typed as well.
3) Tapos aralin mo design ng UI at mag CRUD which is to make your application interact with a database.
to make a system talagang manual'n po iyan hehehe.. from idea, design, code to deploy. may mga tutorial if willing ka and I suggest VisualBasic language para magrasp mo kaagad.
kung okay lang sa iyo naman to stick with MS Access na input lang ng input pero gusto mo maaccess sa ibang computer without a server pwede kang gumawa ng shared folder sa network ng office niyo at doon mo ilagay yung file at mabuksan mo any computer connected to the same network
Same suggestion. Mag-VB.Net ka na lang muna para mas madali mo maintindihan, at para hindi ka na din gaano mamroblema sa UI design, using Microsoft Visual Studio. Libre naman yung community edition nito. At tama, may mga tutorials din kagaya ng basic CRUD fuctions, pag-gawa ng log-in system, etc. Madami. Search ka lang sa google/youtube.
Peer-to-peer gagawin mo. Kahit wala kang dedicated server. Yun nga pwede ka gumawa ng shared folder, kaya lang... Hindi ata pwede magsabay mag open dalawang users. Makakapag open yung isa, the rest ata read only. Paki check na lang. Posible, kung ODBC pwede na multiple users. Gagawin mo syang back end ng isang PL.
Gaya ng sabi ko, kung established na mabuti yung tables ng database mo, abrakadabra lang sa MS Access tapos na yan using wizard
e. g.
relationships
form with subform
form wizard
reports
Salamat ulit sir.San ba pwede bang DL ng MS ACCESS na hindi trial/and kung sakaling yun yung gamitin namin nabibili ba yun?and magkano?
Around 5K o higit pa. Not sure. Try mo na lang igoogle. Proprietary ang MS. Kaya you have to purchase. Pero kung meron sa office nyo o baka makahiram ka ng PC na may Access mas maganda.
Kung may time ka na o magawan mo na ng paraan makapag aral, gaya ng suggestion dito, VB. Net may community edition walang hassle makakuha ng copy, pwede mo idownload for free via Visual Studio.