Microsoft Access Programmer
Services In Baltimore, MD

25+ years experience as a leader in Access Database Programmer
Services including: Custom Database Development, Version
Upgrades, Excel Migration, SQL Server, ASP.NET, and Azure SQL

Don't let a broken database ruin your business. We repair broken databases, program
custom Microsoft Access databases, convert Excel to Access, and upgrade old Access
databases to the latest version. Call (323) 285-0939 now for a FREE consultation.

Our Services    Get In Touch

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. Find out more about Microsort Access programming at our Access Tech Talk section. We are a Microsoft Access developer company creating database applications for your business.

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.

Read More
Microsoft Access developer and MS Access development company Baltimore MD

Microsoft Database Applications For You

Get Microsoft Access + SQL Server

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 programmer team will create your Microsoft Access database for optimum efficiency with all the features you need. Our custom database applications use MS Access and SQL Server to create an easy to use front end User Interface in Access that connects to a powerful SQL Server data storage 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.

ASP.NET For Web Display

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.

Read More

Example Projects

Microsoft Access database developer services from MS Access developer company and MS Access consultant

Corporate Database

Microsoft Access front-end and SQL Server back-end database
Best Microsoft Access database developer in Baltimore MD is MS Access Solutions

Access Forms Development

Access data entry form connecting to SQL Server back-end database
ASP.NET web development Baltimore MD MS Access Solutions company

Accounting Company

ASP.NET website with SQL Server back-end database
Microsoft Access reports development for Baltimore MD client by MS Access Solutions

Corporate Reports

MS Access Report created with SQL Server database

Clients Love Our Work

Best Microsoft Access database developer services in Baltimore MD 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 Baltimore MD 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.
  • Corporate Office Los Angeles, California
  • Phone: +1 (323) 285-0939
  • Office Hours: Mon - Fri : 8:00 AM to 5:00 PM

Get In Touch

Microsoft Access Articles

Microsoft Access Tech Talk

Update History For Microsoft Access

Microsoft Access Historical Updates

Call MS Access Solutions at (323)285-0939 For Complimentary Consultation

The material below originally appeared in Alison Balter's book Mastering Microsoft Office Access 2007 Development. and is reprinted here with the author's permission. There may be references to "Figures" or "Chapters"that are not reprintable and are not used on this page.

A Bit Of History - The Microsoft Access 2007 Updates

Microsoft celebrated the fifteenth anniversary of Microsoft Access by releasing Version 2007. As one of the major updates, Microsoft separated out each type of view as an additional property for the form. Allow Form View specifies whether the user is permitted to switch to the Form view of a form.

  • Allow Datasheet View: Determines whether the user is permitted to switch to the Datasheet view of a form.

  • Allow PivotTable View: Determines whether the user is allowed to switch to the PivotTable view of a form.

  • Allow PivotChart View: Determines whether the user is allowed to switch to the PivotChart view of a form.

  • Allow Layout View: Determines whether the user is allowed to switch to the Layout view of a form.

  • Picture, Picture Type, Picture Size Mode, Picture Alignment, and Picture Tiling: The Picture properties let you select and customize the attributes of a bitmap used as the background for a form.

  • Width: Used to specify the form's width. This option is most often set graphically by clicking and dragging to select an appropriate size for the form. You might want to set this property manually when you want more than one form to be the same size.

  • Auto Center: Specifies whether you want the form to automatically be centered within the Application window whenever it's opened.

  • Auto Resize: Determines whether the form is automatically sized to display a complete record.

  • Fit to Screen: Determines whether Access reduces the width of the form to the width of the screen.

  • Border Style: The Border Style property is far more powerful than its name implies. The options for the Border Style property are None, Thin, Sizable, and Dialog. The border style is often set to None for splash screens, which means the form has no border. A Thin border is not resizable; the Size command isn't available in the Control menu. This setting is a good choice for pop-up forms, which remain on top even when other forms are given the focus. A Sizable border is standard for most forms. It includes all the standard options in the Control menu. A Dialog border looks like a Thin border. A form with a border style of Dialog can't be maximized, minimized, or resized. After the border style of a form is set to Dialog, the Maximize, Minimize, and Resize options aren't available in the form's Control menu. The Dialog border is often used along with the Pop Up and Modal properties to create custom dialog boxes.

  • Record Selectors: Determines whether the record selectors appear. A record selector is the gray bar to the left of a record in Form view, or the gray box to the left of each record in Datasheet view. It's used to select a record to be copied or deleted. If you give the user a custom menu, you can opt to remove the record selector to make sure the user copies or deletes records using only the features specifically built in to your application.

  • Navigation Buttons: Determines whether the navigation buttons are visible. Navigation buttons are the controls that appear at the bottom of a form; they allow the user to move from record to record within the form. You should set this property to No for any dialog forms. You might want to set it to No for data entry forms, too, and add your own ribbon that enhances or limits the standard buttons' functionality. For example, in a client/server environment, you might not want to give users the capability to move to the first or last record because that type of record movement can be inefficient in a client/server architecture.

Author Attribution

The preceding material originally appeared in Alison Balter's book Mastering Microsoft Office Access 2007 Development and is reprinted here with the author's permission.

Expert Microsoft Access Programmer In Baltimore, MD

Do you need an expert Microsoft Access programmer for your Baltimore, Maryland business database? If the answer is "YES" then call MS Access Solutions at (323)285-0939. With over 25 years as full-time Microsoft Access programmers, we've developed database applications for a wide range of market sectors, including medical clinics and hospitals, government agencies, U.S. military, school districts, junior colleges, and universities, landscaping and agriculture, human resources departments and head-hunter companies, and insurance companies. Our expertise covers advanced Microsoft Access and SQL Server database programming, tailored to meet your business needs.

Microsoft Access Services

We also provide the following services:

  • Repair broken forms and optimize user interface
  • Fix malfunctioning reports and enhance data presentation
  • Troubleshoot complex queries and improve performance
  • Create and correct automated macros
  • Debug Visual Basic for Applications (VBA) code
  • Design custom database solutions tailored to business requirements
  • Migrate legacy Access databases to modern formats
  • Implement data validation rules and integrity checks
  • Create automated reporting systems
  • Develop custom user interfaces for simplified data entry
  • Build advanced search functionality
  • Integrate external data sources

Find out more about our programming services on the Microsoft Access Programmer Detroit, Michigan web page.

Microsoft Access 2024 Update

Access 2024 Improvements That Matter To Developers And Businesses

Large Address Aware support in the 32-bit edition raises available memory from 2 GB to 4 GB when running on 64-bit Windows, which reduces out of memory errors during imports, long reports, and complex joins. This is a practical gain for teams that still deploy 32-bit Office because of add-ins or legacy systems.

Code signing is now available directly in the VBA editor, through Tools, Digital Signature. Signed databases run under strict Trust Center settings, which helps in locked down environments where unsigned macros are blocked. Teams that publish ACCDE front ends on a schedule will find this saves time during each release.

Opening a query directly in SQL View from the Navigation Pane cuts steps during daily work. Right click a query, choose SQL View, edit the statement, and move on. You no longer need to open Datasheet or Design View first.

Designing linked tables is less intrusive. When you open a linked table in Design View, you can choose Do not show this message again, then restore confirmations later in File, Options, Client Settings.

Access raises internal limits. Open tables increase from 2,048 to 4,096, and available connections rise from 256 to 512 in Microsoft 365 builds. This gives headroom for apps with many linked sources, automation tasks, or heavy reporting windows.

Dataverse connectivity arrives as a built in connector. You can keep an Access front end and work with data that lives in the Power Platform, including scenarios tied to Teams. This opens up mixed environments where some lists and workflows sit in Dataverse while line of business forms stay in Access.

The Microsoft Edge Browser Control replaces the legacy WebBrowser engine. Forms can display modern web content, dashboards, or internal pages that require current standards.

Licensing and support planning are clearer. Office LTSC 2024, which includes Access 2024, follows a fixed lifecycle with mainstream support through October 9, 2029. That window helps IT plan deployments, pilot waves, and version pinning for regulated teams.

  • For programmers, LAA reduces memory pressure during imports and long reports, SQL View direct open shortens edits, code signing supports stricter security policies, and higher limits help with automation jobs and linked sources.
  • For companies new to Access, Dataverse links allow a first project that fits with Teams and Power Platform, while the Edge control supports modern web content inside forms without custom browser work.
  • For upgrades, plan a 64-bit or 32-bit decision early, sign code for production, review linked table counts, and confirm that users who depend on older WebBrowser controls move to the Edge control during testing.

References