Create advanced form design

Resolved · High Priority · Version 2003

Kirsten has attended:
Access Intermediate course

by - delegate Kirsten [1 post] (2008 Aug 15 Fri, 16:53) Reply

I have a table within a form specifying talk titles for speakers on one of our conferences. Each time I query the data, the professor/speaker comes up as many times as his talk title and I would like to use word/excel to merge this data into one report for each Professor, detailing talk titles, times etc. I think I have learned today how to avoid this, but please can I be assured on how?

Version	Date	Location	Places available	Book	Next place rate:
Access Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Nov 26 Wed	Bloomsbury	3	book now	£224	£235
2007	2008 Nov 28 Fri	Bloomsbury	3	book now	£240	£245
2003	2008 Dec 3 Wed	Southwark	7	book now	£203	£230
2003	2008 Dec 19 Fri	Bloomsbury	6	book now	£214	£230
2003	2008 Dec 24 Wed	Bayswater	0	FULL
2003	2009 Jan 7 Wed	Southwark	7	book now	£203	£230
Full Schedule: See all 47 Access Advanced course dates. Bookings currently available until 25th November 2009.

RE: Create advanced form design

by - trainer Rajeev gold contributer [462 posts] (2008 Aug 18 Mon, 10:25) Reply

Dear Kirsten

Thank you attending the Access Intermediate course. I hope you enjoyed the course and benefited from it.

As mentioned after the training it would be better to split your tables using the normalization rules that you learnt. Once the tables have been split properly then you can extract any records or any fileds from any table!!

If you need a reminder of the normalization rules please let me know by replying to this post and I should be able to provide you brief explanation!!

If this post has helped in answering your query then please mark it as resolved!!

Many thanks

Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000/2003
MCAS Master Instructor 2007

· The Benefits of Certified Microsoft Training in Access
· Microsoft Access Tighten your Security Controls
· When Is Microsoft Access Not The Best Choice For Your Business?
· Microsoft Access Beginners' Training: Getting to Grips with Databases
· Learn about Subqueries in Access Courses

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

Access tip:

How To Find All Overdue Accounts?

To find overdue accounts create a filter that compares today's date with the Invoice Date in the table. To do this:

1. Open the Query in Design View
2. Select the field for the filter and in the criteria row enter:

<Date()

This filter returns records where the Invoice Date is before today's date.

This filter can be manipulated if, for instance, Invoices are due 15 days after the Invoice Date. For this the filter would be:

<Date()-15

This filter returns records where the Invoice Date is 15 days before today's date.

View all Access hints and tips