How to create DASHBOARD in Ms Access

[@antoniocarlosfuertes7810]

Salamat sa iyong tutorial Pre. Laking tulong ito lalano may ginagawa ako ngayon na program gamit ang access para sa Asset and Inventory System namin dito. Andito ako ngayon sa Canada bro.

[@EdcelleJohnGulfan]

Maraming salamat sa panonood bro.

[@tomseed2000]

Excellent video, great info, THANKS!!!

[@EdcelleJohnGulfan]

Thanks also for watching.

[@Teklitkiflay]

this is an amazing .thank you my brother. keep it up.

[@EdcelleJohnGulfan]

Welcome.

[@bgray79]

Great ideas! I'd like to make a couple of suggestions. First, the sound quality. We can hear the hard consonants as your breath hits the microphone. And if you could increase the input volume that would be great, too. Second, I don't recommend the use of so many colors. Things tend to get too flashy. Other than that, good stuff!

[@EdcelleJohnGulfan]

Thank you so much for your suggestions. It's highly appreciated. And also thank you for watching.

[@mohammadbelmehdi1331]

Hello, is it possible to conditionally format the graph? for example when sales are below 2000 the bar is red and if it's above it then it's green? thank you

[@DanielNFlomo]

Thanks so much for the effects bro. I really appreciate

[@EdcelleJohnGulfan]

Welcome. Thanks for watching

[@abdulazizabubakar6539]

This is wonderful ❤️

[@EdcelleJohnGulfan]

Thanks for watching

[@sephjvr5979]

Thank you for an awesome tutorial! How do I get the months in the Axis Category to filter into the correct order E.g. (Jan - Feb - March)?

[@EdcelleJohnGulfan]

Nice question. Any way, in row source, click the 3 dots ... to open the query builder. Change the format of your date into numerical value. Let's say 1,2,3... and sort it to ascending. I will create a video for this tonight.

[@EdcelleJohnGulfan]

Here's the link. kzbin.info/www/bejne/hGnFnoJ4qtaJq8U

[@irperera]

Which video did you create the report in?

[@hansasare4078]

Great and awesome video...I have been looking for such a tutorial..... please can you share the file?

[@robertberghammer669]

Nice instruction, What I see is that the months in the chart are in some random order. How do you order them from left to right or from right to left?

[@EdcelleJohnGulfan]

Here's the video: kzbin.info/www/bejne/hGnFnoJ4qtaJq8U

[@jungjungdelosreyes4147]

Sir can it be assigned a permanent color category in the pie chart? Thanks

[@kierikitiw]

Nice po Sir, andme ko po natutunan sa inyo. Pde po ba ung kunware may comparison ang dalawang year? Kunware current year at last year. Tpos may magdidisplay na variance base sa encode na data sa table?

[@EdcelleJohnGulfan]

Pwede po. Instead na current year, last year yung ilagay sa criteria. Same concept pa rin.

[@EdcelleJohnGulfan]

Salamat pala sa panonood.

[@excelvbamacrosbuddy1999]

Good❤

[@DonJabinal]

Do you have a tutorial to display images in a dashboard that will change like a slider?

[@EdcelleJohnGulfan]

Nice idea. On Timer Event Function. I'll to create.

[@abrar1945]

I am creating an employee management system, and want to create a dashboard form where i want to show active employees , how many on vacations etc, how to achieve this?

[@EdcelleJohnGulfan]

Just use the DCOUNT function.

[@EdcelleJohnGulfan]

Same process with dlookup and dsum.

[@chibensonluxana]

Nice

[@murugana3013]

Goood

[@EdcelleJohnGulfan]

Thanks

[@Moizfoodi]

Mr. Edcelle i have to make one correction in the syntax =Nz(DSum("FinalAmt","SalesQ","Month='" & [MTD] & ","),0). because its not working. Als the first one : =Nz(DSum("FinalAmt","SalesQ","SaleDate>=#" & Date() & "#"),0)

[@greyairen]

you have an error. it should be =Nz(DSum("FinalAmt", "SalesQ", "Month='" & [MTD] & "'"), 0). For the today's code is =DSum("FinalAmt","SalesQ","SaleDate>=#" & Date() & "#")

[@vincenzocompagnone2636]

Hi can i have file access? Thanks

[@gossipslander9226]

please do a video on sale module

[@EdcelleJohnGulfan]

Yes sure. The POS side.

[@jannazanch8941]

Hi po, kindly check kung ano mali,, error po eh =Nz(DSum("GrossAmt","ExpSummary","Month='" & [MTD] & "'"),0)

[@EdcelleJohnGulfan]

Pwede mo e.share file mo mam para ma.check ko.

[@jannazanch8941]

@@EdcelleJohnGulfan where to send po, and alsp pede mag enroll sayo para maenhance p alam ko

[@jannazanch8941]

@@EdcelleJohnGulfan thank u hs

[@EdcelleJohnGulfan]

[e-mail]

[@raymungarbo]

Sir magkaano pagawa nang program?

[@EdcelleJohnGulfan]

Depende po sa project sir. For more details, you can contact me in fb messenger ED PEREZ MATUGAS GULFAN

[@EdcelleJohnGulfan]

Salamat sa tanong

[@kemalayaz6459]

Good İdea

[@EdcelleJohnGulfan]

Thank you

[@chibensonluxana]

can i have the file please

[@albertlavezares8441]

Ang bilis masyado, hinde masundan....

[@EdcelleJohnGulfan]

Pasensya. Pause mo nalang if medyo mabilis. Next time hinaan ko nalang ng konti. Thanks for watching.