MS Word: How to numbering heading1 as 1 and heading2 as 1.1

Scenario
I have Heading1 - with no numbering
Then Heading2 - With No's 1, 2, 3, etc
Now I require Heading3 to be dependent on Heading2 and it it should display
1.1, 1.2, 1.3, 1.3.1, 1.3.2 etc after Heading2 No1 and
2.1, 2.2, 2.3, 2.3.1, 2.3.2 etc after Heading2 No2 etc

My desired output:

Solution:

1. Create a style, Style-->Create a style
   
1. Click modify style then
   
1. style name: style1
2. style type: paragraph
3. style based on: normal
4. style for following paragraph: normal
5. Select your font, font size, and etc
6. click format-->Paragraph
   
1. Indentation choose
1. Before text: 0
2. After text: 0
3. Outline level: level1
2. Create a style, Style-->Create a style
3. Click modify style then
1. style name: style2
2. style type: paragraph
3. style based on: normal
4. style for following paragraph: normal
5. Select your font, font size, and etc
6. click format-->Paragraph
1. Indentation choose
1. Before text: 0.76 (It aligns the two heading1 with heading2)
2. After text: 0
3. Outline level: level2
2. Create a new multilevel list which will be look like as 1.1 Heading1, 1.1.1Heading2, 1.1.1.1Heading3 and continuing series 
   
   
   
   
1. Click on the the level 1 to modify
   
1. link level to style: style1
2. level to show in gallery: level1
2. Click on the the level 2 to modify
1. link level to style: style2
2. level to show in galery: level2
3. Now if you select your text as style1 and style2 it will automatically do numbering as the desired output

MS Word: How do I prevent Word from redisplaying multiple minimized open documents when opening a new document?

How do I prevent Word from redisplaying multiple minimized open documents when opening a new document?

Hi, This problem was driving me insane. I managed to fix it on my Windows 7 Pro desktop with Office 2013.

My registry had these settings under HKEY_CLASSES_ROOT\Word.Document.12\shell\Open\command:

Default: "C:\Program Files (x86)\Microsoft Office\Office15\WINWORD.EXE" /n "%1" /o "%u"

Command: yh1BV5!!!!!!!!!MKKSkWORDFiles>!2-1&m&8y@Nmo2r)^f-C /n "%1" /o "%u"

I changed them to this (removing the, "/o "%u"" and adding "/q" before "/n" to remove the splash screen :

Default: "C:\Program Files (x86)\Microsoft Office\Office15\WINWORD.EXE" /q /n "%1"

Command: yh1BV5!!!!!!!!!MKKSkWORDFiles>!2-1&m&8y@Nmo2r)^f-C /q /n "%1"

I did the same for HKEY_CLASSES_ROOT\Word.Document.8\shell\Open\command, and am now able to open other files without restoring or maxmizing other minimized Word .doc or .docx files. Please let me know if this works for you as well.

Exam 70-463 Datawarehouse

Preparing for 70-463 Exam : Implementing a Data Warehouse with Microsoft SQL Server 2012

December 5, 2013manub22Leave a commentGo to comments

 

 

 

 

 

 

Rate This

After passing 70-461 exam last year I’m now preparing for 70-463 exam i.e. Implementing a Data Warehouse with Microsoft SQL Server 2012. This exam mainly focuses on implementing Data Warehouses with Dimension & Fact tables, working with SSIS packagesand Data Quality solutions. Thus being a Database Developer (primarily) this exam will be bit tough for me as I’ve not worked with Dimensional modelling, SSIS and DQS.

This exam is primarily intended for ETL and Data Warehouse (DW) developers who create Business Intelligence (BI) solutions, and whose responsibilities include Data Cleansing, and Extract Transform Load and Data Warehouse implementation.

–> The Exam is divided into 5 modules:
1. Design and Implement a Data Warehouse
2. Extract and Transform data
3. Load Data
4. Configure and deploy SSIS solutions
5. Build Data Quality solutions

You need to brush up on following Skills in the these Modules:
-:Check links with the below items for more information:-

-> Design and Implement a Data Warehouse | 11%
– Introducing Star and Snowflake Schemas
– Design and Implement Dimensions
– Design and Implement Fact tables
– Managing the Performance of a Data Warehouse
- PREP links: Introduction to dimensions (Analysis Services – multidimensional data) |Dimension relationships | Columnstore indexes

-> Extract and Transform data | 23%
– Define Connection managers
– Design Data Flow
– Implement Data Flow with Transformations
– Control Flow tasks and Containers, Precedence Constraints
– Manage SSIS package execution
– Implement Script tasks in SSIS
- PREP links: Integration Services (SSIS) connections | Data flow | Slowly changing dimension transformation

