Custom Database Solutions
For Your Business

25+ years experience as a leader in
Microsoft Application Development

MS Access Solutions
Database Development Services

Microsoft Access

MS Access is a highly flexible, robust, and reliable database program. Microsoft Access is the leading relational database management system in the world. MS Access Solutions is your expert Microsoft Access programmer for Oakland, California.

SQL Server

SQL Server is an enterprise relational database management system from Microsoft. We use SQL Server as the database server for data storage and data retrieval to and from Microsoft Access as well as other software applications, like ASP.NET and Azure.

ASP.NET

Microsoft's application framework for web development produces dynamic web pages. ASP.NET provides web programmers with a platform for building dynamic web sites, web applications (web apps), and web services that require a web solution.

Microsoft Azure

MS Azure is Microsoft's cloud computing service. It is used for development, testing and deployment as well as managing software applications through a global network data centers managed by Microsoft. Azure now features SQL Server called Azure SQL.

We Are Your Microsoft Access Database Experts

The Best Microsoft Access Database Solutions owner, consultant, and principal programmer is Alison Balter - a recognized expert Microsoft Access consultant. Alison is the author of 15 Microsoft Access training books and videos. She is a frequent guest speaker at MS Access conferences and has developed hundreds of applications for businesses of all types.

We know your business data is important; we listen to your concerns, ask questions, and gather information from all stake holders. We discuss your needs and requirements for your database. We find out what you want, why you need various features so we can obtain as much information as possible. Once we have the information we need, we work with you to design the proper database architecture, plus the dashboards, the questions (queries), forms, and reports you need for an excellent database system.

Microsoft Access developer and MS Access development company Oakland, CA

Microsoft Applications For You

Your data is important to your business and you need both to enter and retrieve data rapidly. The data stored in your company's database must be clean, secure, and allow for maximum usage. Our Microsoft Access developer team will create your Microsoft Access database for optimum efficiency with all the features you need. After we program your MS Access and SQL Server database you will have the capacity to manipulate your data so you get the information you need for every day activities and for making critical business decisions.

We also create websites designed for speed to display your data accurately, using ASP.NET technology. Fast, secure, and robust, our ASP.NET web sites and web applications give you true business tool for finding and displaying information dynamically on the web.

Example Projects

Corporate Database

Microsoft Access front-end and SQL Server back-end database

Access Forms Development

Access data entry form connecting to SQL Server back-end database

Accounting Company

ASP.NET website with SQL Server back-end database

Corporate Reports

MS Access Report created with SQL Server database

Client Comments About Our Work

Best Microsoft Access database developer services in Oakland from MS Access Solutions

Sheldon Bloch, Oil and Gas Company

Alison from MS Access Solutions has provided both training and mentoring services to us over the past several years. Our developers use Alison Balter's books on programming with Microsoft Access as a desk reference. They have provided our staff members with much-needed training in Visual Basic, client/server development, SQL Server, and Microsoft Access. This has helped us to ensure that our employees can properly keep up with the ever-changing technologies. MS Access Solutions has also provided our staff with mentoring on an as-needed basis, providing expertise that helped our in-house programmers to overcome various hurdles. More Reviews
MS Access Solutions client who is very happy with our Microsoft Access programmer services

Lisa Dosch, Motion Picture Editors Guild - Local 700

Alison Balter at MS Access Solutions developed the application that helps us to properly service all of our members. This program handles billing, payments, tracking of jobs worked, available list, and other important data about our members. The system automates many tasks that were previously performed manually, allowing our employees to more cost-effectively use their time. This client/server system is used by employees in our Oakland and New York offices. MS Access Solutions and their staff worked with us to develop the necessary specifications and design documents, and then programmed, tested, and implemented the application throughout our organization. More Reviews

Contact Details

When you need a truly expert Microsoft Access database development company to design and develop your mission critical custom database - Contact MS Access Solutions.
  • Phone: +1 (323) 285-0939
  • Office Hours: Mon - Fri : 8:00 AM to 5:00 PM

Get In Touch

Latest From Blog

Microsoft Access - More

Oakland Microsoft Access Database News

Microsoft Innovation Challenger Unconference - Winter Edition

Thu, 6 December 2018
8:00 AM – 2:00 PM PST

This unique event will feature 40 invited business and technology leaders.

Each participant will briefly describe up to three problems from their innovation & venture efforts in the fields of ideation, participation, financing, impact to society and scaling. Once all problems have been listed, you and your peers will be asked to vote, set the agenda, form the groups and go deep on the topics ultimately chosen. Each group will have an expert facilitator, note taker, and other support. Groups will be composed of investors, corporate venture, innovators and startups to present a variety of viewpoints and approaches.

Source: Microsoft Innovation Challenger Unconference

One of the major issues blocking business growth is lack of proper internal management systems. One participant at a previous Microsoft Innovation Challener Unconference remarked, "If we could just find some way to wrap our arms around all the data we generate, we could move our business forward more rapidly. One of our biggest problems is placing all our data in one location." He went on to express his interest in new and innovative ways to control data using the new Microsoft Access, MS Azure, and SQL Server cloud and desktop applications.

Breaking down the barriers to working with business data is what we do at MS Access Solutions. Our MS Access Solutions company's principal Microsoft Access programmer, Alison Balter, wrote, "The term database mean different things to different people. For many years, in the world of xBase (dBASE, FoxPro, CA-Clipper) database was used to describe a collection of fields and records. Access refers to this type of collection as a Table. In a client/server environment, database refers to all the data, schema, indexes, rules, triggers, and stored procedures associated with a system. In Access terms, a database is a collection of all the tables, queries, forms, data access pages, reports, macros, and modules that compose a complete system." - From Mastering Microsoft Office Access 2007 Development, by author's permission.

Professional Microsoft Access programmers, like those at MS Access Solutions, know that the goal for all those lines of program code is to facilitate the best use of the data our clients are accumulating. Optimizing the future collection, storage, manipulation, visibility, and reporting of data is the primary purpose of each Microsoft Access programmer at MS Access Solutions, Oakland, California.

Our Oakland Location

Microsoft Access Version 2010 - What It Offers

Access Continues To Evolve Toward The Web

A brief look back at a major update in Microsoft Access Version 2010.

For developers and users alike, the Microsoft Access 2010 upgrade was highly significant.The 2010 version made Access table creation feature much easier. Also, it became easier to create a database or multiple databases. 2010 provided more advanced tools for creating forms and generating reports. The look and feel became much more like the Windows user interface. It supported the codeless apps design, plus a web publishing feature.

For the first time, with Access 2010, the software featured add-in templates that contained a number of basic tables, as well as forms, queries, macros and reports, and all important relationships. 2010 templates contained all the necessary building blocks for creating a full fleged application. For enabling rapid application development, Access 2010 templates included: asset management, inventory finance, sales and marketing, non-profit, training, and time and billing templates. The 2010 template databases allowed for easy customization for more customized business applications.

Microsoft Access 2010 shipped with modules contained within the "Application Parts" providing for rapid developement for specialized database appplications. MS Access 2010 introduced the "Office Themes" feature, so developers to format and consolidate more than one database immediately. Microsoft Access 2010 introduced the Backstage view to replace the outmoded legacy File menu. The Backstage feature is now part of the the "Microsoft Office Fluent" interface. The Office Fluent interface provided improved management for MS Acccess 2010 databases with a more common and expandable management area.

The Microsoft Access 2010 also featured an upgrade that included IntelliSensefor the Microsoft Expression Builder. This dramatcially improved the formula and expression development process. Access 2010 improved the Macro Designer by simplifying the process of macro builder with additional logic feature. Access 2010 introduced the Web definition file, now deprecated, that providded for the connection of Web services as another data source. SharePoint Server 2010 with Access Services allowed for developers to make connections and then edit a Microsoft Access 2010 database from browsers.

Microsoft Access 2010 came with many new and exciting innovations. Many are still in use, however the Web services are no longer supported in MS Access. As Microsoft Access programmers and Microsoft database consultants, we are always eager for new features that make our efforts easier. Microsoft has, occassionally introduced sweeping updates that ramp up the learning curve. However, at MS Access Solutions, we continue to adapt and implement many of the advanced features in Microsoft Access.

