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 » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Tables & Formulas



 
 
Thread Tools Display Modes
  #1  
Old April 24th, 2004, 02:49 AM
Averil Pretty
external usenet poster
 
Posts: n/a
Default Tables & Formulas

Hello,

My company tests candidates and / or existing staff
members for our clients. Currently for each person there
is an Excel document created from a template that we work
off. The Excel template contains loads of very complex
formulas the result of which is displayed graphically for
the client.

I want to create a database to give to the client where
they can see the graphical information for any given staff
member and / or candidate at the click of a button.

My problem is that I don't know how the formulas in Excel
can work in Access as I'm fairly new to it. What I CAN
quite easily do is use a macro in Excel to extract the
final data needed for the graphs and then import this info
into a table in Access. This would work fine for the time
being but for future clients and our own use I think it
would be best if the database can calculate the data each
time as it is needed instead of storing it.

The only data really needing to be stored is the candidate
info and the raw scores, as from the raw scores we can
generate scores for traits, behaviours, competencies etc.

My self taught experience so far with Access is that it's
the best thing since sliced bread especially if you know
what you are doing  which, when it comes to code, I
don't .

Any input would be greatly appreciated - even if someone
can steer me in the right direction by recommending a book
or web site where I can fumble around and learn these
things myself.

Thanks in advance.

Regards,
Averil

  #2  
Old April 24th, 2004, 11:11 AM
Douglas J. Steele
external usenet poster
 
Posts: n/a
Default Tables & Formulas

You can't store formulas in tables. It's as simple as that.

What you can do is create a query that includes the formulas as computed
fields, and use the query wherever you would otherwise have used the table.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(No private e-mails, please)



"Averil Pretty" wrote in message
...
Hello,

My company tests candidates and / or existing staff
members for our clients. Currently for each person there
is an Excel document created from a template that we work
off. The Excel template contains loads of very complex
formulas the result of which is displayed graphically for
the client.

I want to create a database to give to the client where
they can see the graphical information for any given staff
member and / or candidate at the click of a button.

My problem is that I don't know how the formulas in Excel
can work in Access as I'm fairly new to it. What I CAN
quite easily do is use a macro in Excel to extract the
final data needed for the graphs and then import this info
into a table in Access. This would work fine for the time
being but for future clients and our own use I think it
would be best if the database can calculate the data each
time as it is needed instead of storing it.

The only data really needing to be stored is the candidate
info and the raw scores, as from the raw scores we can
generate scores for traits, behaviours, competencies etc.

My self taught experience so far with Access is that it's
the best thing since sliced bread especially if you know
what you are doing  which, when it comes to code, I
don't .

Any input would be greatly appreciated - even if someone
can steer me in the right direction by recommending a book
or web site where I can fumble around and learn these
things myself.

Thanks in advance.

Regards,
Averil



  #3  
Old April 26th, 2004, 08:15 PM
dandgard
external usenet poster
 
Posts: n/a
Default Tables & Formulas


The other thing you could do is open the Excel file from Access and read
in the information off the spreadsheets. That's fairly easy to do.


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

  #4  
Old April 26th, 2004, 08:15 PM
dandgard
external usenet poster
 
Posts: n/a
Default Tables & Formulas


The other thing you could do is open the Excel file from Access and read
in the information off the spreadsheets. That's fairly easy to do.


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

  #5  
Old April 26th, 2004, 08:15 PM
dandgard
external usenet poster
 
Posts: n/a
Default Tables & Formulas


The other thing you could do is open the Excel file from Access and read
in the information off the spreadsheets. That's fairly easy to do.


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

  #6  
Old April 26th, 2004, 08:15 PM
dandgard
external usenet poster
 
Posts: n/a
Default Tables & Formulas


The other thing you could do is open the Excel file from Access and read
in the information off the spreadsheets. That's fairly easy to do.


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

  #7  
Old April 26th, 2004, 08:15 PM
dandgard
external usenet poster
 
Posts: n/a
Default Tables & Formulas


The other thing you could do is open the Excel file from Access and read
in the information off the spreadsheets. That's fairly easy to do.


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

 




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 02:57 PM.


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