MICROSOFT ACCESS

WEEK 9

During our class in week 9 we learn about Database for our theoretical and for practical class we learn about Microsoft Access. Firstly, Database is a collection of data organized in a manner that allows access, retrieval and use of that data and data that has been processed called information. There are levels to organized data in database, the lowest level is character, then we will create a field and base on this field we will install it in a file.

Next, a record is a group of related fields normally each file must have a primary key which is a field that uniquely identifies each record. The most important thing when we create a database is file maintenance and it is including process like adding records, modifying records and deleting records. We also learn what is validation which is means compares data with a set of rules or values to find out if the data meets certain criteria. Validation can also be used to validate the data to make sure it is accurate. 

After, we were done exploring a lot about Database, we learn how to use Microsoft Access. Microsoft Access is a database management system from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. It is a member of the Microsoft 365 suite for applications, included in the professional and higher editions or sold separately. During our class in this week , we just learn what is Microsoft Access and learn how to use its features in it like how to create a table, a form and more. 

A short video from Youtube about what is access.