Business Process

/images/MS Access.png
Database System
Relational Database
SQL and Reporting

Welcome to BSPEC - Ms Access

Access Programming (Database Design, Tables, Forms, Queries, Reports, Macros, VBA) Microsoft Office Integration and migration SQL Server and ODBC Databases Microsoft Access enables business and enterprise users to manage data and analyze vast amounts of information efficiently. The program provides a blend of database functionality and programming capabilities for creating easy-to-navigate forms.
What do you want to find today?  

Bspec.png

Databases, Tables, Forms, Queries, Reports, Macros, VBA - Migration and Integration SQL ODBC and more . . .


Microsoft Access Developer - (n-Tier RDMS, Object-Oriented all in one system)
  • Tables - (RDMS, ODBC, and Jet) -Data Types, Referential Integrity, Normalization, Indexing, APIs.
  • Queries - (Advanced SQL and T-SQL) – SELECT, UPDATE, DELETE, INSERT, CREATE, ALTER, etc.
  • Forms (GUI), Reports (Data and Charts, etc.), Macros (prefer: VBA)
  • VBA – Access Database Object (All of the above), DAO, ADO, ActiveX, COMM DLLs, etc.…