Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old June 25th, 2008, 09:44 AM
Registered User
 
Join Date: Jun 2008
Location: , , .
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

Reply With Quote
  #2 (permalink)  
Old June 25th, 2008, 09:56 AM
Authorized User
 
Join Date: May 2007
Location: , , .
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.

Reply With Quote
  #3 (permalink)  
Old June 25th, 2008, 02:02 PM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
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
Reply With Quote
  #4 (permalink)  
Old June 27th, 2008, 06:57 AM
Friend of Wrox
Points: 4,007, Level: 26
Points: 4,007, Level: 26 Points: 4,007, Level: 26 Points: 4,007, Level: 26
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Lansing, Michigan, USA.
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
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
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

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


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



All times are GMT -4. The time now is 05:59 PM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.