-> Load Data | 27%
– Design control flow
– Implement package logic by using SSIS variables and parameter
– Implement Control flow
– Implement Data Load options
– Implement Script components in SSIS
– Slowly Changing Dimensions
– Preparing a Package for Incremental Load
– Package Transactions, Checkpoints, Event Handlers
- PREP links: Integration Services transactions | Developing a custom task | Integration Services (SSIS) parameters

-> Configure and Seploy SSIS solutions | 24%
– Troubleshoot Data Integration issues
– Install and Maintain SSIS components
– Implement Auditing, Logging, and Event handling
– Deploy SSIS solutions
– Configure SSIS security settings
– Data Mining Task and Transformation
– Preparing Data for Data Mining
– Implementing SSIS Fuzzy Transformations
- PREP links: Troubleshooting tools for package development | Load-balancing packages on remote servers by using SQL Server Agent | Integration Services (SSIS) logging

-> Build Data Quality Solutions (DQS) | 15%
– Install and maintain Data Quality services
– Creating and Maintaining a Knowledge Base
– Create a Data Quality project to clean data, Profiling Data and Improving Data Quality
– Using DQS and the DQS Cleansing Transformation
– Implement Master Data Management (MDM) solutions
– Using Master Data Services Add-in for Excel
- PREP links: Install Data Quality Services | Install Master Data Services | Master Data Services features and tasks

Adobe Acrobat Tutorial

How to save ONE single page of pdf document?

1. Click Tools
1. Click Pages
2. Click Extract
1. Put the page number you want to extract
2. Check - Extract Pages as separate file

Removing sensitive content

Why remove sensitive content? Find and remove hidden content Remove Hidden Information options Redact (black out and remove) sensitive content Search and remove text Select a different language version for patterns Change the look of redaction marks Set the default look of all marks Properties for redaction text Redaction codes Create redaction codes and code sets Edit redaction codes and code sets Apply multiple code entries to a single redaction Additional resources Why remove sensitive content? Before you distribute a PDF, you may want to examine the document for sensitive content or private information that can trace the document to you. Such information can be hidden or not immediately apparent. For example, if you created the PDF, the document metadata normally lists your name as the author. You may also want to remove content that can inadvertently change and modify the document’s appearance. JavaScript, actions, and form fields are types of content that are subject to change. Use the Remove Hidden Information feature to find and remove hidden content from a PDF. Use the Black Out & Remove Content tools to remove sensitive images and text that are visible in a PDF. Find and remove hidden content Use the Remove Hidden Information feature to find and remove content from a document that you don’t want, such as hidden text, metadata, comments, and attachments. When you remove items, additional items are automatically removed from the document. Items that are removed include digital signatures, document information added by third-party plug-ins and applications, and special features that enable Adobe Reader users to review, sign, and fill PDF documents. To examine every PDF for hidden content before you close it or send it in e-mail, specify that option in the Documents preferences using the Preferences dialog box. Choose Tools > Protection > Remove Hidden Information. If you don’t see the Protection panel, see the instructions for adding panels at Task panes. If items are found, they are listed in the Remove Hidden Information panel with a selected check box beside each item. Make sure that the check boxes are selected only for the items that you want to remove from the document. (See Remove Hidden Information options.) Click Remove to delete selected items from the file, and click OK. Choose File > Save, and specify a filename and location. If you don’t want to overwrite the original file, save the file to a different name, location, or both. The selected content is permanently removed when you save the file. If you close the file without saving it, repeat this process, making sure to save the file. Remove Hidden Information options Metadata   Metadata includes information about the document and its contents, such as the author’s name, keywords, and copyright information, used by search utilities. To view metadata, choose File > Properties. File Attachments   Files of any format can be attached to the PDF as an attachment. To view attachments, choose View > Show/Hide > Navigation Panes > Attachments. Bookmarks   Bookmarks are links with representational text that open specific pages in the PDF. To view bookmarks, choose View > Show/Hide > Navigation Panes > Bookmarks. Comments And Markups   This item includes all comments that were added to the PDF using the comment and markup tools, including files attached as comments. To view comments, choose the Comments pane. Form Fields   This item includes form fields (including signature fields), and all actions and calculations associated with form fields. If you remove this item, all form fields are flattened and can no longer be filled out, edited, or signed. Hidden Text   This item indicates text in the PDF that is either transparent, covered up by other content, or the same color as the background. Hidden Layers   PDFs can contain multiple layers that can be shown or hidden. Removing hidden layers removes these layers from the PDF and flattens remaining layers into a single layer. To view layers, choose View > Show/Hide > Navigation Panes > Layers. Embedded Search Index   An embedded search index speeds up searches in the file. To determine if the PDF contains a search index, choose View > Tools > Document Processing > Manage Embedded Index. Removing indexes decreases file size but increases search time for the PDF. Deleted Or Cropped Content   PDFs sometimes retain content that has been removed and no longer visible, such as cropped or deleted pages, or deleted images. Links, Actions And JavaScripts   This item includes web links, actions added by the Actions wizard, and JavaScripts throughout the document. Overlapping Objects   This item includes objects that overlap one another. The objects can be images (composed of pixels), vector graphics (composed of paths), gradients, or patterns. Redact (black out and remove) sensitive content Redaction is the process of permanently removing visible text and graphics from a document. You use the Black Out & Remove Content tools (also called redaction tools) to remove content. In place of the removed items, you can have redaction marks that appear as colored boxes, or you can leave the area blank. You can specify custom text or redaction codes to appear over the redaction marks. Note: If you want to locate and remove specific words, characters, or phrases, use the Search & Remove Text tool  instead. Text marked for redaction (left), and redacted (right) Choose Tools > Protection > Mark for Redaction . If you don’t see the Protection panel, see the instructions for adding panels at Task panes. (Optional) To set the appearance of redaction marks, click Redaction Properties. (See Change the look of redaction marks.) Mark items you want to remove by doing any of the following: Double-click to select a word or image. Drag to select a line, block of text, object, or area. Press Ctrl as you drag to select areas of a page in a scanned document. To preview how your redaction marks appear, hold the pointer over the marked area. To apply multiple code entries to a single redaction, right-click a redaction mark and select an option. For more information, see Apply multiple code entries to a single redaction. (Optional) To repeat a redaction mark, right-click it and choose Repeat Mark Across Pages. This feature is convenient if a particular header, footer, or watermark appears in the same location on many pages. Click OK to remove the items. The items aren’t permanently removed from the document until you save it. If you want to search for and remove hidden information in the document by using the Remove Hidden Information feature, click Yes in the dialog box. Otherwise, click No. Choose File > Save, and specify a filename and location. The suffix “_Redacted” is appended to the filename. If you don’t want to overwrite the original file, save the file to a different name, location, or both. Search and remove text Use the Search & Remove Text tool to find and remove words or phrases in one or more PDFs that contain searchable text. Note: The Search & Remove Text tool doesn’t search secured (encrypted) PDFs. Choose Tools > Protection, and select the Search & Remove Text tool . If you don’t see the Protection panel, see the instructions for adding panels at Task panes. Specify if you want to search the current PDF or all PDFs in another location. Do one of the following: To search for only one word or phrase, choose Single Word Or Phrase and type the word or phrase in the text field. To search for multiple words, select Multiple Words Or Phrase, and then click Select Words. Type each word in the New Word Or Phrase text field and click Add. You can also import a text file with the list of words or phrases to search for. To search for a pattern (for example, phone numbers, credit card numbers, e-mail addresses, social security numbers, or dates), click Patterns. Choose one of the available patterns. You can change the language version of the patterns. (See Select a different language version for patterns.) Click Search & Remove Text. In the search results, click the plus sign (+) next to the document name to see all occurrences of the word or phrase. Then, select the occurrences you want to mark for redaction: To select all occurrences in the list, click Check All. To select individual occurrences, click the check box for each one you want to redact. Click the text next to a check box to view the occurrence on the page. To mark none of the occurrences, close the Search window or click New Search to start over. To mark whole words or partial words (characters) for redaction, select the option under Redaction Mark Options. For partial words, click Settings and specify the number and location of the characters for redaction. Character redaction is useful if you’re searching for a pattern, like credit card numbers, and want to leave part of the number visible for identification purposes. If you selected occurrences that you want to mark for redaction, click Mark Checked Results For Redaction. The items you selected in the list are shown marked for redaction. Note: If you haven’t saved the file, you can select redaction marks in the document and press Delete to remove the redaction mark. The redaction marks become permanent after you save the file. To remove the marked items, click Tools > Protection > Apply Redactions, and then click OK. The items aren’t permanently removed from the document until you save it. If you want to search for and remove hidden information in the document by using the Remove Hidden Information feature, click Yes. Otherwise, click No. Choose File > Save, and specify a filename and location. If you don’t want to overwrite the original file, save the file to a different name, location, or both. Select a different language version for patterns Localized patterns appear in the Search panel (Protection > Search & Remove Text). Choose Edit > Preferences (Windows) or Acrobat > Preferences (Mac OS). From the Categories on the left, select Documents. In the Redaction area, choose a language from the Choose Localization For Search & Remove Text Patterns menu. Change the look of redaction marks By default, thin red outlines appear around images and text you mark for redaction, and black boxes appear in place of redacted images and text. You can set the default appearance of redaction marks before you mark items for redaction. You can also change the look of redaction marks before you apply the redactions. Set the default look of all marks Click Tools > Protection > Redaction Properties. If you don’t see the Protection panel, see the instructions for adding panels at Task panes. On the Appearance tab, select options you want to change, and then click OK: Click the Redacted Area Fill Color icon and select a fill color from the Color palette for the boxes that replace removed items. Choose No Color to leave the redacted area blank. Select Use Overlay Text if you want to select the custom text or redaction code options. Select the font, size, and text alignment. Select Custom Text, and type the text you want to appear in the redacted area. Select Redaction Code, and then either select a code within an existing set, or click Edit to define a new code set or a new code. (See Create redaction codes and code sets.) In the Redaction Mark Appearance area, click the Outline Color icon or Fill Color icon or both. Select a color from the color palette for the images and text you mark for redaction. Move the slider to adjust the opacity of the color. Choose No Color to leave the selected area blank. Properties for redaction text Custom Text   Displays text you type into the Custom Text option over the redaction mark. Font   Displays custom text in the selected font. Font Size   Displays custom text in the selected point size. Auto-Size Text To Fit Redaction Region   Resizes custom text to fit within the redacted area. When selected, this option overrides the Font Size setting for the overlay text. Font Color   Displays custom text in the selected color, which you can change by clicking the color swatch. Repeat Overlay Text   Fills the redacted area with as many instances of the custom text as needed, without changing the font size. For example, if you specify the letter x or a hyphen (-) as the custom text, these characters are repeated throughout the redacted area. Text Alignment   Aligns text to the left, right, or center. Redaction codes Acrobat uses overlay text to overprint areas selected for redaction. One example of overlay text is a redaction code, which consists of one or more code entries from a collection of code entries called a code set. Acrobat includes the U.S. FOIA and U.S. Privacy Act code sets that you can use. You can use either codes or custom text to create overlay text. The difference is that redaction codes are text entries that you can save, export, and import. One code set can contain multiple codes. Note: Codes don’t save the current attributes for overlay text as part of the code definition, such as colors, font characteristics, and repetition or size of text. Codes only make the overlay text itself reusable in future sessions and by other users with whom you share code sets. You set other attributes for the code in the Redaction Tool Properties dialog box. Create redaction codes and code sets Click Tools > Protection > Redaction Properties . If you don’t see the Protection panel, see the instructions for adding panels at Task panes. Select Use Overlay Text. Select Redaction Code. To add multiple code entries to a redaction code, select an entry from the Code Entries list and click Add Selected Entry. Repeat as desired. Select Remove Selected Entry to delete a code entry. Click Edit Codes to make additional changes. In the Redaction Code Editor dialog box, click Add Set. (Optional) Type a new name for the set in the text field below the list of code sets, and then click Rename Set. Click Add Code, and type the text that you want to appear as overlay text in the text field below the list of code entries, and then click Rename Code. Repeat the previous step to add another code entry to that code set, or repeat the previous three steps to create additional code sets and codes. Edit redaction codes and code sets Click Tools > Protection > Redaction Properties . If you don’t see the Protection panel, see the instructions for adding panels at Task panes. Select Use Overlay Text, and then select Redaction Code. Select a code set from the list on the left, and click Edit Codes. In the Redaction Code Editor dialog box, do any of the following: To remove a code set and all of the code entries within it, select the code set and click Remove Set. To export a code set to a separate XML file that you can reuse in other PDFs or share with others, select the code set. Then click Export Set, specify a filename and location, and click Save. To import a previously saved code set, click Import Set, locate and select that file, and click Open. To rename a code set, type a new name in the box below the list and click Rename Set. With the code set selected, select the code entry that you want to edit, and do one of the following: To remove a code entry, click Remove Code. To rename a code entry, type a new name in the box below the list and click Rename Code. Apply multiple code entries to a single redaction Right-click the redaction marker. Choose a code set or code entry from the list at the bottom of the context menu. Select a code set from the list at the bottom of the context menu, and then select a code entry from the drop-down menu. A check mark appears next to the code entry when the code is applied. Repeat the previous step to add another code entry to the redaction. Hold your pointer over the redaction mark to see the code entries, each one separated by a comma. Another way to add multiple code entries to a redaction is by using the Redaction Properties dialog box. In the Protection panel, click Redaction Properties. Select Redaction Code, select a code entry, and then click Add Selected Entry. Additional resources For videos and articles on removing sensitive content, see these resources: Removing Sensitive Information: www.adobe.com/go/lrvid_027_acrx_en Content Deletion Using Acrobat X: http://tv.adobe.com/watch/i-didnt-know-acrobat-could-do-that-loris-top-10-for-acrobat-x/content-deletion/ Using the redaction tools in legal situations: blogs.adobe.com/acrolaw/

