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 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.
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.
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.
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.
Microsoft Access front-end and SQL Server back-end database
Access Forms Development
Access data entry form connecting to SQL Server back-end database
ASP.NET website with SQL Server back-end database
MS Access Report created with SQL Server database
Client Comments About Our Work
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
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
When you need a truly expert Microsoft Access database development company to design and develop your mission critical
custom database - Contact MS Access Solutions.
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.
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.
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.
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.
NOTE: VBA is an abbreviation for Visual Basic for Applications, a Microsoft Corporation language that is used with Microsoft
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.