A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Is it worth it for me to learn Access?



 
 
Thread Tools Display Modes
  #1  
Old May 25th, 2010, 06:58 PM posted to microsoft.public.access.gettingstarted
Matt S
external usenet poster
 
Posts: 39
Default Is it worth it for me to learn Access?

Hello everyone,

I've been wondering this question for a few weeks now. My situation is that
I generate many "runlogs" from my reactor that have various outputs, such as
temperatures, sensor data, etc. versus time. Very frequently, I want to
compare one runlog to another. Sometimes I want to average the output of
several runlogs together. I currently have a macro made up in Excel that
analyzes the files, but it really is getting harder to manage all the excel
files floating around.

So is it worth dumping all the excel output from my macro into a database
and comparing them that way?

Thanks,
Matt
  #2  
Old May 25th, 2010, 08:05 PM posted to microsoft.public.access.gettingstarted
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default Is it worth it for me to learn Access?

Matt

Like an economist, which answer do you want?...(sorry, inside joke, no
unnecessary disrespect intended to economists)

MS Access is a relational database. If you want to get the best use of it,
you need to feed it well-normalized relational data.

If you've been using Excel, I'm sorry, but you may have to UN-learn some
things before you can get Access to work well.

And then there are the things you need to learn. In fact, I generally point
out at least four separate learning curves you'll want to consider:

1. relational database design -- it all starts with the data
2. Access tricks & tips -- I've been at it for over 15 years, and I'm
still learning...
3. Graphical User Interface -- if it isn't easy to use and understand,
it won't get used
4. Application development -- if you've never built a house, where do
you start?!

Sorry if that's a bit too generic, but you'll find that these newsgroups,
for as long as they continue (soon to be discontinued by Microsoft), work
best if you seek specific answers to specific questions.

Best of luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"Matt S" wrote in message
...
Hello everyone,

I've been wondering this question for a few weeks now. My situation is
that
I generate many "runlogs" from my reactor that have various outputs, such
as
temperatures, sensor data, etc. versus time. Very frequently, I want to
compare one runlog to another. Sometimes I want to average the output of
several runlogs together. I currently have a macro made up in Excel that
analyzes the files, but it really is getting harder to manage all the
excel
files floating around.

So is it worth dumping all the excel output from my macro into a database
and comparing them that way?

Thanks,
Matt



  #3  
Old May 25th, 2010, 08:40 PM posted to microsoft.public.access.gettingstarted
Steve[_77_]
external usenet poster
 
Posts: 1,017
Default Is it worth it for me to learn Access?

Hi Matt,

Excel is good when you have a small number of scenarios to analyze. A
database is approproate when the number of scenarios is large. Obviously,
the number of scenarios is beyond what Excel can analyze efficiently for
you. So, Access is the appropriate tool for you. I provide help with Access,
Excel and Word applications for a small fee. Let me put together a database
for you that you can use to analyze your reactor data. I would import your
existing Excel data into the new database. My fee would be very reasonable.
The advantage to you would be you would get to see how an Access application
is put together, you would get a more efficient system for analyzing your
reactor data and at that point if you wanted to add more functionality you
could learn Access and add the new functionality yourself.

By the way, I was previously an engineer in a large refinery so am familiar
with reactor data.

Steve



"Matt S" wrote in message
...
Hello everyone,

I've been wondering this question for a few weeks now. My situation is
that
I generate many "runlogs" from my reactor that have various outputs, such
as
temperatures, sensor data, etc. versus time. Very frequently, I want to
compare one runlog to another. Sometimes I want to average the output of
several runlogs together. I currently have a macro made up in Excel that
analyzes the files, but it really is getting harder to manage all the
excel
files floating around.

So is it worth dumping all the excel output from my macro into a database
and comparing them that way?

Thanks,
Matt



  #4  
Old May 25th, 2010, 09:03 PM posted to microsoft.public.access.gettingstarted
Matt S
external usenet poster
 
Posts: 39
Default Is it worth it for me to learn Access?

they're getting rid of these forums?! That's ridiculous... there's so much
I've learned from here! This is pretty much my go-to location for any VBA
coding!

Thanks for the reply, by the way.

Matt


"Jeff Boyce" wrote:

Matt

Like an economist, which answer do you want?...(sorry, inside joke, no
unnecessary disrespect intended to economists)

