yes it will best suit but only on the latest version of ms access.
In an Access database, a query serves as the database object that allows you to locate multiple records matching specified criteria. By defining specific conditions, users can filter and retrieve relevant data from one or more tables efficiently. Queries can be created using SQL or through the Access query design interface, making it a versatile tool for data analysis and reporting.
A record is a single row of data within a database that contains information about a specific entity. A database is a collection of records organized in a structured format that allows for storage, retrieval, and manipulation of data. In other words, a database is like a container that holds records.
It depends how much space you have left on your server; the more space you have, the more records it can hold.
A table consists of two or more records.
The IEEE Xplore database actually contains more than two million records. IEEE stands for The Institute of Electrical and Electronic Engineers, therefore the types of records held in the database are concerning computer science, electrical engineering and electronics.
You are querying the database.
When querying a database, you can create an index on a specific column that satisfies the qualification. This index allows the database to quickly locate and access only the records that meet the qualification, improving query performance by minimizing the number of records that need to be scanned. This can help reduce the amount of data that needs to be processed, resulting in faster and more efficient query execution.
A database is a list of records, each record contains the same information in the same format as every other record. Using a database enables the user to find one or more records quickly and efficently, and to perform some calculations on the information stored.
a record is something that you hold data on one specific field consisting of more and you can have as much records you want
As you are likely to do a lot of manipulation of the data and much of it won't be numeric, then a database is better. Excel can do some database work, as it has facilities in it to do so, but Access can do much more in terms of a database. So a database like Access would be better for what you want to do.
A user database is a system that more than 1 person can access and gain information from. Multiple users can input and store data in these database systems.
Microsoft Office Access uses a database type known as the Microsoft Jet Database Engine. You can learn more about Microsoft Access online from the Wikipedia.