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 Fresno, 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 Fresno, 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 Fresno 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 Fresno 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

Microsoft Fresno

Moving the needle on student achievement: Fresno Unified School District's personalized learning initiative

Today's students will graduate into a world that will be dramatically different – and changing faster than ever. They will enter a workforce where job functions, roles and even categories will be significantly altered, and will face social and global challenges beyond what we can imagine today.

Research recently conducted by Microsoft – "The class of 2030 and life-ready learning: The technology imperative" – concluded that student-centric approaches will be critical. Personalized learning, supported by technology, will help students develop strong social-emotional and advanced cognitive skills – both needed to be prepared for work and life.

At the heart of the Fresno story is a journey undertaken by inspired leaders and innovative teachers to unlock the limitless potential of all their students, through an intentional personalized learning initiative (PLI). They understood what needed to change to best prepare their students for the increasingly creative, collaborative, digitally-infused world they will enter as adults.

From article by By Barbara Holzapfel, in the Microsoft Education Blog, June, 2018.

Microsoft continues its work as a world leader in educational innovation. Microsoft is putting its skills as a business technology cutting edge company to work with the schools in Fresno, California. Because Microsoft is reaching out to students, it is also generating more interest in technology education, specifically computer programmer as a career. Microsoft is in constant need of software programmers, like the ones producing Microsoft Access software for database applications, database solutions, and software connectivity.

Office Mobile Apps With Microsoft Access Now Support Windows 10 Timeline

From Windows Latest, Nov, 2018

Microsoft continues to roll out new features for its Microsoft Office programs, including Microsoft Access. MS Access now comes with themes and color variations as listed below. These new features, along with improved database functionality keep Microsoft Access at the forefront of relational database management systems software

Microsoft is updating the Office Mobile apps with support for Windows 10 Timeline. It means that the Office Mobile apps (Word, PowerPoint Mobile) activities would show up in the Windows 10 Timeline screen. Office Mobile version 16002.11029.20046.0 adds support for Timeline. It's a useful feature as you can now return to editing a specific document quite easily. It’s worth noting that Office Mobile apps are available for free and you can use it to view documents or presentations but you need Office 365 subscription to edit the files.

Microsoft company is rolling also rolling out a new update to the Office desktop app for Insiders and it advances the app to Build 11029.20045. The update is available for Office 365 subscribers on Windows signed in to the Office Insider program. Microsoft earlier added people suggestions as part of the Schedule Assistant which lets users to reserve a conference room along with switching between the rooms within the apps for Outlook mail.

The latest update comes with more improvements to the Outlook email with the company now allowing the Outlook users to save zooming options. The users will now be able to choose a default zoom setting to use for all their messages. Earlier the zooming settings would reset automatically when closing the app, his will now change in the latest Office update. "Instead of adjusting Zoom each time, you read a message, choose a default setting to use for all your messages," Microsoft explains.

There are improvements pushed out to Microsoft Access with the company introducing themes. Microsoft Access now comes with support for four different themes like colorful, dark, gray and white. Microsoft will be adding more improvements to the themes in the coming updates. The latest Office updates this time doesn't come with any improvements or features for Microsoft Word, Excel and PowerPoint. These Office apps already received a lot of improvements in the previous update. For example, support for Ink to Text tool feature was added to Microsoft PowerPoint last month and it allows users to change handwritten ink to shapes or text.

Source: Windows Latest

If you've ever used Microsoft Access as a programming tool, you know that looking at the same layout format can become boring. Microsoft Access is one of the last programs in the Microsoft Office suite to get this very nice facelift. At MS Access Solutions, we program custom Microsoft Access applications that give you, our client, a very customized look and feel. We can add several visually interesting features to compliment the hard working and robust MS Access database program we develop for you. As a Microsoft Access consult in Fresno, CA we know that every database we develop requires the appearance, you, our client, needs to make this truly your company's database solution.

