Logo
Mail us
ben@accessdatabasetutorial.com

Category Archives: Microsoft Training

Microsoft Access Database Error 3112, Record(s) cannot be read!


Microsoft Access Database

Who says software is perfect? Microsoft Access database is no different and can suffer to either poor programming or bad computer memory, cluster blockages or fragmentation build up. One common error code seen (but not often arises) in your MS Access is “Error 3112” with a supporting message implying records cannot be read; no read permission for a particular table or even a system table (which is normally hidden). So, when working on your Microsoft Access database and opening either […]

Tags: , , , ,

Designing A Query in Access 2017 – Part 1


The true strength of a relational database lies in its capability to instantaneously fetch and analyse your data by running a query. Queries enable you to pull data from one or multiple tables based on a set of search conditions you define. This tutorial will teach you how to make a basic one-table query. Then you will figure out how to plan and run a slightly complex multi-table query. What are ms access query ? Queries are a method to search […]

Tags: , , , , ,

Building Your First Access Database with Microsoft- Part-1


Access Database

If you possess a version of Microsoft Office that incorporates Access (Office Professional 2016 is the latest version), yet you have never used it, you are neglecting an effective tool for organizing and analysing business data. Working with simple lists does not require you to use Access database— you can do it with Excel. Microsoft Excel is a spreadsheet which offers fundamental tools for such tasks as sorting, filtering, and computing values. If you are working with complex data, Microsoft […]

Tags: , , , , , , , , , ,

Working with ms access tables


ms access tables

Like in other database application tables are the building block of any ms access database. These tips will be on how to create ms access tables and enter data in the database that is stored in your tables. Tables are the only place you can store data in ms access databases. What is a table in ms access? The table is set of columns and rows. Columns in ms access tables are called fields. When working with a table, every […]

Tags: , , , , , , , ,

4 Reasons Why It Is Good For Your Business- Microsoft Access Database


Microsoft Access

Here’s an article recently published about Microsoft Access databases called 4 Reasons Why MS Access Is Good For Your Business which highlights the key reasons well. The four bullet point reasons from the article are: You Probably Already Have A Copy Of It It’s Fully Integrated With Other Office Apps  It’s Highly Versatile & Constantly Improving It’s Scalable For Future Expansion Also take a look at an older article of mine expanding on the benefits of Microsoft access making it a perfect match for […]

Tags: , , , ,

Using Table and Query Naming Conventions : Microsoft Access Database


ms access

MS Access Database: Using Table and Query Naming Conventions. As part of the good working practices and disciplines when designing your Microsoft Access database, using good naming conventions will be essential as not all parts of the Microsoft Access application is consistent. Take a look at this quick video tutorial (about two and half minutes)… As clearly explained, not all aspects of the MS Access application provides a way to easily see what type of object you could be managing […]

Tags: , , , ,