Google Chrome: Does not show find menu

Go to menu > settings

Scroll to the bottom and choose "show advanced settings.."

Scroll to the bottom again and untick

[ ] Use hardware acceleration when available

iPhone/iPad: Rotate Upside Down iPad Videos

Rotate and Watch a Video in VLC

Download, install, and run VLC Media Player. (See download link below)

Open your video file by going to Media  > Open File… and browsing for your file. Or, by just dragging and dropping your video onto the VLC player.

Choose Tools from the Menu bar and select Effects and Filters.

On the Video Effects tab, tick the Transform checkbox and choose your degrees of rotation. The video is rotated counter-clockwise, so to rotate clockwise 90 degrees you’ll want to chooseRotate by 270 degrees.

Now you can enjoy your video the way it was intended to be viewed.

Rotate and Convert the Video with Windows Live Movie Maker

Starting with Windows 7, Windows Movie Maker no longer comes pre-installed with the OS. It’s now part of the Windows Live suite that is available as a separate, free download for Windows 7 and Vista. (Windows XP is not supported) You can find the link to our detailed instruction on how to install Windows Live at the end of the article.

To add your video files to Windows Movie Maker, click on Add videos and photos on the Hometab, or drag and drop the video into the blank area on the right side of the application.

Next, you’ll need to rotate the video. Staying on the Home tab, click on the Rotate right 90°

