Microsoft Access
Relational database application
Microsoft Access is a database management application in the Microsoft Office suite.
Unlike Excel's spreadsheet grid, Access handles relational databases—tables linked by shared fields, with queries to extract and manipulate data.
It serves small businesses and departments needing structured data storage without enterprise-level database systems: We track inventory in Access.
The learning curve is steeper than other Office applications.
Office application scripting language
- macrosAutomated command sequences
- modulesSelf-contained system components
- event-drivenTriggered by occurrences
- automationSelf-operating system design
error handling · debugging · function · procedure · runtime
Recording information digitally
- subformEmbedded data-entry component
- text boxData entry rectangle
- combo boxEditable selection field
- checkboxToggleable selection indicator
list box · bound · unbound · switchboard
Database manipulation language
Flat-topped furniture pieces
- fieldsExpanses for cultivation
- recordsStored data or albums
- relationshipsLinks between individuals
- data typesClassifications for stored values
indexing · normalization · data validation · one-to-many · many-to-many
Arrangement by shared traits
- sortingArranging into sequence
- page headerText atop each sheet
- print previewOnscreen document mockup
- exportForeign-bound sale
PDF · mail merge · labels · chart · page break · expression
VBA
Office application scripting language
- macrosAutomated command sequences
- modulesSelf-contained system components
- event-drivenTriggered by occurrences
automation · error handling · debugging · function · procedure · runtime
data entry
Recording information digitally
checkbox · list box · bound · unbound · switchboard
SQL
Database manipulation language
tables
Flat-topped furniture pieces
- fieldsExpanses for cultivation
- recordsStored data or albums
- relationshipsLinks between individuals
data types · indexing · normalization · data validation · one-to-many · many-to-many
grouping
Arrangement by shared traits
- sortingArranging into sequence
- page headerText atop each sheet
- print previewOnscreen document mockup
export · PDF · mail merge · labels · chart · page break · expression
Microsoft AccessMicrosoft Excel
Tabular data calculation software
Google Sheets · spreadsheet · text editor · CSV file · notepad
Microsoft, Access, access, accessed, accessing, accessible, accessibility, inaccessible, accession