Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » MS Access - Multiple forms vs single forms

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

MS Access - Multiple forms vs single forms

Resolved · Low Priority · Version 2003

Reply Tue 8 Jul 2008, 17:05Delegate Craig said...

Craig has attended:
Access Intermediate course

MS Access - Multiple forms vs single forms

Hi,

I'm in the process of setting up a database for my company showing all details relating to every product we sell (ie - product code, rrp, dimensions, etc) which means there are over 20 fields all relating to the same primary key (the product code). Is it worth dividing the information into categorys, making multiple tables and linking them or is it easier just to keep them all in one table?

Thanks

Craig:)

For upcoming training course dates see: Pricing & availability

Reply Thu 10 Jul 2008, 21:31Delegate Mark said...

RE: MS Access - Multiple forms vs single forms

Hi Craig,

Generally wherever a field looks like an obvious contender for being a category or limited choice of entry, then it is worth having a separate table for it. There are a number of benefits in doing that. Benefits include, keeping the database data compact, efficient, and therefore faster to call up information and avoids or reduces the future tasks to maintain workable table and file sizes. It is easier to get the information into separate tables now than to find yourself doing it to a loaded database say 20000 records later. You can get specific information out for specific purposes by including and excluding tables from queries before you start putting in parameters and reduces complexity of needed queries. Another advantage is that the categorised data which you may often filter on and sort by can be better controlled at input stage which ensures that filters and displays for information don

Reply Thu 24 Jul 2008, 11:42Trainer Rajeev said...

RE: MS Access - Multiple forms vs single forms

Dear Mark

Thank you again for your input.

Another excellent response!!

Many thanks

MOS Master Instructor 2000/2003
MCAS Master Instructor 2007

Access articles

· Microsoft Access Mistakes to Avoid
· Happy Table Relationships In Access 2007
· The Benefits of Certified Microsoft Training in Access
· Interested In The Golden Rules For Building Access Databases?
· Access: Things You Probably Already Know

Please browse our web site to find out more about
microsoft access training courses and other Microsoft training courses.

Access tip:

Calculating The Difference Between Dates

If you wish to calculate the time between two date fields, this can be done in a number of ways:

1. As a calculated field in a query
2. As a calculated control in a form or report
3. As a calculation in a VBA procedure.

The basic syntax to get the number of days between two dates is:

=[One Date Field] - [Another Date Field]

You can also use one of the following functions:

=Month([One Date Field] - [Another Date Field])
which calculates the number of months between the two fields

=Year([One Date Field] - [Another Date Field])
which calculates the number of years between the two fields.

Another function is the DateDiff() function.

It uses an argument to determine how the time interval is measured. For example:

=DateDiff("q",[One Date Field] - [Another Date Field])
returns the number of quarters between the two fields.

Other intervals that can be used in this expression are as follows:
"yyyy" - Years
"m" - Months
"d" - Days
"w" - Weekdays
"ww" - Weeks
"h" - Hours
"n" - Minutes
"s" - Seconds

View all Access hints and tips