- Duration: 1 Hour
Course details
Microsoft Office Access 2007 offers several options for importing and exporting data, and also provides a variety of data presentation strategies. With Access 2007 you can link to, or import data and objects from external sources such as other Access databases, Excel spreadsheets, text files, XML files, and SharePoint lists. You can also export data and objects from an Access 2007 database to external sources. This course explains and demonstrates the various methods of importing, exporting, and linking to external data sources. It also describes how to create and modify PivotTables and PivotCharts as an alternate way to organize and present database data. The options used to apply aggregate functions to a PivotTable, add a calculated field to a PivotTable, and export a PivotTable to an Excel spreadsheet are also discussed in the course.
- import data into an Access 2007 database
- distinguish between the options available for importing data into Access 2007
- export Access 2007 data
- distinguish between the formats you can export to from Access 2007
- set up data collection in Access 2007
- collect data by using e-mail messages
- import an object into an Access 2007 database
- export a database object to Excel
- collect data using e-mail messages
- build an Access 2007 PivotTable
- modify a PivotTable in Access 2007
- build a PivotChart in Access 2007
- modify an Access 2007 PivotChart
- create a PivotTable in Access 2007
- create a PivotChart in Access 2007
- modify a PivotTable
- modify a PivotChart
About New Horizons Lebanon
As changes in technology have accelerated, it’s become even more essential for people to master technology to be productive, invaluable employees who optimize, program and invent solutions—and even grow companies of their own. With over 300 centers in 60 countries, New Horizons is the world’s largest independent IT and Business training company. Over the past 35 years, New Horizons has delivered a full range of IT and business skills/Management training through innovative learning methods that have transformed businesses and helped over 35 million students reach their goals. New Horizons Lebanon branch was established in 1996.
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- AED 37
AED 918Duration: Upto 18 Hours - Microsoft Excel - Complete Diploma Knowledge DoorAED 93
AED 1,028Duration: Upto 11 Hours
