- 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.
Symbianize Forum
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!
Dental Database System(Need Help)
- Thread starter Redsolstice
- Start date
- Replies 18
- Views 1,260
- Messages
- 4,384
- Reaction score
- 256
- Points
- 188
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)
Creating Database and Table(s)
Download ka ng XAMPP (pwedeng WAMP, LAMP, or MAMP kung naka mac ka)
Installation (Windows 10)
Creating Database and Table(s)
Last edited:
- Messages
- 59
- Reaction score
- 0
- Points
- 26
- Thread Starter
- #4
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
- Messages
- 4,384
- Reaction score
- 256
- Points
- 188
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.
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.
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.
- Messages
- 297
- Reaction score
- 1
- Points
- 28
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.
- Messages
- 59
- Reaction score
- 0
- Points
- 26
- Thread Starter
- #8
gumagawa po kami sir ng false teeth and may mga stock po kami ng dental parts
- - - Updated - - -
nahihirapan nga po ako sa MS ACCESS dahil wala saken yung sample ng Production nila.and then paano po ba maa access yung MS ACCESS sa ibang computer kung wala kami kahit server
- - - Updated - - -
pasensya na sir 2 Years Information Technology lang natapos ko wala pa ako sa bracket na ganyan.
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
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
- Messages
- 59
- Reaction score
- 0
- Points
- 26
- Thread Starter
- #10
pinag aaralan ko nga ngayon yung MS ACCESS hindi pa ako nakakagawa ng complete table pero alam ko na function nila.hindi ko lang sure kung need ng SERVER wala pa ako alam sa pag operate nun and ano ba specs need for Server.
- Messages
- 4,384
- Reaction score
- 256
- Points
- 188
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.
Last edited:
- Messages
- 297
- Reaction score
- 1
- Points
- 28
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.
- Messages
- 59
- Reaction score
- 0
- Points
- 26
- Thread Starter
- #13
Sa log-in system d ko pa sure kung gagawin ko na need ko lang now is magkaroon sila ng application na ma eencode nila yung previous and present record/data nila.
- - - Updated - - -
may idea naman ako sa peer to peer sir.yung ODBC hindi ko pa alam yan hehehe nagaaral pa ako now.sobrang nakaka stress lang kasi bukas na yung meeting namin.
- Messages
- 297
- Reaction score
- 1
- Points
- 28
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
e. g.
relationships
form with subform
form wizard
reports
Last edited:
gusto ko din iyan sir hehehehe matuto gunawa dedicated server
dont worry sa degree or anything kasi ako grumaduate ng wala natutunan masyado sa IT, ngayon lang ulit na sumubok ako maglibang dahil sayang naman despite working unrelated sa IT. kaya mo iyan, sir!
- - - Updated - - -
yes peer to peer lang without server pero totoo po na one user access sa database lang pwede gumamit kasi kpg sabay sabay eh read only status mangyayari sa iba at mag eerror submission nila or worst magamit index_id pero nagka agawan dahil sabay.
dont worry sa degree or anything kasi ako grumaduate ng wala natutunan masyado sa IT, ngayon lang ulit na sumubok ako maglibang dahil sayang naman despite working unrelated sa IT. kaya mo iyan, sir!
- - - Updated - - -
yes peer to peer lang without server pero totoo po na one user access sa database lang pwede gumamit kasi kpg sabay sabay eh read only status mangyayari sa iba at mag eerror submission nila or worst magamit index_id pero nagka agawan dahil sabay.
- Messages
- 59
- Reaction score
- 0
- Points
- 26
- Thread Starter
- #16
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?
- Messages
- 297
- Reaction score
- 1
- Points
- 28
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.
- Messages
- 59
- Reaction score
- 0
- Points
- 26
- Thread Starter
- #18
sige sir try ko pag aralan din yan VB.Net w/ Community Edition salamat po ulit sir
- Messages
- 895
- Reaction score
- 1
- Points
- 28
TS you mean this one?
nagawa ko na yan last year pa.
then nirevised ko during ecq.
deployed na din sa isang dentist na friend ko and i just gave it for free. (free din kc ang dental problems ko hihihi)
the idea, galing kay doc, then napagtripan ko lang na gawin since 10 yrs+ na akong nasa development.
may mga ibang client na din ako using that system, and universal kc hindi lng pang dental.
applicable din sa any kind of clinic ng tao.
as for my another pending client na dentist. they own one of the leading na pagawaan ng crowns dito sa pangasinan.
naisip ko na kung ano ang gagawin ko sa system nila that features:
- monitoring of their clients lalo na't ung iba is installment sa payment, so that is for billing.
- then may inventory ng mga materials nila pra sa mga pustiso, and that is inventory.
- and nag iisip pa ako ng idadagdag.
btw and Development Platform ko is:
VB.NET, mysql
View attachment 380901
pero yan lang pwede kong pakitang screenshot.
just in case you want some ideas, visit mo itong thread na ito
https://www.mobilarian.com/showthread.php?t=636763
ang dami ko nang nasagot na query dyan regarding sa thesis and other systems.
hindi na nga lang ako active kc hindi nag increase ang reputation ko even na kinausap na ng thread starter ang admin before (sy.mb.ia.nize pa dating name ng site) dahil ako na ang nag maintenance ng thread.
but anyway, madali lng ung system m. hnd pa yan nakakadugo ng utak
nagawa ko na yan last year pa.
then nirevised ko during ecq.
deployed na din sa isang dentist na friend ko and i just gave it for free. (free din kc ang dental problems ko hihihi)
the idea, galing kay doc, then napagtripan ko lang na gawin since 10 yrs+ na akong nasa development.
may mga ibang client na din ako using that system, and universal kc hindi lng pang dental.
applicable din sa any kind of clinic ng tao.
as for my another pending client na dentist. they own one of the leading na pagawaan ng crowns dito sa pangasinan.
naisip ko na kung ano ang gagawin ko sa system nila that features:
- monitoring of their clients lalo na't ung iba is installment sa payment, so that is for billing.
- then may inventory ng mga materials nila pra sa mga pustiso, and that is inventory.
- and nag iisip pa ako ng idadagdag.
btw and Development Platform ko is:
VB.NET, mysql
View attachment 380901
pero yan lang pwede kong pakitang screenshot.
just in case you want some ideas, visit mo itong thread na ito
https://www.mobilarian.com/showthread.php?t=636763
ang dami ko nang nasagot na query dyan regarding sa thesis and other systems.
hindi na nga lang ako active kc hindi nag increase ang reputation ko even na kinausap na ng thread starter ang admin before (sy.mb.ia.nize pa dating name ng site) dahil ako na ang nag maintenance ng thread.
but anyway, madali lng ung system m. hnd pa yan nakakadugo ng utak
Attachments
Last edited:
