![]() FieldĬharacteristic of a person, a thing or an event ![]() Terms that you should know before starting. Possible to create and manage simple databases from Excel. You need a database before being able to create an use a pivot table. The next exercise consists in creating a pivot table that offers the total of salaries according to gender and the type of work an employee occupies in the company. Access XP (2002) and the next versions have their own version of a pivot table and no longer require Excel. When required, Access will open Excel and use its pivot table options. Office can create pivot tables from data in your database. It's also possible to use Excel's pivot table options from Access 97 or 2000. It means that you can add, remove and change the location of elements in the table Excel will automatically give you a new view on your data. As the name indicates, Excel generates a table that allows you to see the contents of one or several variables at the same time. Excel offers you a fascinating tool to create a synthesized view from a vast pool of data called a pivot table.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |