1 / 10

MS-Access (database)

MS-Access (database). how to create blank data base. How to import CSV files. Book1. CSV How to make sure that our table has the same data type. How to change data type for any field How to fill new records. Reports: How to create report .

parguello
Télécharger la présentation

MS-Access (database)

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. MS-Access (database) • how to create blank data base. • How to import CSV files. Book1. CSV • How to make sure that our table has the same data type. • How to change data type for any field • How to fill new records. Reports: • How to create report. • How to add Extra Field (run time fields)

  2. MS-Access (database) • How to add new functions such as =Sum (price) • How to add your Information to any report. • How to save the Query So you can use it in Chart application • How to save the query so you can use it in word documents

  3. MS-Access (database) • How to calculate the sum of the Number fields ,or (Max, Avg , Min) for each member of any another fields. (summary) • How to count the number of fields by each member of another fields . • How to make sure that is every things inside the fields are visible .

  4. MS Excel • How to use function wizard • How to get data from another file ( vlookup , hlookup) or from another location (lookup) at the same file. • How to print selected area • How to use absolute cell reference . • How to show formula or function. • How to add charts . • How to rename cell.

  5. MS Excel • How to format cell. • How to filter data . • How to hide any range. • How show any range. • How to change page setup . • How to use if function . • Examples and work sheet.

  6. MS-Front Page • How to create folder as a location for your website inside your device. C:/My website/main.html • How to open existing files. • How to add and edit new page. • How to add and edit table. • How to add: bookmark, picture, horizontal role, form, navigation bar, interactive buttons. Hyperlinks

  7. MS-Front Page • How to create style sheet: External style , Internal style and In line; • How to attach it (external style) to more than one page, to make them similar one style. • li { background-color: #8000ff; color: white } • h1 { font-family: arial, sans-serif } • p { font-size: 14pt }

  8. MS-Front Page • How to highlight (define) HTML code for any part of page. • How to add Comments To Your Code Comments don't display when a visitor looks at the Web page in a browser, but anyone who looks at the code can read them. <!-- insert comment here -->

  9. Power Point Review • How to create master slide . • How to create title master slide . • How to specify slide layout. • How to add any text or image into slide master . • How to add animation according to time or action. • How to print more than one slide per page. • How to print slide’s note.

  10. LOGO Instructions

More Related