Best institute for MS Access training course

MS Access - Overview. Microsoft Access is a Database Management System (DBMS) from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and softwaredevelopment tools. ... It can also import or link directly to data stored in other applications and databases.

We at Yosharp makes the students learn the latest version of MS Access, the contents for the MS Access course includes

Understanding your Data

  • Designing a database
  • Data modelling
Oerview of Access
  • Components
  • Creating a database
Creating Tables
  • Attributes
  • Datatypes
Adding/Editing Data
  • Manual editing
  • Importing data
Filtering/Exporting Tables
  • Filtering/sorting data
  • Exporting data
Table Relationships
  • Types of relationship
  • Referential Integrity

SQL the Language

  • Types of queries
  • The SELECT statement
Query Builder in Access
  • Building queries
  • Expressions
Multipleā€table Queries
  • The JOIN condition
  • Self joins
Aggregate Queries
  • GROUP BY clause
  • Aggregate functions
Advanced Topics
  • Database configuration
  • Advanced queries