Microsoft Access - Macros Or VBA?

Should I use macros or should I use VBA code? The decision to use macros, VBA, or both depends primarily on how you plan to deploy or distribute the database. For example, if the database is stored on your computer and you are the sole user, and if you are comfortable using VBA code, you might decide to use VBA to perform most of your programming tasks. However, if you intend to share your database with other people by locating it on a file server, you might want to avoid using VBA for security considerations.

You should base your decision to use either macros or VBA code on two concerns: security and the functionality that you want. Security is an issue because VBA can be used to create code that either compromises the security of your data or can harm files on your computer. When you use a database that was created by someone other than yourself, you should enable VBA code only if you know the database comes from a trustworthy source. When you create a database that will be used by other people, you should try to avoid including programming tools that require the use to specifically grant trusted status to the database. General techniques for avoiding the need for users to trust your database come later in this section.

To help ensure the security of your database, you should try to use macros when you can and use VBA programming only for operations that cannot be performed by using macro actions. Furthermore, you should try to use only macro actions that don't require granting trusted status to the database in order to run. Limiting the use of macro actions in this manner lets users to be confident that the database has no programming that could harm the data or other files on their computers.

Microsoft Access Programming - Macro Considerations

Beginning in the Access 2010 release, Access contains many new macro actions that enable you to build more powerful macros than you can build by using earlier versions of Access. For example, you can now create and use global temporary variables by using macro actions, and you can handle errors more gracefully by using new error-handling macro actions. In earlier versions of Access, these kinds of features are available only by using VBA. In addition, you can embed a macro directly into the event property of an object or control. An embedded macro becomes a part of the object or control and stays with the object or control if it is moved or copied.

Macros provide an easy way to handle many programming tasks, such as opening and closing forms and running reports. You can quickly and easily tie together the database objects (forms, reports, and so on) that you have created because there is little syntax that you must remember. The arguments for each action are displayed in the Macro Builder.

In addition to the increased security and ease of use that macros provide, you must use macros to perform the following tasks:

Assign an action or set of actions to a key. This requires creating a macro group named AutoKeys.

Carry out an action or a series of actions when a database first opens. This requires creating a macro named AutoExec.

Note: The AutoExec macro runs before any other macros or VBA code, even if you have designated a startup form in the Access Options dialog box and attached a macro or VBA code to that form's OnOpen or OnLoad event.

Microsoft Access Programming - VBA Considerations

You should use VBA programming instead of macros if you want to do any of the following:

Use built-in functions, or create your own functions. Access includes many built-in functions, such as the IPmt function, which calculates an interest payment. You can use these built-in functions to perform calculations without having to create complicated expressions. By using VBA code, you can also create your own functions either to perform calculations that exceed the capability of an expression or to replace complex expressions. In addition, you can use the functions that you create in expressions to apply a common operation to more than one object.

Create or manipulate objects. In most cases, you will find that it is easiest to create and modify an object in that object's Design view. In some situations, however, you might want to manipulate the definition of an object in code. By using VBA, you can manipulate all the objects in a database, in addition to the database itself.

Perform system-level actions. You can carry out the RunApp action in a macro to run another program (such as Microsoft Excel from within Access, but you can't use a macro to do much else outside of Access. By using VBA, you can check to see whether a file exists on the computer, use Automation or Dynamic Data Exchange (DDE) to communicate with other Microsoft Windows-based programs, such as Excel, and call functions in Windows dynamic-link libraries (DLLs).

Manipulate records one at a time. You can use VBA to step through a set of records, one record at a time, and perform an operation on each record. In contrast, macros work with entire sets of records at one time.

Source: From a Microsoft Office Support article.

NOTE: VBA is an abbreviation for Visual Basic for Applications, a Microsoft Corporation language that is used with Microsoft Office products.

At MS Access Solutions, we've been programmers several years and we prefer to use VBA code, because it gives a finer control over the application development and, ultimately a more elegant, robust, and faster performing software program. Because we have a wide variety of exeriences working with Microsoft Access, we know when to use macros and when it is preferable to use VBA.