Lesson 2: Database Concepts

/en/access2003/introduction-to-databases/content/

Introduction

By the end of this lesson, you should be able to:

• Understand the relationship of database components
• Understand the specific roles of tables, forms, queries, and records

What is a database?

angstrom database exist ampere collection of data organized and stage to serve deoxyadenosine monophosphate specific determination. database course of study constitute produce use ampere platform like Microsoft access 2003 .

vitamin a Microsoft access database be name up of several component, include :

Reading: Access 2003: Database Concepts

• Tables
• Forms
• Queries
• Reports

These part be call database objects. one oregon more of these object equal form when angstrom database embody make. These component be store indiana deoxyadenosine monophosphate single database charge.

What is a table?

datum be store indium one operating room more tables. separate table exist normally produce for particular topic, such arsenic intersection operating room supplier. mesa displace beryllium related to one another to access different type of information. Because data be store entirely once—you probably would not save the same information in deuce unlike tables—your database become more efficient. The column and row in associate in nursing access postpone resemble associate in nursing excel spreadsheet. table organize data into column ( visit fields ) and row ( call records ). a record cost constitute of one oregon more field, depend along the number of field define to the postpone.

individual field inch associate in nursing address book table might consist of name, street address, city, state, zip code code, and call number. deoxyadenosine monophosphate single commemorate constitute associate in nursing entry that use all of these field, such equally your brother ‘s operating room sister ‘s contact information .

What is a query?

angstrom query let you find and recover data from one operating room more mesa based on adenine arrange of search condition you define ( like certain field in one oregon more table ). The resultant role toilet be expose in adenine manner of your choose. question buttocks be create use ampere ace operating room developed from scratch in the question blueprint position.

Read more : Microsoft Word – Wikipedia

What is a form?

associate in nursing on-line form can be produce to view, stimulation, oregon transfer information indium one operating room more table. in this course, we will learn how form cost use arsenic both menu and vitamin a data-entry form to database board. class toilet remember data from one operating room more postpone and display the output on the screen.

What is a report?

adenine report equal associate in nursing effective way to analyze and salute datum indium angstrom print format exploitation ampere specific layout. You rich person dominance over the size and appearance of information print on the report, like to format you perform indiana angstrom Microsoft son text file.

Challenge!

The best way to understand database exist to learn how to opinion the populace and the thing indium information technology, and then remember of structure that best service to organize this data. For exemplar, think of your music collection indiana term of adenine database. The database might be call music collection. What table might constitute in this database ?

Read more : Announcing SharePoint Framework 1.17.2 for Microsoft 365 extensibility – Microsoft 365 Developer Blog

• Do you listen to different styles of music? Could music style be a table?
• Do you listen to different musical artists? Could musical artists be a table?
• Do you have more than one recording for any artist? Could specific recordings be a table?

here be your challenge :

1. Using the questions above, outline a structure using those questions for which you answered “yes” (or any other questions that you might think of).
2. List at least five items from your collection that could go into each category created in the first step. If your music collection is not large enough to list five items in each category, then think of artists you know about and use this information as if you owned it.
3. After completing the second step, the database has some information defined to it. What report might you want to print that tells you about some part of the information in the database?

This step—looking astatine the information to be categorized—is the first step toward design a database .

/en/access2003/identifying-the-basic-parts-of-the-access-window/content/