New member from Barnsley Uk!

Graham63

Registered User.
Local time
Today, 23:22
Joined
Mar 22, 2012
Messages
20
Fell into access 2007 a few weeks ago guys, after finding limitations with excel in a project database Im trying to develop. Since then I have read some dummies literature ,watched tutorials and generally gone backwards (mainly) and forwards trying to build code into related tables I have compiled with a small amount of success. I have so many ideas and so little experience I just had to try and get a "leg up" from your site and learn the language through those who speak it! The possibilities seem endless?

I am grateful in advance for replies and looking forward to posting.

Graham63
 
There is a ton you can do. Research normalization. When you build stuff, take an overly simplified approach until you feel comfortable. Focus on understanding tables, queries, forms, and reports. That's the easy part. Once you got that, read about modules, subs, and functions (just the basics). The code is what lets us do generally whatever we want, but it has a steep learning curve.

edit- I've got some time to kill, so I'll explain a little more.

Tables
Tables store the data. Understand that a table is not exactly like a spreadsheet in excel.

Normalization
There are online resources that explain this better than I ever could, but I'll try in a simplistic way. The idea is that alike data is stored in it's own table. So if a customer can have multiple phone numbers, then perhaps you would have tblCustomers, and tblCustomerPhoneNumbers. The customer table has an ID, and other fields relevant to customers, with NOTHING about phone numbers. The phone number table also has an ID, a foreign key, and the actual data. The foreign key provides the link to the customer's table.

Queries
This is how you ask questions about your data. Suppose you want a list of all customer phone numbers. In a query, you can use both the customer's table and the phone number's table to bring related sets of data together. These sets are related between the customer ID and the foreign key in the phone number's table. When you run the query, you can now see phone number's with corresponding customer name's.

Forms
These are the method of entering data.

Reports
This is how we print an analysis of our data.

Modules
These store code that can be used in any form.

Subs
A sub routine carries out a set of instructions.

Functions
A function can also carry out a set of instructions, but more importantly, it returns a value. You can ask what a function equals, and you should get something returned. If you asked what a sub equals, you'll get an error.
 
Last edited:
Big Thanks Speakers 86,
Most of your comments are bourne out in the stuff ive looked out so far, its nice to have that confirmation here. Normalization jumps out though and I will study that next! I am afraid ive bombarded myself recently and found out a little about an awful lot. Im gonna keep looking and learning and build around my 1st database.

Graham63
 
Hi Guys ... i have a question ... i have an error in Microsoft Access 2003 like this error.

Error-2147217913 (Data type mismatch in criteria expression.) in procedure cmdPreview_Click of VBA Document Form_Intro Form

please help me ...
 
What is this doing in this thread , please delete it and post in an appropriate forum
 

Users who are viewing this thread

Back
Top Bottom