fbpx
Logo

Category Archives: Microsoft Training

Microsoft Access Training: Building Access Label Reports


Microsoft Access Training

Continuing with the Microsoft Access training series, building Access label reports is pretty straight forward (especially with the built-in wizard tool). As a snapshot and quick peek into my Access database eBook, here’s some more information to help establish your options. This type of report can be used for printing label address information to fit a pre-defined or custom defined label sheet (normally an adhesive or plain paper sheet). It can be based on a Table, Query or another external data […]

Tags: , , ,

Microsoft Access Training: How To Use the “AllowByPassKey” Using VBA Code


Microsoft access training

As part of the Microsoft Access training used to teach VBA programmers, the “AllowByPassKey” became handy and a good example why you would consider using VBA code for your database. For a distributed application, you will invariably have what is known as ‘Startup‘ switched on and enabled which means that when users start an Access database file it will take you to some sort of starting screen (an Access form) which would be a welcome or main-menu screen. In a […]

Tags: , , ,

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