Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 25th, 2008, 09:44 AM
Registered User
 
Join Date: Jun 2008
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Don't know where to start(Need Major help)

Hey guys,

I'm new here and actually new to access 2003. I have deal with Vb.net but never access. I actually doing a intern and they want me to build a huge database. All there documents are spread out and all over the place as format of excel. I could just convert them into a access database, but they want all the excel in one huge or whole database. Since the database contain information about people they want to pull up certain person and see what his information is. My question is I believe that can be done, the problem is I'm new and I don't know where to start. I thought of just coding it, but there converting the access database so there no point of coding it. So a lot of explaining to me and a lot of help would be awesome.

Thanks a bunch,
Jett

 
Old June 25th, 2008, 09:56 AM
Authorized User
 
Join Date: May 2007
Posts: 85
Thanks: 0
Thanked 0 Times in 0 Posts
Default

i'd grab a copy of "access 2003 step by step" first off to familiarise yourself with access. its the easiest book to learn how to play with access from. You should be able to get a good basic handle in a weekend from it.

Whilst I love the wrox series for most things, they are at the level of knowledge above this book and you'll get more out of them, once you've done that. Get a grip on what access can and can't do before you start playing with the design.

What you're outlining, in principle, is do-able without too much aggravation. However without a better understanding of what the system is aimed at and the structure its going to be hard to address the issues properly.

 
Old June 25th, 2008, 02:02 PM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Without posting live data, of course, what do the spreadsheets look like?

First answer: what are the reports they want to get out of the database, and what is the data they will be inputting regularly?



mmcdonal

Look it up at: http://wrox.books24x7.com
 
Old June 27th, 2008, 06:57 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG
Default

Welcome to P2P, Jett.

I break up Access into three parts whenever someone at work asks me: 1) structure, 2) cosmetic, 3) functional.

Structural has to do with how to make proper data tables and follow the rules for normalization, naming conventions, setting data types, what to store vs. what NOT to store (e.g. calculated values), creating form/subform combinations, creating report/subreport combinations.

Cosmetic has do with how the forms and report will look and how to make them visually pleasing, how to abide by the Americans with Disabilities Act (ADA), conventions on 800x600 vs. finer screen resolutions (see ADA), etc.

Functional has to do with constructing queries properly so they do what you want; and the big one is how to do Visual Basic for Applications (VBA) programming behind the forms and report that actually DO something when you click or button or change a value somewhere.

Years ago, our office tended to have training classes on the first two, but it wasn't until a few of begged did they get the vendor to set up a two-day extensive VBA class. A form/report is useless unless it DOES something.

You need to get a good handle on all these concepts before you make anything meaningful and that functions properly.

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division





Similar Threads
Thread Thread Starter Forum Replies Last Post
DoCmd.Quit -Major screw up-Please help! stealthdevil Access VBA 1 September 5th, 2007 11:18 AM
I am a beginner, and i need major help!!! ironchef Java Basics 6 July 28th, 2006 03:45 AM
Need Major Help!!!!!!!!!!!!!!!! Phrozen1der JSP Basics 0 May 10th, 2004 04:53 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.