Top 60 MS Access Practical Questions For Beginners

Microsoft Access is a database program that can be used to collect and store information in a way that is easy to access.

Here are some MS Access practical questions;

1. What are the three main components of an Access database?
2. What is the difference between an Access database and a flat file?
3. How do you create an Access database?
4. What type of data can be stored in an Access database?
5. What does the default state for a new table in a table design screen look like?
6. Which tool do you use to add fields to your tables?
7. How do you delete a field from your tables?
8. How do you delete all records from a table with no data in it?
9. Which tool would you use to make changes to one or more tables while they were open on your screen?
10. What is the purpose of creating relationships between two tables in an Access database?
11. What is the function of the Filter condition in the query window?
12. How do you add a new field to a table?
13. What is an AutoFilter?
14. How do you create a calculated field for any number of values?
15. What is the purpose of a Pivot Table?
16. What is the difference between a PivotTable and PivotChart?
17. How do you display different information based on different criteria in one pivot table?
18. How do you change the ordering of items in a pivot table?
19. How do you create an interactive dashboard using Access 2013 or 2016?
20. What are three ways to edit data in a database table using Access 2013 or 2016?
21. What are some common errors that arise when creating queries?
22. In which order should tables be created in an Access database?
23. In which order should forms and queries be created?
24. What are some commonly used functions in MS Access 2010, 2013, 2016 and 2019?
25. How can you create an account in Microsoft Access?
26. What is the difference between a database and a table?
27. What is the difference between a query and a command?
28. How do you query tables in Access?
29. What are the basic steps to creating a new database from scratch and importing data from another database?
30. How do you change the name of a field or field property in Access?
31. What is the difference between AutoNumber fields and other types of fields in Access?
32. How do you insert and update records in an Access table from another database?  
33. How do you select multiple records from an Access table based on criteria such as date of birth, gender, or address?
34. What is the structure of a table in Access?
35. Name three methods to create relationships between tables in Access.
36. Describe how to create relationships between tables in Access by using forms, and queries.
37. What are two ways to perform join operations on multiple tables in Access?
38. How do you create a relationship between two tables using the Edit Relationships window?
39. What is the difference between an import and an export option for importing data from another database into Access?
40. Describe the difference between a data store and a database.
41. What are the two types of a database?
42. What is the difference between a relational database and a hierarchical database?
43. What is a record in a relational database?
44. List three different types of tables in a relational database.
45. How do you open a database?
46. What is the difference between a column and a field?
47. How do you select data from a database?
48. When should you use linked tables and when should you use multiple queries?
49. How do you create indexes in Microsoft Access?
50. How do you create a query by using the Database Wizard?
51. What is the difference between an object-oriented database and a relational database management system (RDBMS)?
52. What are the two types of queries in Microsoft Access databases?
53. Why should you not avoid using macros in your database?
54. How can I find all records that match specific criteria?
55. How can you create a chart in Access?
56. How can you import data from Excel into Access?
57. Can you password-protect databases in Access?
58. How do you extract data from tables and charts using the query design window?
59. How do you create a report in Access?

Remember

It is not enough to know all the theories. You have to be able to put that knowledge in action, or it is useless. Doing exams is important since you will be able to think out of the box and work smart.