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.
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.