DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Code
|
|
|
Process
|
|
|
Export
|
|
|
Save
|
Detailed explanation-1: -Data export is the extraction and conversion of raw data from their existing format into a format required by another application. Exporting data is also a way of backing up data or moving it between two different versions of programs.
Detailed explanation-2: -You can export data from Access in a variety of formats, including Excel, Word, and SharePoint lists.
Detailed explanation-3: -Using Export/Import Wizard. The second method to copy table data from one database to another involves SQL Server Export and Import Wizard, which is present in SQL Server Management Studio. The user can either export from the Source database or import from Destination database in order to copy the data.
Detailed explanation-4: -On the Data tab, in the Get & Transform Data group, click From Text/CSV. In the Import Data dialog box, locate and double-click the text file that you want to import, and click Import. In the preview dialog box, you have several options: Select Load if you want to load the data directly to a new worksheet.
Detailed explanation-5: -Exporting data to Word: the basics When you export an object by using the Export-RTF File Wizard, Access creates a copy of the object’s data in a Microsoft Word Rich Text Format file (*. rtf). For tables, queries, and forms, the visible fields and records appear as a table in the Word document.