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...
Header and Footer in Excel 2010
Header and Footer
A header is the information that appears at the top of each printed page and a footer is the information that appears at the bottom of each printed page. By default, new workbooks do not have headers or footers.
Adding Header and Footer
- Choose Page Setup dialog box » Header or Footer tab.
You can choose the predefined header and footer or create your custom ones.
&[Page] − Displays the page number.
&[Pages] − Displays the total number of pages to be printed.
&[Date] − Displays the current date.
&[Time] − Displays the current time.
&[Path]&[File] − Displays the workbook’s complete path and filename.
&[File] − Displays the workbook name.
&[Tab] − Displays the sheet’s name.
Other Header and Footer Options
When a header or footer is selected in Page Layout view, the Header & Footer » Design » Options group contains controls that let you specify other options −
Different First Page − Check this to specify a different header or footer for the first printed page.
Different Odd & Even Pages − Check this to specify a different header or footer for odd and even pages.
Scale with Document − If checked, the font size in the header and footer will be sized. Accordingly if the document is scaled when printed. This option is enabled, by default.
Align with Page Margins − If checked, the left header and footer will be aligned with the left margin, and the right header and footer will be aligned with the right margin. This option is enabled, by default.
Comments
Post a Comment