MS Access Training

Microsoft Access is a desktop database system for storing, searching and reporting on data. It is widely used in offices, schools and small businesses for records such as students, stock, customers and accounts. Aptech Fatehabad offers a practical MS Access course in Fatehabad: you design a real database from scratch and learn to build tables, link them with relationships, find information with queries and present it with forms and reports. By the end you can build and manage your own database application.

MS Access Training Course Content

Getting Started with Access

•     Database concepts and RDBMS
•     Access interface and Navigation Pane
•     Creating a blank database and using templates
•     Database objects: tables, queries, forms, reports, macros

Tables

•     Creating tables in Design View
•     Data types and field properties
•     Primary keys
•     Input masks and validation rules
•     Lookup fields
•     Importing and exporting data (Excel, CSV)

Relationships

•     One-to-one, one-to-many and many-to-many
•     Referential integrity
•     Relationships window
•     Basics of normalisation

Queries

•     Select queries and criteria
•     Sorting and filtering
•     Calculated fields
•     Parameter queries
•     Totals (Group By) queries
•     Action queries: update, append, delete, make-table
•     Crosstab queries

Forms

•     Form Wizard and Layout View
•     Form controls and properties
•     Subforms
•     Navigation forms

Reports and Macros

•     Report Wizard, grouping and sorting
•     Summary calculations in reports
•     Printing and exporting to PDF
•     Simple macros and command buttons
•     Mini project: Student / Inventory database