Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

information

ResolvedVersion 2003

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?

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+

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

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 tip:

Compact database automoatically

To ensure optimal performance, you should compact and repair your

Open the Access database or Access project that you want Access to compact automatically.
On the Tools menu, click Options.
Click the General tab.
Select the Compact on Close check box.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.