Microsoft Access Programming Code Creates A Fresno Map

Here's some interesting Microsoft Access VBA code example for programming a Google map.

==============
==STEP ONE==
==============

Create a new MS Access form called frmGoogleMap. Size the form to your liking...

On the blank form, go to the "Insert" menu and select "ActiveX Control..."

When the selection screen appears, choose "Microsoft Web Browser".

Once the control object has been placed on your form, resize the control object WITHOUT SAVING THE FORM. The reason for this? Once you save the form, if you want to resize after saving you have to delete the control object and re-insert a new Microsoft Web Browser ActiveX control object each time you want to resize it.
In this example, I have named the control object WebBrowser0.

I recommend inserting a command button named cmdClose for testing purposes.

Once you have the Design View finished,...

a.) Set the TimerInterval for the form to 1000
b.) Go to the View menu option.
c.) Click on Code
d.) In the Code Module for the form, insert the following code.

==========================================================

Option Compare Database

Private Sub cmdClose_Click()

Me.TimerInterval=1000
MyAssigned=False
Set objBrowser=Nothing
DoCmd.Hourglass False
DoCmd.Close acForm, "frmGoogleMap", acSaveNo

End Sub

Private Sub Form_Timer()

'Declare variables.
Dim objBrowser As Object

'Set variables.
Set objBrowser=Me.WebBrowser0

If MyAssigned=False Then
DoCmd.Hourglass True
With Me.WebBrowser0
.Navigate MyGoogleMapURL
Do Until .ReadyState <> 3
DoEvents
Loop
DoEvents
Do Until .ReadyState=4
DoEvents
Loop
DoEvents
MyAssigned=True
End With
DoCmd.Hourglass False
End If

End Sub

============================================================

Save and close the new form naming it "frmGoogleMap".

==============
==STEP TWO==
==============

Go to the Modules section of your MS Access database, and click New and insert the following code.

==========================================================
Option Compare Database

Global MyAssigned As Boolean
Global MyGoogleMapURL As String

============================================================

Save and close the new module naming it "Google Variables". At this point, I will show you how Google Maps structures the URL that retrieves a requested map.

Let's say you want to search for:

Thomas Williams
111 SW Elm Lane
Fresno, CA 93721

Or

Monica Smithers
2314 Mariposa St
Fresno, CA 93721

When you go to Google Maps at http://maps.google.com, you type in the address and Google goes to...

For Thomas Williams:
"http://maps.google.com/maps?q=111+SW+Elm+Street+Fresno+CA+93721&iwloc=A &hl=en"

For Monica Smithers:
"http://maps.google.com/maps?q=2314+Mariposa+St+Fresno+CA+93721&iwloc=A &hl=en"

Now to pass this value to your new form, set your MyGoogleMapURL
variable to the above URL and open the new form like this:

MyGoogleMapURL=
"http://maps.google.com/maps?q=111+SW+Elm+Street+Fresno+CA+93721&iwloc=A &hl=en"
DoCmd.OpenForm "frmGoogleMap", acNormal

OR

"http://maps.google.com/maps?q=2314+Mariposa+St+Fresno+CA+93721&iwloc=A &hl=en"
DoCmd.OpenForm "frmGoogleMap", acNormal

Obviously, you can parse the string value of the URL to any address of your choosing.

Programmer's Note(s) And/Or Warnings:

If you're connecting to your new Google Maps form through a Citrix connection, the opening of the Microsoft Web Browser control will crash your MS Access database. This is because Google Maps will turn your SpeedScreen setting on in Citrix, even if you have it set to Off, and the combined running of both creates a GPF error.

You CAN, however, use a standard Remote Desktop Connection(RDC) or a VNC connection with no resulting crashing of MS Access.

For additional business purposes, you can also have your MS Access application target different types of businesses nearby (Example : Schools) just by setting the URL string value to something like...

