information
Request a callback

We'll call during UK business hours

Name:
Number:
0207 987 3777

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

Information

resolvedResolved · Low Priority · Version 2003

Thu 17 Jul 2008, 16:52 replyReply Delegate 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

Thu 24 Jul 2008, 14:48 replyReply Trainer 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+

Thu 24 Jul 2008, 15:48 replyReply Delegate 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

Thu 24 Jul 2008, 16:22 replyReply Delegate 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

 

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



MS Project training
Course rating:
4.8 stars - based on 5149 reviews
Microsoft Certified Partner Institute of Leadership and Management - Certified Courses Learning and Performance Institute - Accredited Training Provider Security Seal verified by visa, mastercard securecard

Connect with us: Facebook · Twitter · Google+ · LinkedIn · Pinterest