Business Database Programming
San Diego & Orange County
- Business Databases: Design & Development
- Microsoft SQL Server
- Microsoft Visual Studio, ASP.NET, C#, VB
- Telerik .NET Tools & Reporting
- Microsoft Access Programming
Expert with Microsoft Access and Microsoft SQL Server:
Microsoft Access is a database management system (DBMS) that utilizes the relational Microsoft Jet Database Engine with an easy to use user interface and software development tools. Access stores data in its own table formats based on the Access Jet Database Engine. It can also import or link directly to data stored in other applications and databases.
An Access programmer can create custom application software. Access is supported by Visual Basic for Applications (VBA), an object-based Access programming language that can reference a variety of objects including DAO (Data Access Objects), ActiveX Data Objects, and many other ActiveX components. Visual objects used in forms and reports expose their methods and properties in the VBA programming environment, and VBA code modules can call Windows operating system operations.
Microsoft SQL Server:
Microsoft SQL Server is a relational database management system (RDBMS) with the primary function of storing and retrieving data as requested by other computer software which may run either on the same computer or on another computer across a local area network or the internet.
There are several versions of Microsoft SQL Server with various costs and licensing platforms. There is a version of Microsoft SQL Server Express which is free, and contains most of the features of the standard versions, and is limited in capacity but the capacity is sufficient for many businesses.
Microsoft SQL Server can serve as data storage for Microsoft Access (back-end), using Access as a user interface (front-end) for the SQL Server data. Utilizing Microsoft Access as a front-end in this way will enable a SQL Server programmer to tap into SQL Server stored procedures for far better performance and dependability.