I want to create an access data base

K

Kernow1962

I want to do the following: Imput data that will go to specific tables. I
want to have a single page that telles the user where to enter the data. I
think i want the data to go to excel format from which some data will then go
to other spreadsheets.

I need to enter dates, times ID's numbers and monetarty values.
It is for importing containers that can go to various end destinations and i
also need to enter costings.

I want the user to have a single page to enter ALL information regarding
each single container, so i assume i will need a ADD new data button and i
will want the information to automatically go to tothe right place. EG: I
imagine a tick box for each destination so if the user ticks bo a the data
will automatically know that that conatiner goes to Destination a and all
relevant data goes to the spreadsheets accordingly!
Hope i have made some sense. Is access the right product for this and if so
where can i find a printable idiots guide to doing what i want to do

hope someone understands and can help

Many thanks

Kernow1962
 
J

jahoobob via AccessMonster.com

You probably won't get much of a reponse here for your request. My advice is
to either learn Access by taking a class, finding on-line tutorials, or
buying a book on Access (that's how I learned) or to hire someone to do this.
Once you get started and have specific questions ask them here.
Also, the Northwinds sample database provided with Access can be a help.
I will give you one bit of advice in designing your database -forget Excel
and Excel format. Figuratively, Excel is flat and Access is three
dimensional. Decide what information you want out of your database (list the
data) and then determine what data needs to be entered. For instance if you
want Total Cost and Total Cost is the sum of Loading Charge, Storage Charge,
and Stevedore Charge then three of your entries would be the latter three to
get the output. If you want to determine demurrage, you would need to enter
a beginning time and an ending time and then compare that time to the
accepted detention time.
 
J

Jeff Boyce

It sounds like you want to be working in spreadsheets and using
spreadsheetly data. Is there a reason you need to learn relational database
design? Do you have the time to learn both relational database design and
some of the tools/tricks of using MS Access?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
R

roccogrand

I would say that Access is a better solution for you than Excel. Using
Excel, users would be required to enter the data onto different worksheets.
That would be a nightmare for some users.

With Access' forms functionality, you could place all the needed fields on
the same form and users would fill in only the information they have
available to them. If there are many fields, maximize real estate with tabs.


If you are uncertain as which of these programs to use and you are new to
Access, consider starting to learn Access with Access 2007, which is more
Excel-like than previous versions. Also with Access, any data that your
users enter can be easily exported if need be to Excel, Word, Outlook,
Project, MapPoint, GIS, CADD, etc.

Again my personal choice would be Access 2007, although your scenario is
well within the capabilities of Access 2003, 2002, and 2000. Unless you need
to do high-powered calculations and tie them to complex charts, there isn't
much need for you to use a spreadsheet, IMHO.

LDN
 
J

Jeff Boyce

There are some folks here who would view having "Access" be "more
Excel-like" to be a severe disadvantage. If you really want to get the best
use of Access features and functions, your data needs to be relational, not
spreadsheetly...

Just One Person's Opinion...

Jeff Boyce
Microsoft Office/Access MVP
 
R

roccogrand

I totally agree.

With Access 2007, I think the folks in Redmond are moving towards
spreadsheetly, it's not me. IMHO, by implementing this solution in Access
would make it more ready for 2007. However, I have also attended
presentations about one table databases, so what is that other than a
spreadsheet? I would say that it is the functionality behind the data that
makes it a good database application.

Moreover, I personally hate scrolling to the right more than one page. You
cannot wrap data in Excel like you can in Access. Again, the functionality
needed for this application can be better implemented in Access.

LDN
 
T

Tim Ferguson

However, I have also attended
presentations about one table databases, so what is that other than a
spreadsheet?

Well; you can use Winword to write a shopping list, but that doesn't mean
it's word processing.

Tim F
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top