Microsoft Access Database Development
- Database creation and management
- Database security and password protection
- Table creation and management
- Query creation to sort, search and filter data
- Form creation and design to interact with data
- Report creation and design
- Macro creation and management
- Module creation and management
- Data validation and formatting
- Establishing relationships between tables
- Importing and exporting data from outside source
- Integration with other Microsoft Office programs (such as Excel) and SQL Server
Microsoft Access VBA Programming
- VBA programming to automate tasks and functions
- VBA code debugging
- ActiveX Data Objects (ADO)
- Data Access Objects (DAO)
- Criteria expressions
- Error codes
- Controls
- Settings
- Windows API
- SQL Stored Procedures
- Structured Query Language (Access SQL)
- VBA object-orientated programming (Visual Basic programming language)