info@excelprodigy.com
+91 893989 8008 / +91 80720 78791
MS Access
Course Content :
Introduction of Database concept
- What is Database
- What is RDBMS
- Advantage of RDBMS
- Fields and Records
Introduction of Access
- Introduction to Microsoft Access
- Access as Partial RDBMS and Reporting tool
- Ribbon interface
- New features of Ms Access
Getting Started
- Types of objects in Access
- Understanding different views in database
- Import data from various source
- Export data in various form
Working with Tables
- Creating tables
- Assigning primary key
- Establishing relationships between tables
- Join properties
Designing and Using Queries
- Creating simple queries
- Performing calculations on fields
- Creating GROUP BY queries
- Creating cross-tab queries
- How to remove duplicate entries
Working with Advanced and Action Queries
- Queries that create new tables
- Queries that append data to tables
- Queries to update fields
- Using parameter queries
- Multiple table queries
- Copying the structure of a table
- Unmatched and Find Duplicate Queries
- Exporting queries to other application like word, Excel
- Importing data from other applications into access
Using Forms
- Creating forms using wizard
- Creating forms using Design
- Performing calculations in forms
- Parent and child forms (Forms and Sub Forms)
- Command buttons
- Creating tab forms
- Creating forms with controls
- Creating switchboard
Generating Reports
- Generating simple reports using wizard and
- Generating simple reports using Design
- Generating group-wise reports
- Creating reports using parameter queries
- Adding sub-totals to reports
- Performing calculation to added fields in reports
- Reports and sub reports
- Creating reports using more than one tables
Database Management Tools
- Compact and Repair
- Split DB
- Application option
Macros
- Understanding macros creation
- Using all macros of previous version
- Applying macros to button
- Conditional macros
- Creating a Dashboard