Microsoft Access
by: Kyrie Senpai

Hello my fellow friends, welcome to my blog. Today, I'm going to impart my own opinion about MS Access 2010. Before I start, I would like to introduce myself. I'm Kyrie Ellieson A. Layco ; student of Villaggio Ignatius School; 15 years of age; and lastly, I'm a male.

Overview:
                Today, we're going to discuss :
                  -Benefits of MS Access 2010
                  -Elements of MS Access 2010
                  -Negative effects of Ms Access 2010; 
                  -and My Advice (regarding MS Access 2010)

1. Benefits of Ms Access 2010
      a) It can store large amount of data or information; not like paper-based database which can only hold a limited amount of data.
      b) It saves your time
      c) "Quick" and easy to create database systems.
       Microsoft Access is an excellent tool for creating bespoke systems that have a database at their heart. It includes various wizards to speed up the process of creating a database application, and a vast array of readily available functionality. For an expert programmer specialising in MS Access, we find that development time is approximately half that needed for creating the same system using a different platform. This is a huge advantage. It translates directly into a cost-saving for you and it means that turn-around times are usually a matter of a few weeks from inception through to delivery.
    d) MS Access produces flexible and adaptable database systems.
              Access really scores here. Nothing in your system need ever be written in stone! Whilst it isn't as quick to make changes as it is to create systems in the first place, it is still much quicker to amend things in Access than it is in other packages. And if you need to add new bits into your system they can often be integrated as quickly as creating something new. In practice this means that Access is perfect for the real-life business world. Things change and your system can change with them - without costing you the earth, and without long time delays.

2. Elements of Ms Access 2010
      a) Title bar - displays the name of the database and the program.
      b) Quick Access Toolbar (QAT) - Contains the frequently used commands that are independent of the tab displayed on the Ribbon.
      c) Ribbon - Consists of a set of tabs, each of which contains groups of related commands.
      d) Navigation Pane - Displays a list of all the objects in a database.
      e) Object Window - Displays open database objects.
      f) Status Bar - Displays information about the database and provides certain program  functions.

NYORN

Mga Komento

Mag-post ng isang Komento

Mga sikat na post sa blog na ito

Steps in Creating a Form in MS ACCESS

Steps in Creating a Form Ms Access Hey what's up Humanoids! Database is important nowadays and it's part of our lives now. MS Access is one of the most well-known DBMS programs that can store large amounts of data. Tables are it's basic unit next is FORMS.  So today, we're going to discuss different ways on how to create a form in MS Acces. What is a form ?       A form is an object that allows you to input, edit, or view data from/in your  database. Forms usually displays one record at a time and can be customized  based on user preference.  In a database context, a form is a window or screen that contains numerous fields, or spaces to enter data. Each field holds a field label so that any user who views the form gets an idea of its contents. A form is more user friendly than generating queries to create tables and insert data into fields. Creating Forms   1. Using Auto Forms a) Open your database. b) From the Database Window...
Magbasa nang higit pa

Proper Planning and Designing of a Database

A properly designed database provides you with access to up-to-date, accurate information. Because a correct design is essential to achieving your goals in working with a database, investing the time required to learn the principles of good design makes sense. In the end, you are much more likely to end up with a database that meets your needs and can easily accommodate change. This article provides guidelines for planning a database. You will learn how to decide what information you need, how to divide that information into the appropriate tables and columns, and how those tables relate to each other. You should read this article before you create your first database.                          What is good database design? Certain principles guide the database design process. The first principle is that duplicate information (also called redundant data) is bad, because it wastes space and increases the likelihood...
Magbasa nang higit pa