Introduction to Access and the settingsoptions in Microsoft Access 2019

In this chapter, you will learn how to structure and construct adatabase design for a particular purpose. You will also learn theelements that make up the Access environment and set up optionsapplicable to database setup. We will create a new database and learnabout the different objects available on the Shutter Bar NavigationPane.

A database allows for information related to a particular purpose tobe entered and manipulated in a systematized way, so that the desiredoutput can be quickly reported and accessed. An example of databasecontent would be, for instance, a library catalog, a music or recipecollection, or student and parent information for a school environment.A database is used to store large amounts of information. Theinformation is organized in such a way that it is fast and easy toextract only the information you need. Planning is an absolutenecessity and is crucial to the success of your database.

database management system (DBMS) is a piece ofcomputer software used to manage and query a database. A databaseschema describes database objects and the relationshipspresent between objects in the database. There are numerous ways ofmodeling a database, known as database models. Therelational database model is the most common type as it characterizesall the information in table format (rows and columns) and signifiesrelationships created by values common to more than one table within thedatabase.

A database is managed from a single database file. Even though youwork with different objects (tables, queries, forms, and reports) withina database, you still work with only one file.

An example of a database program is Microsoft Access. You canrecognize an Access 2019 database file by its fileextension, .accdb:

ms office 13

Leave a Comment