Recents in Beach

Microsoft access 2010 Course Outline | Learn access with Ehsan Javaid

Microsoft access 2010 Course Outline | Online access Tanning | Learn access with Ehsan Javaid


Microsoft Access 2010:


Intro:

                          This course is developed under very professional teacher and instructor. Within this course you will be learn lot of things about how to create your local data base, also you can publish this data base on website or internet. All skills which you will learn in this course, is 100% practical based and also you will get awesome tips and tricks about access.


What Is a ACCESS Software?


                              Microsoft Access is an information management tool that helps you store information for reference, reporting, and analysis. Microsoft Access helps you analyze large amounts of information, and manage related data more efficiently than Microsoft Excel or other spreadsheet applications.


Course Outlines:

                 This course is design in which you learn ms word 2010 tab vise. It is a one of my favorite way to learn any software. see details below;

Home Tab Tools:

  • font settings and styles ( size, color, style, bold, etc)
  • create bullets, numbering, indent
  • record section
  • sort and filter
  • find and replace
  • views
  • copy and paste

Create Tab Tools:

  • table and templates
  • sharepoint lists
  • table design
  • form ( creating, desining, spliting, and much more,)
  • report  (create, design, etc)
  • query with wizard and design

    External Data Tab Tools:

    • import data from other software
    • create xml , txt file
    • export data from access
    • collect data from email

      Database Tab Tools:

      • Create macro
      • create relationship with databases
      • analyze the data and table
      • move data
      • database tools

      Data Sheet Tab Tools:

      • views
      • fields and columns
      • datatype and formatting


        Learn Software Links

        Technical Setup Details

        • Software Full Name: OFFICE 2010 SP2 PRO PLUS VL APRIL 2020 
        • Setup File Name: 
        • MS_Office_2010_SP2_Pro_Plus_VL-X86.zip
        • MS_Office_2010_SP2_Pro_Plus_VL-X64.zip
        • Full Setup Size: 
        • 1.9 GB, 2.2 GB
        • Setup Type: Offline Installer / Full Standalone Setup
        • Compatibility Architecture: 64 Bit (x64)
        • Latest Version Release Added On: 22th Apr 2020

        System Requirements 

        Before you start Office 2010 SP2 Pro Plus VL April 2020 free download, make sure your PC meets minimum system requirements.
        • Operating System: Windows 7/8/8.1/10
        • Memory (RAM): 1 GB of RAM required.
        • Hard Disk Space: 1 GB of free space required.
        • Processor: Intel Dual Core processor or later.

        Download Software

        Shortcut Key: 

        Manage Database
        • Ctrl + N: to open or create new database
        • Alt + F4: to exit from Access
        • F12: Open the Save as dialog box
        • Ctrl + S: to save a database object
        • Ctrl + P: print the selected object
        Wizards
        • Tab: toggle the focus forward between controls in the wizard
        • Alt + F: complete the wizard
        • Alt + N: move to the next page of the wizard
        • Alt + B: move to the previous page of the wizard
        Find and Replace
        • Ctrl + F: find and replace dialog box
        • Ctrl + H: replace dialog box
        • Shift + F4: find next
        Text Boxes
        • Home/ End : Move beginning/ move to end of an entry
        • Ctrl + Arrow Left: move one word to left or right
        • Shift + Home: select from cursors to end
        Insert Data
        • Ctrl +; insert the current date
        • Ctrl+;  insert the current time
        • Ctrl + Alt + Space: insert the default value for a field
        • Ctrl++:  Add a new record
        • Ctrl + Enter: insert a new line
        • Shift + Enter: save changes to the current record
        Other Shortcuts
        • F2: display hyperlink
        • F7: Check spelling
        • Ctrl + F2: invoke a builder
        • Alt + Enter: display a property sheet in design view
        • Ctrl + Arrow Right: toggle forward

        Post a Comment

        0 Comments