Final answer:
Access differs from Excel primarily in that it allows the creation of multiple related tables, maintaining relational data integrity, whereas Excel is focused on spreadsheet functionality, such as performing calculations and creating charts.
Step-by-step explanation:
Microsoft Access and Microsoft Excel are both data management tools, but they serve different purposes and their functionalities reflect that. The primary difference as per the options provided in the question is that Access allows multiple tables with relationships between the tables (Option C). Unlike Excel, which is essentially a spreadsheet application designed for calculations, data analysis, and visual presentation of data via tables and charts, Access is a database management system that excels at handling structured data and allows users to design queries, forms, reports, and macros.
Access also excels at data integrity and enforcing data types and relationships, which is crucial for maintaining accuracy in records where there are dependencies between datasets. Excel, while powerful for various tasks, doesn't provide the same level of relational data integrity as Access does. Both applications have their own use cases and are part of the broader Microsoft Office Suite.