1. Home
  2. Course
  3. MS Access

MS Access

  

About this Course

A successful database is efficient quick accurate and easy to use. This course covers how to create such a database with MS Access.

Course Content : 

Module 1: Get Acquainted with Access

♦ What is access

♦ Introduction to Database

♦ Relational Database management system

♦ Introduction to Database objects

♦ Components of Access User interface

♦ Ribbon, Navigation pane, Back stage view

Module 2: Access startup screen

♦ Creating new blank Database

♦ Closing Database

♦ Creating Database from Template

♦ Opening an existing Database

♦ Backing up Database

Module 3: Using Navigation Pane

♦ Viewing object, Copying object

♦ Renaming Object, Deleting object

Module 4: Access Tables

♦ Planning Tables

♦ Planning fields

♦ Creating tables in Design view

♦ Modifying Tables in Design view

♦ Selecting a primary key

♦ Importing data from excel into new table

♦ Importing data as a linked table

Module 5: Table Relationship

♦ Relationship types

♦ Creating relationship in database

♦ Creating look up field

♦ Viewing related data

Module 6: Creating Queries

♦ Creating Query in design view

♦ Creating Query with Query Wizard

♦ Modifying Queries

♦ Adjusting Query field

♦ Sorting Query field

♦ Hiding Query field

♦ Adding Query criteria

♦ Adding calculated field to Query

♦ Creating crosstab Query

Module 7 : Using Forms

♦ Form views

♦ Creating form with form Wizard

♦ Working with forms in design view

♦ Working with forms in Layout view

♦ Working with padding, Margins and Anchoring

Module 8: Creating Reports

♦ Report sections

♦ Designing a report

♦ Report views, print view, and layout view

♦ Using the report tool

♦ Working with reports in layout view

♦ Working with reports in design view

♦ Creating blank report

♦ The field list pane

♦ Grouping and sorting report

♦ Previewing and printing reports

Duration : 15 hrs

Entry Requirement : Beginner of Computer

Rate this course:

Comments

Course Rating

  • /5 from users

Course Enquiry

Course Info

Similar Courses Provided By Other Premium Providers

  • ICDL Module 5: ES WSQ - Perform Advanced Database Functions (Microsoft Access 2010) Fast Track

    Information and Communications  

    This course provides the basis for the practice-based test for ICDL Module 5 Perform Advanced Database Functions exam.The exam requires the candidate to operate effectively at more than a basic level of competence and be able to realize much of the potential of the database application. The candidate shall be able to use the database to organize, extract, view and report on data using what are dee...


    Provider:

  • ICDL Module 5: ES WSQ - Perform Advance Database Functions (Microsoft Access 2013 Fast Track)

    Information and Communications  

    This course provides the basis for the practice-based test for ICDL Module 5 Perform Advanced Database Functions exam.This course enables the participant to operate effectively at more than a basic level of competence and be able to realize much of the potential of the database application. The participant shall be able to use the database to organize, extract, view and report on data using what a...


    Provider:

  • Mobile App Creation for End User

    Information and Communications  

    No programming skills required. Come and join us in this one day workshop and learn how you can create a cross platform mobile application in just ONE day.COURSE OUTLINEModule 1.Introduction To The Mobile App IndustryModule 2.Different Kinds of App Marketing ModelsModule 3.Researching & planning your first appModule 4.Publishing Apps Golden RulesModule 5.How to get Images for your appsModule ...


    Provider:

  • Cross-platform Mobile Applications Development

    Information and Communications  

    HTML5 provides developers with tools such as Offline Web Storage, GeoLocation API, Canvas Drawing, CSS3, and many more. HTML5 applications run on Firefox OS, Tizen, Ubuntu Touch, and WebOS without a browser.COURSE OUTLINEModule 1. Mobile Applications OverviewModule 2. Apache Cordova (PhoneGap)Module 3. Cordova apps with EclipseModule 4. jQuery FundamentalsModule 5. jQuery MobileModule 6. Working w...


    Provider:

  • MCSD Web Applications

    Information and Communications  

    Today's customers need high-quality, interactive line-of-business and consumer web solutions. Get recognized for your expertise in creating and deploying modern web applications and services by earning the Microsoft Certified Solutions Developer (MCSD): Web Applications certification. COURSE OUTLINEProgramming in HTML5 with JavaScript and CSS3Developing ASP.NET 4.5 MVC Web ApplicationsDeveloping ...


    Provider: