Logo
Mail us
ben@accessdatabasetutorial.com

Category Archives: MS Access

MS Access Data Projects: 4 Guidelines to Help You Move On


With the most recent versions of Microsoft Access 2016, it no longer offers support for Access Data Project (ADP) files but for the more seasoned releases it will still continue to support ADP’s. End-users will find it imperative to learn about the alternatives they could use when planning to update the application. Before recommending any options, there are certain basics you need to understand first. Why Access is never again supporting ADP ? Microsoft Access 2016 is due SQL Azure […]

Tags: , , , , ,

Microsoft Access Database: How To Completely Remove A Database ?


Microsoft Access Database, like with many of the other Microsoft applications is very versatile and can be a valuable asset for businesses (of all scopes). However, unlike MS Word and MS Excel which are normally used in the workplace for the day to day and general running of the business work flow and then can be also used to support Microsoft Access at a level that complements other systems, Microsoft Access Database is the kind of application that takes office applications to the next level and can be used in various […]

Tags: , , , , , , ,

Why You Should Avoid Using Memo Fields for Grouping in MS Access ?


A memo field can store a huge quantity of information, allowing up to 65,536 characters, with different choices. In the most recent release of Microsoft access database, it can store up to 1 GB of characters and enables rich text formatting. However, it is often advised to avoid the use of memo fields for grouping in Access. Memo Fields In the 2009 edition of Microsoft access database and including the recent version, there was a bug in which the memo […]

Tags: , , , , ,

How to Insert Date and Time into the Header and Footer Sections of Your MS Access Report ?


image1

Microsoft Access 2016 lets users design their reports with ease and most advantageous way compared to other dedicated reporting tools. There are various formatting choices that give flexibility and make reports more efficient. Microsoft Access 2016 has a report Wizard (as a starter point) that walks you through the process of creating a report. The report look and feel will greatly depends on the user’s requirements. The more complex it gets, the higher the degree of customization is needed. The greatest strength of any report is in its structure. If the report is informative, it will surely stand out. You can improve your reports by inserting headers and footers, adding logos, and changing […]

Tags: , , , , ,

How to Back up Your Split Database in Microsoft Access ?


image about access

A split database is created by splitting two Access database files ending up with a ‘Back-End’ and ‘Front-End’ database files. A ‘Back-End’ Access database normally contains only the data tables while the ‘Front-End’ comprises the remaining database objects such as queries, forms, and reports. The data that a user inputs in a database object will be stored in the tables that back-end databases hold. Anybody can go through the information available in the front-end database but in order to access the back-end, the user needs to have administrator permission. Splitting a database can improve its performance, help secure your data, […]

Tags: , , , , , , ,

Aggregate Queries in Microsoft access database


In Microsoft access database, you might want to perform operations on not just one single record, but on a group of records. You can simply create fields that perform operations per row or on every record. But what happens when you perform calculations on a group of records? This is where Aggregate queries come in handy. Aggregate Query An Aggregate query lets you carry out calculations on record groups rather than perform individual operations, and because of that, it is also referred to as Summary query. It considers the total, subset, or gross amount of records. In performing calculations on a group […]

Tags: , , , , , , , , ,