i-teach-u databases - frontsheet - dashboard

[kamikim1]

very nice and appreciative training sir question: why are'nt u using 2007 version of access

question:we cannot do any calculation like excel in access

right?

question: can acess be compared to excel or they r 2 different species

[JackBarnett21]

@kamikim1 microsoft sell 20o07 access separately so it is more difficult to get a copy

you can do calculations in access

leopards and giraffs excel can do a lot of things access can do a lot of different things

best wishes

[JackBarnett21]

Thanks - I enjoyed making it.

[maxtonethedirector]

thanks for the lessons.

[JackBarnett21]

great.

[killerdragonov]

Thanks It was really helpful

[Ilovelyrics1]

Thanks Jack you've helped me secure a job becuase of your tutorials.

Thankyou!

[JackBarnett21]

i will accept a percentage as commission. haha.

best wishes

jack

[benz225]

WOw. thanks man this is awesome

can you also teach how to connect a form from another Access file to your main database?

the reason that I am asking this is that I want to have a Access database table on one computer in my network that different forms form different computers can import data to the same table. the use of it will be easy to back up and having one secure file that only manager can open it.

cheers,

Parsa

[JackBarnett21]

am away in france for a couple of weeks. will look into it when i get back. jack

[Firchild]

Just password protect any management forms using vba. That'll sort it (I've got a couple of vids on this)

[Firchild]

Nice tutorial. One thing I would point out is that a "Frontsheet" is commonly known as a "Switchboard" in database parlance. Secondly, you don't actually need a table to produce a form, forms can be created independently of tables.

[JackBarnett21]

thank you for both points. i dont like the term switchboard and prefer interface or frontsheet and i prefer to say that databases are created from tables. and therefore will continue to use tables for forms. but thank you for these suggestions.