Category: DBMS

Database Management Systems

What is an OODBMS?

Posted on by Ian

OODBMS stands for Object-Oriented Database Management System.

An object-oriented database management system (also known simply as an object database) is a DBMS where data is represented in the form of objects, as used in object-oriented programming.

In contrast to relational database management systems (RDBMSs), where data is stored in tables with rows and columns, an object-oriented database stores complex data and relationships between data directly, without mapping to relational rows and columns.

Continue reading →

What is a DBMS?

Posted on by Ian

DBMS stands for Database Management System.

A database management system is an application that enables the creation and administration of databases. Database management system is a broad term that includes any system that performs that function.

The most common type of DBMS is an RDBMS (Relational Database Management System). RDBMSs allow you to create relational databases – databases that have multiple tables that contain related data.

Continue reading →

What is the Input Mask Wizard in Microsoft Access?

Posted on by Ian

The Input Mask Wizard is a feature of Microsoft Access that helps you create an input mask.

An input mask allows you to specify exactly how data should be entered into the database. It’s an expression that specifies certain rules about how the data should be formatted as it is entered into the system.

Here’s an example of an input mask:

(999) 000-0000

This specifies the format that a phone number must be entered. The number 9 indicates an optional character. The number 0 specifies a mandatory one. So in this example, the area code is optional.

Continue reading →