or Rotate left 90°.

You’ll see your video is now oriented properly on the left.

To save and convert your video to WMV format, click the Movie Maker tab just to the left of the Home tab. Hover your cursor over Save movie, and then select your output settings. You also have the option to burn directly to DVD.

 In the VLC Media Player main menu go "Tools" > "Effects and Filters"

4. In "Adjustments and Effects" window, choose the "Video Effects" tab

5. In "Video Effects" tab, choose "Geometry"

6. In "Geometry" click the "Transform" box to enable transform and make sure that the "Rotate by 90 degrees" setting below is selected.  Then choose "Close" to close the window. Notice*: The "Rotate by 90 degrees" setting, rotates your video by 90 degrees clockwise. If you want to rotate your video in a different angle then choose the corresponding angle.

Now you can view and play your rotated video with VLC Media player (only) in the right angle. 7. If you like to save your recent rotated video, from the main menu go to "Tools" > "Preferences"

 8. In Interface Settings look at the left side's bottom and choose to "Show All Settings"

 9. At the left pane under "Stream Output" expand "Sout stream" >"Transcode" and at right pane under "Video filter" choose the "Video transformation filter". Then click "Save" to save your settings.

 10. From the main menu choose "Media" > "Convert / Save"

 11. At "Convert/Save" options at "File" tab, choose "Add…" to add your recently rotated video file and then press the drop-down arrow on the right of "Convert / Save" button to choose "Convert"

 12. At "convert" options, choose "Browse", select the destination folder (e.g. "Desktop"), give a file name for the converted file (e.g. "IMG_1822Rotated") and specify the output video file type (e.g. ".MOV")

 13. While in "convert" options, choose your profile output: "Video – H.264 + MP3 (MP4)" and then press the "Tools" button on the right side to edit the selected profile.

 14. In profile settings, find and click the "Audio codec" tab

 15. Inside "Audio codec" settings use the drop-down arrow in codec's line and from the list of codecs choose "MP3". Then click Save.

 16. In "Convert" window press "Start" to start the conversion.

 17.As "Conversion/Streaming" process is executed, you see the following screen.

18. When  the "Conversion/Streaming" process is completed, you can play your video in any media player you like.

Attention: After you rotate and save your videos, you must reset VLC player to it's default settings , by going to: "Tools" > "Preferences" and press the "Reset Preferences" button at the bottom side of Preferences window.

Second method:

Browse for a location to save it and rename the output file if you’d like. Click Save.

You’ll be notified when the file is complete.

Now you’ll have your video properly oriented in WMV file format.

These are two rather easy ways to accomplish rotating your video. Unfortunately, Windows Live Movie Maker doesn’t give you a lot of  options for output. If you want to output to a file, your only choice is WMV format or DVD. However, previous versions will also allow you to export to AVI.