Geoff - Using MS Access - Business Software - Computing/Technology

About > AllExperts
	Search for

Main Menu

Login (Experts Only)

About Us · FAQ · Tell Friends About Us · Link To Us · Free Encyclopedia · Disclaimer · Tech Support

You are here: AllExperts > Computing/Technology > Business Software > Using MS Access

Expert Profile: Geoff

Expertise: I specialise in database analysis and design, SQL and database queries using QBE and VBA. In my work, I use MS Access together with MS SQL Server as ETL (Extraction - Transformation - Loading) tools for migrating data between business ERP systems and data stores. My forte is building bespoke functions and applications.

See my website for example apps and downloads

I am a chartered engineer with 30 years of engineering and business experience, member of the BCS and have been working specifically in database applications, including SQL Server (v7/8/2000) for the last 9 or so years. I previously taught a course in Database Analysis and Design, but am now a freelance consultant and systems analyst.

Commercial database design and development work undertaken.

	View Past Answers	View Detailed Ratings

What do you like about this subject? Designing and building business processes, databases and user applications is a cornerstone of my existence. They have such a powerful impact on people's lives, that success is sublimely rewarding.

What do you still hope to achieve/learn in this field? One is never to old to learn - this environment is a never ending arena of learning, no matter how long you've been around. Serving the Access Experts group feeds the quest to learn. . . . .

Something interesting about this subject that others may not know: Access is an excellent tool - it is very user friendly to learn - beginners in database work can achieve incredible productivity very quickly - it forms an excellent utility for developing Client applications in a Client Server environment - it is a great prototyping tool - it enables applications to grow in complexity with developer skill and experience.

Something controversial or provocative about this subject A knowledge based economy depends on data.

Average Ratings
Prestige Points: 15738
Knowledge	9.87 Best of the best
Clarity of Response	9.84 Best of the best
Timeliness	9.93 Best of the best
Politeness	9.97 Best of the best
Number Of Questions (in Past 24 Hours)		0
Max Questions to be Asked (in 24 Hour period)		2
Total Questions (since joining AllExperts)		3035

Recent Reviews from Users

Knowl	Clarity	Time	Politeness	Date
10	10	10	10	11/18/08
10	10	10	10	11/10/08
10	10	10	10	11/05/08
10	10	10	10	11/05/08
8	7	7	10	11/04/08

User Comments

Thank you for your help!
(Zsolt on 11/18/08)

Thanks, I think this will help.
(Sam on 11/10/08)

Thanks a lot for the quick response !!
(Cecile on 11/05/08)

Best regards to you Geoff I was aware of count(*) but it don't work with QBE The result wasn't what I expected but will work better for me. I thoug
(anson on 11/05/08)

Thank your reply me
(huot on 11/04/08)

View All Comments

	View Past Answers	View Detailed Ratings

Recent Answers from Geoff

2008-11-14 Lookup List Management: Hi Patrick, I have designed a similar DB for a cricket league in England, so I'll throw in my t'penny worth: The primary tables will be: tblDivision tblTeam tblEvent Additionally you...

2008-11-13 query: Zsolt hi, This is a "design" feature of Access ! No records = blank form. The only solution is to test for no records and control the display accordingly (like display a MsgBox saying no records, or...

2008-11-13 How can i fetch data relative to data filled in the current form: Hi Rohit In the [Name] text box Control Source property enter an expression based on the following - you will need to edit the table/field names to match... = DLookUp("[Name]","tblLookUpName"...

2008-11-12 Multiple Entries in an Access table field: Hi Aneeka, I would not advise this in a database application - of course if you want to manually type in delimited data in a text field that's fine. The correct solution is to have a separate 'child'...

2008-11-12 Obtaining next available Member ID: Hi Laurie Why don't you use the Autonumber data type for the MemberID - it was made for exactly this requirement ? To find this, open the table in design mode, select data type, select AutoNumber...