MS Access is a relational database. If you want to get the best use of it,
you need to feed it well-normalized relational data.

If you've been using Excel, I'm sorry, but you may have to UN-learn some
things before you can get Access to work well.

And then there are the things you need to learn. In fact, I generally point
out at least four separate learning curves you'll want to consider:

1. relational database design -- it all starts with the data
2. Access tricks & tips -- I've been at it for over 15 years, and I'm
still learning...
3. Graphical User Interface -- if it isn't easy to use and understand,
it won't get used
4. Application development -- if you've never built a house, where do
you start?!

Sorry if that's a bit too generic, but you'll find that these newsgroups,
for as long as they continue (soon to be discontinued by Microsoft), work
best if you seek specific answers to specific questions.

Best of luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"Matt S" wrote in message
...
Hello everyone,

I've been wondering this question for a few weeks now. My situation is
that
I generate many "runlogs" from my reactor that have various outputs, such
as
temperatures, sensor data, etc. versus time. Very frequently, I want to
compare one runlog to another. Sometimes I want to average the output of
several runlogs together. I currently have a macro made up in Excel that
analyzes the files, but it really is getting harder to manage all the
excel
files floating around.

So is it worth dumping all the excel output from my macro into a database
and comparing them that way?

Thanks,
Matt



.

  #5  
Old May 25th, 2010, 11:30 PM posted to microsoft.public.access.gettingstarted
Stop$teve
external usenet poster
 
Posts: 76
Default Is it worth it for me to learn Access?

By the way, you are advertising again... you are very familiar with that also!!


--
Get lost $teve. Go away... far away....

Again... Get lost $teve. Go away... far away....
No-one wants you here... no-one needs you here...

