Quick Links ▼

Bookmark page

Printable version

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

Forum home » Delegate support and help forum » Microsoft Access Training and help » Information

	98.1 % recommend us
	More live stats...

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

Training information:

Information

Resolved · Low Priority · Version 2003

Reply Thu 17 Jul 2008, 16:52Delegate Amie said...

Amie has attended:
Access Introduction course
Access Intermediate course
Access Advanced course

Information

Can you have 2 bits of the same information repeated throughout the tables?

For upcoming training course dates see: Pricing & availability

Reply Thu 24 Jul 2008, 14:48Trainer Rajeev said...

RE: Information -

Dear Amy

Thank you for attending Access Introduction course. I hope you enjoyed the course and are finding the topics covered during the training useful.

I am not very clear about the question . Can I please request you to provide me an example so I can answer your query more effectively.

I would like to mention two things and may be that may answer your query.

You can use the shortcut key CTRL+

Reply Thu 24 Jul 2008, 15:48Delegate Amie said...

RE: Information -

Hello again! Thankyou for that however the example is If you have 1 table with say name, address,tel number, company if it is repeated anywhere else in another table it should be assigned a number or foreign key??rather than having the same info repeated elsewhere?
Hope this makes sense

Thanks Amie

Reply Thu 24 Jul 2008, 16:22Delegate Amie said...

RE: Information -

Hi also have another query(lol)
this is what comes up when try and open the database I have createdd

!Warning...Unsafe expressions are not blocked..
If I say yes open anyway it wont let me open the database...
Answers on a postcard please

Kind Regards

Amie

Access articles

· Sub-reports And Sub-forms In Access 2007
· How To Use Tabs To Show Lots Of Related Data On One Form In Access
· The Easy Way To Get Started With Access
· Different Ways To Use Forms In Access 2007
· Microsoft Access Mistakes to Avoid

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

Access tip:

Run with the total

Often when creating reports with lists of transactions it can be useful to have a column which totals the transactions as the report progresses.

Using the Sum function gives the total for the whole group, not a running total.

Access provides an easy method of achieving a running total.

Click on the text box containing the data you wish to contain the running total.
Select the Data tab
Click in the Running sum option
Click the down arrow to view three options

View all Access hints and tips