how do you update pivot table report data after changes are made to the source data?

Related MCQs

• How can you display Pivot Table report summary data in a currency format?
• How can you display pivot table report summary data in a currency format?
• How can you link a table with another so that a field in current table will display values in drop down box from another table while entering data:
• What happens when you release mouse pointer after you drop the primary key of a table into foreign key of another table?
• If I create ‘Student’ field in ‘Fees’ table to store ‘student_id’ of ‘Students’ table, then this ‘Student’ field in ‘Fees’ table is called:
• After entering all fields required for a table, if you realize that the third field is not needed, how will you remove?
• After entering all fields required for a table, if you realize that the third field is not needed, how will you remove?
• In the second subform wizard dialog box you specify the table to use as the data source and the
• While creating relationship, when you drag a field of a field to drop into another table the mouse pointer changes into
• What is the type of query that extracts data from a table and puts them into separate table?