• About
  • Contact
  • Privacy Policy
  • Submit For Review
  • Template Gallery
  • Excel 2016 Udemy Course
  • Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

TheAppTimes

App Reviews, Tutorials, & Gadget News Hub

  • Gadgets
  • How To
  • Mobile Apps
  • Software and Web Apps
  • Buying Guides
  • Show Search
Hide Search
Home » Mobile Apps » An Overview of the Structure of an MS Access Database

An Overview of the Structure of an MS Access Database

May 3, 2013

It is always better to have a complete understanding of the architecture of any application on which you are working. The same concept applies when using Access database. To perform various tasks on your Access database file more effectively (like storing data in tables and forms, updating and finding data, deleting tables, and running queries), you need to get familiar with its architecture. The basic architecture of MS Access database comprises various objects that include tables, queries, forms, reports, and relationships among the tables. The brief explanation of these database objects and their working is explained below.

What are Access Database Objects and How they Work

Tables and relationships

an access database table

The basic component that makes up any database is tables. A table is made up of rows and columns and an intersection of a row and column is called a ‘cell’, wherein your data is stored. A row in the table contains one record of the table, whereas the column comprises the type of data that is going to be stored in each cell. For storing any kind of information, you can create a related table in your Access database. There can be various types of information, including order details, products, customer information, etc. Moreover, each and every table contains a field (like customer id) that helps to uniquely identify records in that table. By using these unique fields of different tables and defining relationships between them, you can bring the data of multiple tables altogether in a report, form, or query. In this way, you can create and maintain relationships among tables.

Queries

For extracting or finding data from the database, you need to run a query. A query comprises certain conditions that help you to extract specific data from a table. Moreover, you can apply queries for modification and deletion of data stored in database tables. You can pull out a specific piece of information from database tables using multiple conditions in queries. For example, you can apply a query in the database of a school to extract the names of those students who have secured more than 90% marks. Further, you can update the records of all the customers who have sent their requirement of the next quarter in a database of an organization that manufactures electronic equipment.

Forms

In an Access database, a form is an interface that enables users to view, change, and enter data directly in the table; however, these changes can be performed in one row at a time. You can perform other actions in your form as well, like you can send data to other applications. However, forms basically contain controls, which are linked to the underlying fields in tables. Upon opening a form, you find that Access automatically retrieves the data from one or multiple tables and displays that data in a suitable layout that you have chosen while creating the form. You can use one of the ‘Form’ commands provided on the ‘Ribbon’ to use it. Moreover, you can use the Form Wizard to create a form, or otherwise create it by yourself through the ‘Design View’.

Reports

an access customer report

For analyzing your data and presenting that in a certain way like for printing or in other formats, reports are used. You can understand it with an instance, like you can send a report to your colleagues or a friend that collects data and calculates the total. Some other uses of Access database reports are creating labels for mailing, displaying calculated totals, etc.

Hope the aforementioned descriptions about Access database architecture gives you a basic understanding of your database to optimize your experience.

Tweet
Share4
WhatsApp
Pin6
Buffer
10 Shares

Filed Under: Mobile Apps

You May Also Like

Apps for College Students - TATFI
10 Best Apps Every College Student Needs To Download
4rabet India - TATFI
Overview of the 4rabet Official Site in India
Best Sports Apps to Download in College - TATFI
8 Sports Apps to Entertain You on Campus

About Adam George

Adam Gorge is an expert handler of Access Database errors, Access database corruption issues etc. He has written many articles on Third Party Access Database Repair Software, Access database corruption issues, Compact/repair utility etc. You can contact him at adam.gorge507@gmail.com

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

Hottest New Gadgets!

Amazfit Band 7 - TATFI

Keep Track of Your Physical Activity with Amazfit Band 7 (Just $50)

Best Wireless Headphones to Buy in 2022 - TATFI

The Best Wireless Headphones to Buy in 2022

HyperX DuoCast USB Microphone - TATFI

Need New Microphones? Take a Look at the Fabulous HyperX DuoCast USB Microphone

Xiaomi Smart Band 7 - TATFI

Xiaomi Smart Band 7 Launches with Always On Display in 6 New Colors

ECOLOR Smart Table Lamp - TATFI

ECOLOR Smart Table Lamp  – A Cool Multifunctional Lamp with Touch Features

Popular Tags

android android apps android games android how to apple casino games chrome extensions excel excel how to facebook gaming gmail google instagram ios apps ios games ios how to ios tips ipad iphone kids apps learn excel management microsoft music apps new releases outlook how to photo apps powerpoint powerpoint how to productivity Samsung security smartphone smartphones software tablet tablets technology twitter web browsers windows 10 word how to xbox youtube

Disclosure

TheAppTimes is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for us to earn fees by linking to Amazon.com and affiliated sites.

TheAppTimes © 2022 // Runs on StudioPress