Skip to main content

Microsoft Access MS Access Basics Tips and Trick-7

Adding Data An Access database is not a file in the same sense as a Microsoft Office Word document or a Microsoft Office PowerPoint are. Instead, an Access database is a collection of objects like tables, forms, reports, queries etc. that must work together for a database to function properly. We have now created two tables with all of the fields and field properties necessary in our database. To view, change, insert, or delete data in a table within Access, you can use the table’s Datasheet View. A datasheet is a simple way to look at your data in rows and columns without any special formatting. Whenever you create a new web table, Access automatically creates two views that you can start using immediately for data entry. A table open in Datasheet View resembles an Excel worksheet, and you can type or paste data into one or more fields. You do not need to explicitly save your data. Access commits your changes to the table when you move the cursor to a new field in the same row, or whe...

Microsoft Excel-office ADVANCED OPERATIONS Tips and Tricks-11

Printing Worksheets in Excel 2010

Quick Print

If you want to print a copy of a worksheet with no layout adjustment, use the Quick Print option. There are two ways in which we can use this option.

  • Choose File » Print (which displays the Print pane), and then click the Print button.

  • Press Ctrl+P and then click the Print button (or press Enter).

Adjusting Common Page Setup Settings

You can adjust the print settings available in the Page setup dialogue in different ways as discussed below. Page setup options include Page orientation, Page Size, Page Margins, etc.

  • The Print screen in Backstage View, displayed when you choose File » Print.

  • The Page Layout tab of the Ribbon.

Choosing Your Printer

To switch to a different printer, choose File » Print and use the drop-down control in the Printer section to select any other installed printer.

Specifying What You Want to Print

Sometimes you may want to print only a part of the worksheet rather than the entire active area. Choose File » Print and use the controls in the Settings section to specify what to print.

  • Active Sheets − Prints the active sheet or sheets that you selected.

  • Entire Workbook − Prints the entire workbook, including chart sheets.

  • Selection − Prints only the range that you selected before choosingFile » Print.



The beginner to advance and start up step-11





Thank you all very much

Comments