Fiesta Fan Forums

Fiesta Fan Forums (http://www.fiestafan.com/forums/index.php)
-   M O S (http://www.fiestafan.com/forums/forumdisplay.php?f=25)
-   -   Microsoft Access (http://www.fiestafan.com/forums/showthread.php?t=24473)

Hessah 11-05-2009 11:46 PM

Microsoft Access
 
Anyone know much about Microsoft Access?

I haven't used it for so long, I've forgotten what it can do...

Can it do simple calculations? (like a formula which is referenced to another field?)

Ralath 11-06-2009 02:20 AM

Isn't Access just for database and queries (that break your computer)?


Can't you just use Excel for formulas and calculations?


I'm sure that Access could probably use formula too (I don't have a lot of experience with it so I can't help you). But I guess it depends on the formula.

Hessah 11-06-2009 03:21 AM

We've got this database that's in excel at work, and the amount of data we're trying to put onto an Excel is going beyond the capability of Excel... (finding lotsa errors coz we're like copying and pasting and stuff)

I'm making an attempt to move it all into Access (which my boss hates, but if I can do it properly I might be able to convince her)

Most of it is just.. data.. except for 1 column where the number is based on another number... so i wonder how i can.. get that happening...

Ralath 11-06-2009 03:33 AM

Well, for Excel, it'd be paste special...?

Hessah 11-06-2009 03:59 AM

hmmm

So I'll hv to do the calculation in Excel then paste it into Access..

That's a dangerous step.. will have to check on that..

Sparkeh 11-06-2009 09:48 AM

I think we took few lessons at access...Hmmm all i know is to start a schedule. Lmao. c:

Patches 11-06-2009 10:44 AM

Are you using excel 2003?

Hessah 11-06-2009 08:10 PM

We've got 2007 at work


All times are GMT. The time now is 06:42 PM.

Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.