I want to create an access data base

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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
 
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
 
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
 
However, I have also attended
presentations about one table databases, so what is that other than a
spreadsheet?
Click to expand...

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

Tim F
 
Back
Top