Sales & Support  +94 77 324 1602

 
Basic Computing
• Basic Computer Course (BCC)
           
Office Application
• Master In Microsoft Excel
• Master In Microsoft Power Point
• Master In Microsoft Outlook
Internet Training
Graphic Design
3D Modeling & Animating
• Master In Maya
 
Video Editing
• Master In Adobe Premier
• Master In Adobe After Effects
Photo Editing
• Master In Adobe Photoshop
• Master In GIMP
Web Design & 2D Animation
• Master in Adobe Dreamweaver
• Master in Joomla Web Design
• Master in Web Hosting
• Master in SEO
Master In Adobe FLASH
         
Architectural Design
• Master In Auto CAD-2D
• Master In Auto CAD-3D
Auto CAD BLOCKS
• Master In 3D MAX
• Master In AutoCAD Architecture
Hardware & Networking
• Master In Networking
Programing & Database
• Master in Visual Basic.net
• Master In Microsoft Access
• Master In Microsoft SQL
• Master In Java Programming
   
CUSTOMER CARE
PIXEL ART Co. (PVT) LTD
Production House
219, New Town, Digana, Rajawella
Kandy. Sri Lanka
Sales / Support
081 5626260
Hot line
077 3241602
 
  Master In Microsoft Access  

Master in Microsoft Access teaches you to create and maintain Database and how to use Access to manage your data. Let our experts teach you how to create forms and reports, run an query, and navigate Access databases in right and easy way..

   
         
Total Time : 4 hrs
Number of Movies : 62
Number of Discs : 1
Disk Type : CD (Data)
Language : Sinhala (Singlish)
Compatible Versions : Microsoft Access 2007, 2010 & 2013
Price : 890 LKR
   
     
  Course contain  
 
  • Database concepts
    • Understanding what a database is
    • Understanding how a database in organized
    • Understanding what is a primary key
    • Understanding what an index is
    • Understanding the purpose of relating tables in a database
    • Understanding the importance of setting rules to ensure relationships are valid
  • Starting Access
    • Getting Start Access
    • Using the Start-up Window  Sample Movie
    • Introducing the Ribbon 
    • Using the Navigation Pane 
    • Using Undo and Redo 
    • Using help
  • Starting Database
  • Tables
    • Creating a new Table & Saving
    • Creating a Table using Templates
    • Working with fields
    • Adding and modifying data in a record
    • Defining a primary key
    • Moving a column within a table
    • Deleting a record or field
    • Deleting a table
    • Renaming Tables 
  • Table Relationships
    • Introduction to relationships
    • Creating a one-to-one relationships
    • Creating a one-to-many relationships
    • Deleting relationships between tables
  • Maintaining Data Integrity 
    • Introduction & Changing the field data type attribute
    • Adding data in different data types
    • Changing field format attribute
    • Setting Field Length 
    • Using Input Masks
    • Using Default Values
    • Adding Validation rules and Validation text
    • Creating a Lookup List
  • Forms
    • Understanding & Creating Forms
    • Using the Form Wizard 
    • Using a form to enter, modify or delete records
    • Deleting a Form
    • Creating a Blank Form
    • Formatting a Form & Using AutoFormat 
    • Setting Tab Order 
  • Retrieve Information
    • Applying a filter to a table
    • Removing filters
    • Sorting Table Records 
  • Querying Data 
    • Understanding & Creating Queries
    • Adding criteria to a query
    • Editing a query or removing Criteria
    • Running a query
    • Saving and closing query
    • Deleting a query
    • Creating a Query using a Wizard
    • Designing Parameter Queries 
    • Creating Total Fields 
    • Creating Average Fields 
  • Reports
    • Creating a Report Quickly & Saving reports
    • Using the Report Wizard
    • Designing a report
    • Changing report layout
    • Changing Report Format
    • Deleting a report
    • Creating a report using Queries
    • Using Calculated Values 
  • Preparing a database to print
    • Preview a table, form or report
    • Changing report Orientation or paper size and Printing
  • Securing & Backing Up Data 
    • Password-Protecting Your Database
    • Backing Up the Database 
  • Import & Export Data
    • Importing data
    • Exporting data
 
..........................................................
..........................................................
 
|Self Learning CDs | Educational CDs | Computer Software Tutorials | Computer Courses | Sinhala Medium Training CDs |Computer Clases |Learning Programs |