Posted: April 20th, 2022
Query the database to retrieve the following information:
In MS Access I have a database of 5000 companies. I need you to create a GUI to make queries.
Query the database to retrieve the following information:
Companies with the same type of business
Companies in the same region (use post codes for this query)
Companies with similar names (report their company numbers and post codes)
Companies which were created in the last 5 years
Companies which are based in London and no longer active
Companies created before 01/01/1970 which are still active
The longest existing Active company in your database.
All public limited companies.
Select companies involved in computing business.
———-
I have a database of 5000 companies in MS Access. I need you to create a graphical user interface for querying.
Query the database to obtain the following data:
Companies that operate in the same industry
Businesses in the same region (use post codes for this query)
Companies with the same name (report their company numbers and post codes)
Companies founded within the last five years
Companies based in London that are no longer in operation
Companies founded before January 1, 1970 that are still in operation
The Active company with the longest history in your database.
Every public limited company.
Choose companies involved in the computing industry.