linking database
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Linking Database

Linking Database

resolvedResolved · Low Priority · Version 2007

replyReply Mon 23 Jun 2008, 16:16Delegate Nancy said...

Nancy has attended:
Access Introduction course
Access Intermediate course

Linking Database

What is the benefit of linking database rather than importing?

For upcoming training course dates see: Pricing & availability

replyReply Fri 27 Jun 2008, 11:12Trainer Carlos said...

RE: Linking Database

Hi Nancy

If you import a data table into your database there are a few drawbacks:

1: Data duplication. There is an extra set of records taking up disk space

2: If any changes are made on the tables they cannot be seen by the other party

So in linking tables space is saved and most importantly any changes in the table are automatically seen by those linked to the table

Hope this helps

Carlos

 

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

Access tip:

Convert A Form Into A Report

If there is a form that you want to to save as a report:

1. Open that form in Design View
2. Select File and Save As
3. In the Save As Dialog box Select Report

The system creates a report based on the form.

View all Access hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard