Import Data
Export Data
Save and Run Import Specifications
Save and Run Export Specifications
file Types in Access
100
to bring in data from another application or source
What is import data?
100
to send the database to another application
What is export data?
100
to make sure it work properly.
What does it mean to run an import
100
import is bring and export is to send
what is the difference between import and export
100
a text file in where each record appears on a separate line and the fields are separated by a single character
What is a delimited file?
200
on the home ribbon located on the tab external data
Where is the tab import data found on Access 2013?
200
Excel, a text file, PDF, or XPS , email or more
where can you send data to in Access?
200
to save changes made to a database.
What is save?
200
it runs what you have sent and also save it
What is saving and running an export do
300
Excel, saved imports, access, text files and more
where can you import data from?
300
to share the database that they have created
why do you think people send database to other places?
300
the details of an import operation that contain all the information access needs to repeat without the user input
What is a specification?
300
click Tasks and then double-click the task that you want to run.click Run Export .
how do you run a export
400
to add a table,query or report to your database and to also bring in other applications to make a database
Why is importing data important ?
400
on the external data tab
where is the export data tab located on the home ribbon?
400
to make sure you can go and access it later and make sure that all the changes are saved
why is saving and import important
400
to share with others
why would you want to export data
500
so you can tell access where to store your data at or either tell where to link the data
Why is specifying how and where you want to store your data in the current database important?
500
to tell access how to export it if you want to open the database after it has been sent or to only send the selected data
Why do you have to choose a export option in the pop up ?
500
click on a task in the navigation pane and double click it to be open then click Run Import and click save in the quick access toolbar . Click OK to confirm.
how do you run and save a import ?
500
to share with others and to also bring in something from another file to create a database and after you have created an database you can send it back to the file
What is the importance of exporting and importing data?
M
e
n
u