James works as a Database Designer for AccessSoft Inc. The company has a Windows Vista-based computer with Microsoft Office 2007 installed on it. The company uses Microsoft Office Access 2007 database named Sales. James imports Contacts table into the current database, which already contains a table by the same name. Which of the following actions will take place in this scenario?
If a table having the same name is imported from the other database into the current database, a new table is created with the same name followed by a number. For example, if Contacts table is imported from the other database into the current database, which already has a table with the same name, Contacts1 table will be created.
Chapter: DATABASE, ADVANCED-LEVEL
Objective: Import, Export and Link data