Database Glossary Terms Beginning With The Letter M
A form of programming code used in Microsoft Access. Macros have evolved in recent versions to play a larger role in the programming environment of Microsoft Access and now include embedded macros and data macros plus standalone macros that can be called from within Access. Macros are used in Excel and Access newer versions.
A query object used to create a table. A Make-Table query can get the information needed to create the table from a select query or value list.
A relational database program introduced in 1991. Now the largest selling database program in the world.
Multiple records in one table can have many related records in a second table, and at the same time, multiple records in the second table can be related to many records in the first table. In a relational database, a many-to-many relationship requires a third table, called a junction table. The junction table will have a one-to-many relationship with each of the original tables.
modeling (in database context)
The act of creating the tables, fields and relationships in a database to address a specific purpose.