What you'll Learn
- Advanced features of Database Objects
- Advanced Table options - Table Relationships
- Learn to create complex query using multiple Tables
- Learn Single, Master / Details, Column data forms
- Advanced reports like Master/Detail, Parameter Reports etc.
- Intorduction to Macros and Sample project
MS Office Access Advanced
MS Access Advanced intended for those who are familiar with the basic database operations with MS Access. This course helps you to design database applications for small business concerns. It helps the candidate to upgrade application development.
MS Office Access Advanced content
- Revision of database objects
- Tables
- Queries
- Forms
- Reports
- Advanced table options
- Create lookup
- List box
- Combo box
- Advanced data type options
- Relationship with multiple tables
- Table Templates
- Advanced query options
- Query wizard
- Parameter query
- Calculations in query
- Append Update, Delete, Maketable and crosstab queries
- Sorting and grouping data in a query
- Advanced Form Options
- Split Forms
- Use of form wizard
- Tabular forms
- Master detail form
- Calculation in form
- Using command buttons
- Advanced report Options
- Reports using wizard
- Repot based on multiple tables
- Master detail report
- Calculations in reports
- Reports based on queries
- Macros
- Introduction to Macros
- Creating and running macros
- Various macro actions
- Using Macros associated with buttons
- Sample Project
- Inventory
- Student Management system
