Opinions on Access

[tailes151]

Here's the deal. I have a computer proficiency exam this friday. It covers word, excel, powerpoint and access. I know how to do all of the things in the study guide, besides the things with access. I knew the basics of it 4 years ago, but after not using it I'm practically back to zero. I'm hoping some of you guys will be able to give me an opinion on whether or not Ill be able to learn how to do these by this friday night. I'm not sure if those are basic commands that I can learn from tutorials or not. I'm hoping they're like the Word guide where I have to know how to change the font size =/

So, let me know if you think it's possible, and if so I'd appreciate it if you could point me in the direction of a good tutorial.

Thanks for the help.

 

[BFG10K]

Most of that stuff is pretty standard. I'd suggest firing up Access and going through each one and if you get stuck use the online help or Microsoft's online help system.

 

[Drakkon]

yikes...i consider myself to be farily proficient in ACCESS and i dont know how to do some of that stuff (most the query stuff but most of that i just type in my own SQL so if ya know how to do SQL your golden 😉)
really all of it looks learnable though in 2 hours...i mean start up access and use the help ssytem....if u can do those 2 your well on your way to being an access master

 

[tailes151]

Awesome, just found Microsofts online lessonish things. They're really helpful.

 

[beggerking]

Access essentials are easy. pick up a "learn access in24hrs" book and fire away. You should be done before Friday.

You should learn :
1.crosstab query, union query, update query, delete query, select query
2. switch between sql mode and design mode
3. macros
4. how to create tables using design view + using wizards
5. built-in functions such as dateadd(),datediff(),format()..etc
6. if you have time, some vba /modules to create your own function.
7. upsizing/downsizing, secure your database (if time allows)

 

[tailes151]

As of right now I just want to learn the things on that list posted before. Are all of those required for me to do them?

 

[beggerking]

1 thru 5..
basics of access.. most books will cover more, but 1-5 are important ones to really know...