Globalisation Essay

293 WordsJun 18, 20132 Pages
Q1: Microsoft Word - 30% Session 5.1 [220-239] * Creating a New Document from a Template * Inserting a File into a word document * Customising the Document Theme * Selecting a Style Set * Modifying Styles Session 5.2 * Creating footnote * Creating/Modifying footer/header * Formatting document * Creating a Table of contents [248] Session 6.1 [272-273, 281-289] * Performing a Mail Merge by using existing data file * Inserting Merge fields * Previewing the Merged Document * Merging the Main Document and Data Source Q2: Microsoft Excel - 30% Session 5.1 [239-249] * Plan and create a table * Rename and format a table * Add, edit and delete records * Enter formulae * Format cells * Conditional formatting * Sort data Session 6.1 [317-318] * Creating footer/header * Preparing the worksheet for printing Session 5.2 [252-267] * Fitting all columns into one page * Insert a total row to summarize an Excel table * Insert subtotals into a range of data Session 5.3 [272-288] * Create and modify a Pivot Table * Apply styles and formatting * Filter and sort * Insert a slicer to filter Q3: Microsoft Access - 40% Session 5.1[221-237] * Use the Like[contain], In[equal], Not, and & operators in queries * Filter data using an AutoFilter * Use the IIf function to assign a conditional value to a calculated field in a query * Create a parameter query Session 5.2[242-251 * Use query wizards to create a crosstab query, a find duplicates query, and a find unmatched query * Create a top values query Session 5.3[254-267] * Modify table designs using lookup fields, input masks, and data validation rules * Identify object dependencies Session 6.1[289-302] * Plan and create a table * Change a lookup field to a Text

More about Globalisation Essay

Open Document