MS Access STEP by STEP Tutorial for Beginners (Start to finish)
Vložit
- čas přidán 6. 09. 2024
- This is a step-by-step tutorial on how to make a Database using Microsoft Access.
RELATED CONTENTS:
How to make table in microsoft access,
How to make form in microsoft access,
How to make query in microsoft access,
How to make reports in microsoft access,
How to use microsoft access,
How to insert command buttons in microsoft access,
How to create database using microsoft access,
How do i log into microsoft access?
How to make Access Form looks professional.
Access form Tutorial.
#MicrosoftAccessTutorial
#MicrosoftAccess
#MicrosoftAccessDatabase
#EdcelleJohnGulfan
thankyou sa knowledge!!!, looking forward to complete tutorial sir kahit abutin tayo ng araw hehehehe. napakalaking tulong ng lahat ng tutorials mo sir sa ongoing projects ko po maraming maraming salamat
godbless sir
Maraming salamat sa panonood sir.
edcelle john gulfan very good to this tutorial i suggest to cut this into 7 minutes in every topic session in order to learn carefully
Thanks for the suggestion Mohaimen.
Sir napaka husay po ng tutorial mo. Ito ung hinahanap ko kc from START to FINISH nga talaga. Ngaun mkakagawa na ko ng database na kailngan ko. Looking forward sa iba mo pang tutorials pati ung LOG-IN po sana na step by step. Maraming slamat po!!
Salamat sa panonood.
Link po sa login. Login: czcams.com/play/PLxBRM3hoV3nPnbZUiW92Kgw-gPCeFlp48.html
@@EdcelleJohnGulfan yown salamat sir my link agad thank u po!!😁
@@ryanm.8282 welcome po.
Maraming salamat sa pag share ng gift mo sir. God bless po!
Welcome po and maraming salamat sa panonood.
Insightful! Thank you Sir for sharing! God bless!
Thanks for watching
@@EdcelleJohnGulfan I am interested in learning MS Access? ang mga topics or module sa Level 1?
Hi sir, I was enjoying watching your educational videos. Can you make video specifically on price update without affecting historical price.
Sure I will.
I have always been reviewing this Sir.
Thanks so much
Salamat sa mga videos mo.👏
Salamat din sa panonood Sir.
salamat po sir sa video na to
Salamat sa panonood .
very informative thank you..more power..please make video how to edit or update the data entered on the forms thanks
Sure. Thank you for watching.
@@EdcelleJohnGulfan ur welcome.im looking forward your next video.thank u
Thank you po Sir sa iyong naishare na kaalaman. Pwede po pashare ng sample ng school database. maraming Salamat po and God Bless
Hi sir maraming salamat sa panonood. Meron akong ginawa pero hindi ko natapos due to typhoon Odette dito sa cebu last December. Until now hindi ko na nabalikan.
But meron akong free templates for educational purposes lang. Merong link sa description ng mga videos.
Wonderful
Thank you for watching.
Sir salamat sa video mo...
Maraming salamat din sa panonood nyo po.
Very informative
suggest ko boss... kung naa kay time, database pud sa List of trainings attended sa mga employees... kanang basic lang. thanks boss
Salamat sa suggestion boss
I want add every months 1st day employee name , attendance etc data in translation details automatic in table for further entry
Sir Salamat sa pag turo. Sir gusto ko sana magpatulong sayo ng pag gawa ang front end at back end system. Pwedi kaya? Pwedi online? Magkano kaya Sir? Gahol nako sa oras pag aralan at kailangan ko na sya, Ty sir sa pag sagot.
Pwede sya malagay sa online pero complicated. Hindi kasi sya designed for online.
I can teach one on one through zoom. Email me eduardogulfan@gmail.com
Hi Edcelle. Kamusta po? Naway nasa mabuti kayong lalagayan at pati na rin ang inyong mga pamilya. Pwede ba magpagawa sa inyo
Pwede po. Email me at eduardogulfan@gmail.com
Sir paano po kong e print/preview ko lahat ng list of employees wala kasi sa tutorial niyo pa help po.tanx
Ilagay mo to sa command button mo.
Docmd.OpenReport "name of report", acViewPreview
Pero tanggalin mo yung creteria sa query.
sir paano gumawa ng report inventory halimbawa gusto ko report ng ball pen from jan1 2023 to jan31 2023, ipapakita sa report yun date stockin or stock out then yun quantity then yun stock on hand. halimbawa jan1 stock in 10 QOH 10, JAN 2 STOCK OUT 3 QOH 7, JAN3 STOCK IN 10 QOH 17
Wow
Thanks for watching.
Good day sir, pagka tapos po ma edit ng database paano po gawin Yung log in na gusto nyo na gamitin yung gaya ng pinaka unang bungad po ng video nyo po.
sir pwede pong lagyan ng close button sa preview report?anung command po nya
Pwede po.
DoCmd.Close
thank youuu
Welcome
Good
Pwede po gawa kayo tutorial ng kung pano po maging ganyan itsura ng data base
Pwede po.
Salamat sa suggestion
great
Idol paano po ma reset yung numberimg sa table, kasi halimbawa kapag mag delete ako ng isang record ex. no.3,
Ang nang yayari ganito ,1,2,4,5,6,7 walang 3
E.delete mo yung field na auto numbering. Tapos gawa ka ulit ng another field which is auto numbering ang data type.
Pwede din ito. Reset mo through VBA.
czcams.com/video/X-HelFgW5_k/video.html
@@EdcelleJohnGulfan thank you po.
Welcome
Hai, Sir.....
Can we get an example of the MS Access this file ?
Thanks.
There are free template in this channel. You can check in the description of my videos.
Please create New Video & File MS Access Investory Material In Out at Warehouse.
Thanks you before 🙏🙏🙏
Sir salamat sa video nyo po. Paano po pag 3 pages ang form po. pwede po ba yon
Gusto mo gawing 3 pages? Pwede yan either vertical or horizontal. Gagawa akong video nyan.
Salamat sa panood.
@@EdcelleJohnGulfan May word file kasi kami sa church na form na gusto ilipat sa access ng bossing ko kaso dko alam paano gawin kasi nag dikit dikit na lahat hehehe
Hi Sir! Super helpful ang video mo. Thanks for sharing. I have this file from MS Access 2007 pa and working on a data that was created previously by another person. Inaaral ko ang video mo para matuto at magamit ito. Ano ang ibig sabihin kapag merong lumabas na message na "The "OpenQuery" macro action cannot run with the specified "View" argument either when in disabled mode or when called from an embedded macro". What should I do with this? Thanks in advance for the help.
Send me the screenshot @ Ed Perez Matugas Gulfan. FB account ko.
Broad kasi yan. Either naka embed sa reports, sa macro arguments or compatibility. Pakisend nalang. Salamat sa panonood.
pwede po mag pa tutor via VC?
Yes po.
sir pls help, pag niclick ko po yung print button ayaw R_Employee_List Query bakit po ganun
Maraming reason mam. Pwedi mong i chat yan sa fb ko. Hindi kasi makasend ng screenshot dito. Fb ko ay Ed Perez Matugas Gulfan
Sir pwde ba mg formula...example pag lagay ng bdate nia din sa age equivalent na ung aged nia?..slamat sa pg share
Yes po in query or in table using calculated field.
I will make a tutorial for that soon.
hello sir! Bakit sinubuan ko gawin ung sa log in na tutorial nyo using code builder wala naman syang error pero kapag na click na po ung proceed wala po nangyayari
Try mo daw check yung Microsoft access library at Microsoft object library sa tools reference.
@@EdcelleJohnGulfan tapos ano po hahanapin po don o ggawin po
Sir when clicking "Form" button, form must be blank/new by default, it is possible?Thank you
Yes. On click event, type this...
DoCmd.Openform "Name of form" , , acNewRec
@@EdcelleJohnGulfan sir may menu button po ako, na when i click the form, may data pa din po. inilagay ko po yung code sa button na kapag ng click is going to new form po.kaso may data pa din po thank you
Sir na email ko yung sample project ko sa inyo. na need ko na blank/new by default sana..thank you :)
Hi paano po ito lagyan ng login form?
Good afternoon po, nag ooffer po ba kayo ng services like making database sa ms access?
Yes po. Most of my clients are in abroad.
Kahit ano na system.
Hello Sir Edcelle Paano po yung ID number Hindi Siya Automatic yung ako mismo ang mag gagawa ng ID Number
Sa data type po yan. Kung ayaw mo ng auto numbering, pwede na e.select mo Yung Number or short text. Sa table setting yan makikita.
@@EdcelleJohnGulfan Hello Sir Pwede po ba kayo mag playlist ng tutorial for Benninger's
@@EdcelleJohnGulfan Sir pwede po ba kayo gumawa ng tutorial na may search field tapos ang files na e aaccess mo ay from the powerpoint title
Di ko alam kung pwede ba yan sir.
may free sample ka ba na file ng pinakita mo sa unang part ng video mo? Thanks
May sample na naka.attached. check the link below the description.
sir possible po ba na maconnect yung mysql pra dun ma store yung data ng every tables pero yung forms at report is via MS Access?
Back end ang Mysql server then Front End ang Ms Access. Yan po ginagawa sa mga MS DEVELOPER. Data storage ng access kasi is limited kaya need ang external connection like sql server.
Yes po ang sagot at salamat sa tanong.
@@EdcelleJohnGulfan sir, can make a video tutorial kung pano e.setup yung mysql server sa MS access khit simple data entry form lng pra po may guide kaming mga beginner?
Sir pwede payroll pls
Sige po. Try natin yan.
Sir paano po ba e combine o pagsama-samahin ng mga forms kagaya sa menu niyo po?
Use navigation form sir.
czcams.com/video/rV1hgP3qBZM/video.html
Hi
HI po sir do you customized po or teach po? where to contact you po
eduardogulfan@gmail.com
Cell#09336556846
Sir make this video in english.
Soon
Sir pm ako messager mo
Tnx
Ok I'll check
sir edcelle morning pwedi po makahingi ng cellphone no. nyo po salamat
09336556846