Data modeling is a process used to define and analyze data requirements needed to support the processes within the scope of corresponding information system in an organization.
Creating simple data mode
Microsoft Access offers one table, queries, forms, reports, macros and modules and these will be created before creating a data model.
Table: All data are stored in table i.e. MS. Access stores data in tables and can exist as a simple file that allows basic data as a single file that allows basic data storage and retrieval.
Query: This is used to add, change, delete or update data in database. It enables one to find or operate on the data in the tables.
Forms: These are screens used for displaying data. It is a screen that displays the output of data.
Reports: This is used for outputting of data. It is a screen that displays the output of data.
Pages: This is used to enter or display data online.