Lesson 10

This module discussed how Microsoft Access is a relational database and how to design tables so that your database is useful. The remaining information will become clearer as you work through the rest of the course. Also, consider what you need to do with Access when you are done with the course. If you are simply using a database someone else created, then most of the material in this module might not be as important for you. If you will be building databases from scratch, you might want to come back to this module when you have finished the course to see if you can absorb more information the second time around.

While Microsoft Access 365 and Microsoft SQL Server 2019 are both relational database management systems, they might not share identical relational properties due to differences in their design and intended use cases. The comparison of their relational capabilities can be approached with an understanding that each serves distinct purposes within the realm of database management.

1. Database Size and Performance: Microsoft SQL Server 2019 is typically seen as more robust and scalable, suited for handling larger databases and higher volumes of transactions. In contrast, Access 365, being more suited for smaller-scale applications, might not exhibit the same level of performance when dealing with extensive databases.
2. Complexity of Queries: SQL Server 2019 could be expected to support more complex queries and offer more advanced SQL functionality compared to Access 365. This includes support for complex joins, subqueries, and stored procedures, which are essential in large-scale and complex database operations.
3. Concurrency Control: In scenarios involving multiple users or transactions, SQL Server 2019 is likely to offer more sophisticated concurrency control mechanisms. This would help in managing simultaneous data access more efficiently than Access 365, which might be more prone to conflicts with multiple users.
4. Data Integrity and Transaction Management: SQL Server 2019 might offer more robust features for ensuring data integrity and transaction management. These include capabilities like point-in-time recovery, log shipping, and database mirroring, which are critical in enterprise environments but may not be fully supported in Access 365.
5. Security Features: Given that SQL Server is often used in larger and more security-sensitive environments, it might provide more comprehensive security features compared to Access 365. This includes advanced encryption options, more detailed access controls, and better integration with other enterprise security systems.
6. Integration and Scalability: SQL Server 2019 is likely designed with greater emphasis on integration with other enterprise systems and applications. It might also offer better scalability options, facilitating the growth of the database system in sync with organizational needs, a feature that might be more limited in Access 365.
7. Relational Capabilities: While both support the essential features of a relational database, like tables, relationships, and SQL querying, SQL Server 2019 might provide a more extensive set of tools and capabilities for complex relational database management.

In summary, although Microsoft Access 365 and SQL Server 2019 share the fundamental principles of relational databases, their specific relational properties could differ significantly. These differences are reflective of their intended usage, with SQL Server being more suitable for larger, more complex, and high-demand environments, whereas Access 365 might be more appropriate for smaller-scale applications where ease of use and simplicity are key considerations.

This module introduced you to the following terms and concepts:

1. Calculations
2. Criteria
3. Raw data
4. Related

In the next module you will get started working! You will learn how to create tables and enter and edit data.

If you have any questions click on the Search button located at the top of the page.

Try your hand at designing the tables for the course project.
Course Project Database - Exercise