Brand New To Access

foxfinance

New member
Local time
Yesterday, 23:03
Joined
Mar 30, 2008
Messages
6
Good day everyone,
I just took a college course Access 2007 where I learned how to make tables, queries, relationships, reports and forms - but only those basics. Recently I've been looking at the standard Access 2007 templates to get some ideas, Sales Pipeline to be specific, and these templates are wayyyyy beyond my skill. After reviewing the Sales Pipeline template in design view, I stumbled upon the "MsysObjects" table. I've been told that this type of table can hold all the objects in the database, however, when I tried to use "help" to learn more about this type of table, there were no results. Additionally, I went to Barnes and Nobles trying to research this in various books, but there were no listings in the index for any of them. The MsysyObjects table seems to be a pretty powerful tool, but why is it such a big secret? Also, as I said before, I have NO programming experience and I have no idea if I should TRY to learn SQL code, VBA code or Macros first. Access seems to be a very powerful database software, but figuring out where to begin is overwhelming, especially for someone just starting out. So once again, if someone can point me in the right direction about learning (how did you learn when you first started out?) more about MSysObject and what do I need to learn first: Macros, VBA or SQL, I'd really appreciate the input. Thanks.
 
Good day everyone,
I just took a college course Access 2007 where I learned how to make tables, queries, relationships, reports and forms - but only those basics. Recently I've been looking at the standard Access 2007 templates to get some ideas, Sales Pipeline to be specific, and these templates are wayyyyy beyond my skill. After reviewing the Sales Pipeline template in design view, I stumbled upon the "MsysObjects" table. I've been told that this type of table can hold all the objects in the database, however, when I tried to use "help" to learn more about this type of table, there were no results. Additionally, I went to Barnes and Nobles trying to research this in various books, but there were no listings in the index for any of them. The MsysyObjects table seems to be a pretty powerful tool, but why is it such a big secret? Also, as I said before, I have NO programming experience and I have no idea if I should TRY to learn SQL code, VBA code or Macros first. Access seems to be a very powerful database software, but figuring out where to begin is overwhelming, especially for someone just starting out. So once again, if someone can point me in the right direction about learning (how did you learn when you first started out?) more about MSysObject and what do I need to learn first: Macros, VBA or SQL, I'd really appreciate the input. Thanks.
MsysyObjects is onr of the system tables used by Access. You shouldn't use it directly until you're an advanced expert (and probably not even then).

SQL you can use by building queries using the design grid and then switching to SQL view to see the underlying SQL.

For Macros and SQL I would buy a good book on Access. If you search these forums you should find somme reccomendations.
 
Learning how to use access

Hi there, learning access is the same as learning any programming language.

I have taught students on a one to one basis with a few languages. The best way to learn is to just jump stright in. imagine a program you would like to build and just started working on it, every pitfall you come across just jump on the internet and find a solution - try not to copy paste solutions, try to understand them.

I myself am fairly new to access, i am working on a very large program at the moment. which is to roll out to 20 + users within 4 weeks.. so its a few late nights, i am having to ask alot of questions on forum sites and read though loads of tutorials but i am getting there :).

It really is the best way and gives you most satisfaction

Blu
 
My collegue at work gave me this web site to help me learn SQL and i found it really useful I too am new to access and have had no formal training i am just learning from my collegue so am finding it pretty mind blowing at the moment. The web page is: http://sqlcourse.com hope this is of some use!!

Helen
 
Hi there, learning access is the same as learning any programming language.

I have taught students on a one to one basis with a few languages. The best way to learn is to just jump stright in. imagine a program you would like to build and just started working on it, every pitfall you come across just jump on the internet and find a solution - try not to copy paste solutions, try to understand them.

I myself am fairly new to access, i am working on a very large program at the moment. which is to roll out to 20 + users within 4 weeks.. so its a few late nights, i am having to ask alot of questions on forum sites and read though loads of tutorials but i am getting there :).

It really is the best way and gives you most satisfaction

Blu

Very true, I think even if there is code you can copy and paste, type it out manually. Just so it sticks into your head, one time I copy and pasted some code and went back and thought "ohh.. what's this?" :D

Do jump right in though, try a few tutorials.

Eventually you'll need to start planning your databases and their relationships in advance but don't worry too much as an idea in your head may be good enough. I find that when I plan something I end up changing and expanding it. Access is a pretty flexible way of working.
 

Users who are viewing this thread

Back
Top Bottom