Introduction
In the previous lesson, you learned how to sort and filter. You may think, I can do that in a spreadsheet so why do I need to learn how to do database? It is true that spreadsheets have some of the same features as database software, but there are features available in database software that aren't available in spreadsheets. As you continue through this unit, you will learn how to utilize these other features. However, for this lesson we will concentrate on importing files.
You may have a spreadsheet file that already contains information you want to use in a database. If so, you do not have to recreate the information in a database. Instead, you can import the spreadsheet file into the database software and organize / modify it so it meets your needs.
You can also take a database file that contains figures (like monthly sales, income, monthly fees, etc.) and export the database file into a spreadsheet. By exporting the file, you can save time and can now manipulate figures with various formulas and functions create charts, etc. This lesson is designed to be quick and easy in order to provide you with the knowledge base for understanding importing and exporting files.
Following successful completion of this lesson, students will be able to...
- Create a product that integrates information from multiple software applications
- Utilize advanced features of database software, including sorting, filtering, querying and merging data, and creating reports
- Organizing database content using formatting, editing, and records tools
Enduring Understandings
- It is simple to import a spreadsheet file into a database or export a database file to a spreadsheet.
The above objectives correspond with the Alabama Course of Study: Business Technology Applications standards: 7, 11.