Access Database Flashcards
(14 cards)
What is Microsoft Access?
A desktop relational database management system (RDBMS) used to create, manage, and query databases.
What are tables in Access used for?
To store data in rows (records) and columns (fields).
What is a query in Access?
A way to retrieve or modify data using SQL or a design interface.
What are forms in Access?
User-friendly interfaces for entering and viewing data.
What are reports in Access?
Tools to format and present data for printing or summaries.
What are macros in Access?
Automated actions like opening forms or running queries without coding.
What is VBA in Access?
A programming language for advanced automation and customization.
What is relational data?
Data organized in related tables linked by keys (e.g., customer ID).
Name a few features of Access.
SQL support, data validation, multi-user support, and import/export tools.
Common uses for Microsoft Access?
Business management, inventory tracking, project management, CRM.
What is a database?
A structured collection of data stored electronically for easy access, management, and updating.
What are the uses of a database?
Data storage, retrieval, analysis, integrity enforcement, and collaboration.
What are the advantages of Access?
Easy to use, integrates with Microsoft Office, and fast setup.
What are the limitations of Access?
Not suited for large-scale or web-based applications.