This newsgroup is meant for FREE help..
No-one wants you here... no-one needs you here...
OP look at http://home.tiscali.nl/arracom/whoissteve.html
(Website has been updated and has a new 'look'... we have passed 12.000 pageloads... it's a shame !!)

Arno R



"Steve" schreef in bericht ...
Hi Matt,

Excel is good when you have a small number of scenarios to analyze. A database is approproate when the number of scenarios is
large. Obviously, the number of scenarios is beyond what Excel can analyze efficiently for you. So, Access is the appropriate tool
for you. I provide help with Access, Excel and Word applications for a small fee. Let me put together a database for you that you
can use to analyze your reactor data. I would import your existing Excel data into the new database. My fee would be very
reasonable. The advantage to you would be you would get to see how an Access application is put together, you would get a more
efficient system for analyzing your reactor data and at that point if you wanted to add more functionality you could learn Access
and add the new functionality yourself.

By the way, I was previously an engineer in a large refinery so am familiar with reactor data.

Steve



"Matt S" wrote in message ...
Hello everyone,

I've been wondering this question for a few weeks now. My situation is that
I generate many "runlogs" from my reactor that have various outputs, such as
temperatures, sensor data, etc. versus time. Very frequently, I want to
compare one runlog to another. Sometimes I want to average the output of
several runlogs together. I currently have a macro made up in Excel that
analyzes the files, but it really is getting harder to manage all the excel
files floating around.

So is it worth dumping all the excel output from my macro into a database
and comparing them that way?

Thanks,
Matt





  #6  
Old May 25th, 2010, 11:54 PM posted to microsoft.public.access.gettingstarted
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default Is it worth it for me to learn Access?

Before you avail yourself of any services offered "for a fee", you need to
be aware that the Code of Conduct for these newsgroups prohibits advertising
"for fee" services. Do you really want to do business with someone who
disregards the rules?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.


"Matt S" wrote in message
...
they're getting rid of these forums?! That's ridiculous... there's so
much
I've learned from here! This is pretty much my go-to location for any VBA
coding!

Thanks for the reply, by the way.

Matt


"Jeff Boyce" wrote:

Matt

Like an economist, which answer do you want?...(sorry, inside joke, no
unnecessary disrespect intended to economists)

MS Access is a relational database. If you want to get the best use of
it,
you need to feed it well-normalized relational data.

If you've been using Excel, I'm sorry, but you may have to UN-learn some
things before you can get Access to work well.

And then there are the things you need to learn. In fact, I generally
point
out at least four separate learning curves you'll want to consider:

1. relational database design -- it all starts with the data
2. Access tricks & tips -- I've been at it for over 15 years, and
I'm
still learning...
3. Graphical User Interface -- if it isn't easy to use and
understand,
it won't get used
4. Application development -- if you've never built a house, where
do
you start?!

Sorry if that's a bit too generic, but you'll find that these newsgroups,
for as long as they continue (soon to be discontinued by Microsoft), work
best if you seek specific answers to specific questions.

Best of luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"Matt S" wrote in message
...
Hello everyone,

I've been wondering this question for a few weeks now. My situation is
that
I generate many "runlogs" from my reactor that have various outputs,
such
as
temperatures, sensor data, etc. versus time. Very frequently, I want
to
compare one runlog to another. Sometimes I want to average the output
of
several runlogs together. I currently have a macro made up in Excel
that
analyzes the files, but it really is getting harder to manage all the
excel
files floating around.

So is it worth dumping all the excel output from my macro into a
database
and comparing them that way?

Thanks,
Matt



.



  #7  
Old May 26th, 2010, 02:15 AM posted to microsoft.public.access.gettingstarted
Steve[_77_]
external usenet poster
 
Posts: 1,017
Default Is it worth it for me to learn Access?

Code of Conduct for these newsgroups does not prohibit advertising "for fee"
services. Just as his email says; that's nonsense. That's a lie that this
guy continuously propagates. The Code of Conduct for these newsgroups does
prohibit lieing. Do you really want to trust anything an MVP who lies?

Regards,

Steve
BSChe, MBA, CAP



"Jeff Boyce" wrote in message
...
Before you avail yourself of any services offered "for a fee", you need to
be aware that the Code of Conduct for these newsgroups prohibits
advertising "for fee" services. Do you really want to do business with
someone who disregards the rules?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.


"Matt S" wrote in message
...
they're getting rid of these forums?! That's ridiculous... there's so
much
I've learned from here! This is pretty much my go-to location for any
VBA
coding!

Thanks for the reply, by the way.

Matt


"Jeff Boyce" wrote:

Matt

Like an economist, which answer do you want?...(sorry, inside joke, no
unnecessary disrespect intended to economists)

MS Access is a relational database. If you want to get the best use of
it,
you need to feed it well-normalized relational data.

If you've been using Excel, I'm sorry, but you may have to UN-learn some
things before you can get Access to work well.

And then there are the things you need to learn. In fact, I generally
point
out at least four separate learning curves you'll want to consider:

1. relational database design -- it all starts with the data
2. Access tricks & tips -- I've been at it for over 15 years, and
I'm
still learning...
3. Graphical User Interface -- if it isn't easy to use and
understand,
it won't get used
4. Application development -- if you've never built a house, where
do
you start?!

Sorry if that's a bit too generic, but you'll find that these
newsgroups,
for as long as they continue (soon to be discontinued by Microsoft),
work
best if you seek specific answers to specific questions.

Best of luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services
mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"Matt S" wrote in message
...
Hello everyone,

I've been wondering this question for a few weeks now. My situation
is
that
I generate many "runlogs" from my reactor that have various outputs,
such
as
temperatures, sensor data, etc. versus time. Very frequently, I want
to
compare one runlog to another. Sometimes I want to average the output
of
several runlogs together. I currently have a macro made up in Excel
that
analyzes the files, but it really is getting harder to manage all the
excel
files floating around.

So is it worth dumping all the excel output from my macro into a
database
and comparing them that way?

Thanks,
Matt


.





  #8  
Old May 26th, 2010, 03:16 AM posted to microsoft.public.access.gettingstarted
John... Visio MVP
external usenet poster
 
Posts: 900
Default Is it worth it for me to learn Access?

Reactor data from a refinery?. Stevie, do you really know what you are
talking about?

John... Visio MVP
"Steve" wrote in message
...
Hi Matt,

By the way, I was previously an engineer in a large refinery so am
familiar with reactor data.

Steve



  #9  
Old May 26th, 2010, 03:17 PM posted to microsoft.public.access.gettingstarted
BruceM via AccessMonster.com
external usenet poster
 
Posts: 448
Default Is it worth it for me to learn Access?

You will be shot down every time you try to sell your services here. Lashing
out at justifiable reprimands only makes you look small and desperate.

Steve wrote:
Code of Conduct for these newsgroups does not prohibit advertising "for fee"
services. Just as his email says; that's nonsense. That's a lie that this
guy continuously propagates. The Code of Conduct for these newsgroups does
prohibit lieing. Do you really want to trust anything an MVP who lies?

Regards,

Steve
BSChe, MBA, CAP

Before you avail yourself of any services offered "for a fee", you need to
be aware that the Code of Conduct for these newsgroups prohibits

[quoted text clipped - 82 lines]

.


--
Message posted via http://www.accessmonster.com

  #10  
Old May 26th, 2010, 03:54 PM posted to microsoft.public.access.gettingstarted
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default Is it worth it for me to learn Access?

Steve

You're right. The Rules of Conduct (see below) do not prohibit advertising,
they merely ask that you refrain from it. I can see how you could interpret
the second sentence of the third topic to allow you to post your offers,
provided you mention something about the "intended use and purpose of the
newsgroup". However, if you read the first sentence of that section, it
clearly states that the purpose is to provide peer-to-peer assistance. That
would seem to obviate asking for payment for your assistance.


snip
Rules of Conduct

Appropriate Language: The purpose of our communities is to exchange
technical information and expertise about Microsoft products. Please avoid
personal attacks, slurs, and profanity in your interactions.

Relevance to Topics: Please make sure that your postings in newsgroups and
chats are relevant to the subject at hand. It is normal for some topics to
drift from the stated subject. However, to ensure maximum benefit for
everyone, we encourage you to keep your postings as close to the subject as
possible.

Advertising/Solicitation: These communities were created as a forum for
providing peer-to-peer assistance related to using Microsoft products and
services. We ask that you refrain from posting unsolicited advertisements
that do not pertain directly to the intended use and purpose of the
newsgroup or chat.

Confidentiality: Please keep in mind that our communities are public spaces,
so don't post anything that you don't want the world to see. Credit card
numbers, product keys, and other confidential information, including
anything covered under a non-disclosure agreement (NDA), should not be
posted to a newsgroup, chat, or other community.

snip

Regards

Jeff Boyce



"Steve" wrote in message
...
Code of Conduct for these newsgroups does not prohibit advertising "for
fee" services. Just as his email says; that's nonsense. That's a lie that
this guy continuously propagates. The Code of Conduct for these newsgroups
does prohibit lieing. Do you really want to trust anything an MVP who
lies?

Regards,

Steve
BSChe, MBA, CAP



"Jeff Boyce" wrote in message
...
Before you avail yourself of any services offered "for a fee", you need
to be aware that the Code of Conduct for these newsgroups prohibits
advertising "for fee" services. Do you really want to do business with
someone who disregards the rules?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.


"Matt S" wrote in message
...
they're getting rid of these forums?! That's ridiculous... there's so
much
I've learned from here! This is pretty much my go-to location for any
VBA
coding!

Thanks for the reply, by the way.

Matt


"Jeff Boyce" wrote:

Matt

Like an economist, which answer do you want?...(sorry, inside joke, no
unnecessary disrespect intended to economists)

MS Access is a relational database. If you want to get the best use of
it,
you need to feed it well-normalized relational data.

If you've been using Excel, I'm sorry, but you may have to UN-learn
some
things before you can get Access to work well.

And then there are the things you need to learn. In fact, I generally
point
out at least four separate learning curves you'll want to consider:

1. relational database design -- it all starts with the data
2. Access tricks & tips -- I've been at it for over 15 years, and
I'm
still learning...
3. Graphical User Interface -- if it isn't easy to use and
understand,
it won't get used
4. Application development -- if you've never built a house, where
do
you start?!

Sorry if that's a bit too generic, but you'll find that these
newsgroups,
for as long as they continue (soon to be discontinued by Microsoft),
work
best if you seek specific answers to specific questions.

Best of luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services
mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with
no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"Matt S" wrote in message
...
Hello everyone,

I've been wondering this question for a few weeks now. My situation
is
that
I generate many "runlogs" from my reactor that have various outputs,
such
as
temperatures, sensor data, etc. versus time. Very frequently, I want
to
compare one runlog to another. Sometimes I want to average the
output of
several runlogs together. I currently have a macro made up in Excel
that
analyzes the files, but it really is getting harder to manage all the
excel
files floating around.

So is it worth dumping all the excel output from my macro into a
database
and comparing them that way?

Thanks,
Matt


.







 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:26 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.