"http://maps.google.com/maps?q=schools+loc%3A+111+SWt+Elm+Street+Fresno+CA+93721&f=l&hl=en"

Or

"http://maps.google.com/maps?q=schools+loc%3A+2314+Mariposa+St+Fresno+CA+93721&f=l&hl=en"

From Microsoft Access Creating Google Maps

Whether you want a Microsoft Access VBA code to produce a Freso, California map, or some other city, this code demonstrates the flexible and innovative use of MS Access programmer coding. MS Access Solutions Fresno CA is your Microsoft Access developer, Microsoft Access programmer, and Microsoft Access consultant. When you need to find a Microsoft Access programmer near me, Call the Microsoft Access experts at (323)285-0939.

Here are just a few of the terms you can use to find our website:

Fresno Location: 2314 Mariposa St, Fresno, CA 93721, custom Microsoft Access database programmers Fresno CA, custom Microsoft Access database programmer Fresno CA, custom Microsoft Access database company Fresno CA, custom Microsoft Access database consultant Fresno CA, custom Microsoft Access database developer Fresno CA, Microsoft Access consultant Fresno CA, Microsoft Access database developer Fresno CA, Microsoft Access programmer Fresno CA, Microsoft Access developer Fresno CA, Microsoft Access database programmers Fresno CA, MS Access consultant Fresno CA, MS Access database developer Fresno CA, MS Access programmer Fresno CA, MS Access developer Fresno CA, MS Access database developer Fresno CA, Access database consultant Fresno CA, Access database developer Fresno CA, Access programmer Fresno CA, Access developer Fresno CA, Access database developer Fresno CA, Access software consultant Fresno CA, Access software developer Fresno CA, Access software programmer Fresno CA, Access software developer Fresno CA, Access database software developer Fresno CA, convert Excel to Access Fresno CA, convert Excel to Access programmer Fresno CA, convert Excel to Access programmers Fresno CA, convert Excel to Access developer Fresno CA, convert Excel to Access developers Fresno CA, convert Excel to Access consultant Fresno CA, convert Excel to Access software company Fresno CA, convert Excel to Access company Fresno CA, Microsoft Access consultant near me Fresno CA, Microsoft Access database developer near me Fresno CA, Microsoft Access programmer near me Fresno CA, Microsoft Access developer near me Fresno CA, Microsoft Access database programmers near me Fresno CA, MS Access consultant near me Fresno CA, MS Access database developer near me Fresno CA, MS Access programmer near me Fresno CA, MS Access developer near me Fresno CA, MS Access database developer near me Fresno CA, Access database consultant near me Fresno CA, Access database developer near me Fresno CA, Access programmer near me Fresno CA, Access developer near me Fresno CA, Access database developer near me Fresno CA, Access software consultant near me Fresno CA, Access software developer near me Fresno CA, Access software programmer near me Fresno CA, Access software developer near me Fresno CA, Access database software developer near me Fresno CA, Access programmers for hire Fresno CA, Microsoft Access programmers for hire Fresno CA, Microsoft Access programmers Fresno CA, MS Access programmers Fresno CA, MS Access database programmers Fresno CA, hire Microsoft Access consultant Fresno CA, hire Microsoft Access database developer Fresno CA, hire Microsoft Access programmer Fresno CA, hire Microsoft Access developer Fresno CA, hire Microsoft Access database programmers Fresno CA, hire MS Access consultant Fresno CA, hire MS Access database developer Fresno CA, hire MS Access programmer Fresno CA, hire MS Access developer Fresno CA, hire MS Access database developer Fresno CA, hire Access database consultant Fresno CA, hire Access database developer Fresno CA, hire Access programmer Fresno CA, hire Access developer Fresno CA, hire Access database developer Fresno CA, hire Access software consultant Fresno CA, hire Access software developer Fresno CA, hire Access software programmer Fresno CA, hire Access software developer Fresno CA, hire Access database software developer Fresno CA,