Posts

Microsoft Access-Forms And Reports

OVERVIEW Access Forms creates the user interface to your table. Although you can use Datasheet to perform many of the same functions as forms. Forms are used as an alternative way to enter data into a database table. It provides a different way of viewing table data. Access enables us to create forms that can be used to enter, maintain, view, and print data.               The Form is constructed from a collection of individual design elements called controls or control objects. Control are the components we see in the windows dialog boxes of the access and other windows applications like buttons, check boxes etc. We use text boxes to enter and edit data, labels to hold field names and object frame to display graphics.               A Form Wizard is provided to assist you in the construction of forms. Four types of forms can be created. These include single-column ( displaying one record at a time in a vertical format ) , tabular ( displaying multiple records in a row-and-col

Introduction To Microsoft Access

Image
OVERVIEW: Microsoft Access is one of the most popular and powerful DBMS. It has many built in features to assist you in constructing database and viewing information. MS-Access is much more involved and is a more genuine DBMS than other programs such as Microsoft Works. Microsoft Access is a Relational Database Management System (RDBMS) that you can use to store and manipulate large amount of information. It is easy to understand and its graphical interface helps to create queries, forms, and reports. In other words, even inexperienced programmers can use Access to turn a stack of invoices database that makes entering, updating, and reporting information as easy as clicking a button. MS-Access offers more than just pretty interface for learning how to manage data. You'll find following benefits and more from using Access: Sample database: It includes sample database applications to assist you learn about real-world tables, forms, queries, and reports, and how they are inte

Data Integrity And Normalization

OVERVIEW: Data Integrity: Database integrity refers to the correctness and consistency of data. It is another form of database protection. While it is related to security and precision, it has some broader implications as well. Security involves protecting the data from unauthorized operations, while integrity is concerned with the quality of data itself. Integrity is usually expressed in terms of certain constraints which are the consistency rules that the database is not permitted to violate. Following two are the most important constraints in relational database: (i)       Entity Integrity: is a constraint on primary values that states that no attribute of a primary key            should contain nulls. (ii)      Referential integrity: is a constraints on foreign key values that states that if a foreign key                  exist in a relation, then either the foreign key value must match the primary key value of some            tuple in its home relation or the foreign k

Data Base Design Process

OVERVIEW: Before we design a database for any organization, we have to consider many aspects to find out the practical scenario of owning a database. Few of them are discussed as follows: Feasibility Study: This is also called preliminary investigation of the required database. It involves the area identification and selection. i.e. which area or aspect is to be selected to start with. After the project is selected, it is allocated a specific fund and a proper planning is chalked out for its practical implementation. Side by side, a proper market analysis is also worked out. Requirements Analysis: During this activity, the requirements are gathered i.e. the possible inputs for the database and the required functionality out of it. The users precisely narrate their needs of the database and the possible domain and restrictions are also chalked out. Project Planning: A proper schedule is laid down to accomplish this activity. All the cost factors are taken into consideration i.e.

Basic Concept And Terminology Of DataBases

OVERVIEW: In the previous data basic I have discussed Files and Reports in detail. In fact, the concept of databases evolved from the old, traditional working of File Management System (FMS).

Table And Query

Image
Overview: In a relational database the data is stored in tables. The table is the fundamental concept of relational databases. It is also called relation. It is the foundation of every Relational Database Management System is a object called table.           Tables are grids that store information in a database similar to the way an Excel worksheet stores information in a workbook. Access provides three ways to create a table for which there are icons in the Database Window. Double-click on any of the icons to create a able.           Every database consists of one or more tables which store data. Each table has its own unique name and consists of columns and rows. It is a very convenient way to store information.           The columns in a table (also called table fields) have their own unique  names and have a pre-defined data type. The field can be a primary key, an index defined on i and i can have certain default value.           The able columns describe he data types,

VLOOKUP

Hi I am Safeer! I am student. Safeermughal779@gmail.com This is my email.you can connect with me with this email. V LOOKUP:               V LOOKUP in excel is useful for looking for specific information in your worksheet. The value you want to lookup also called the lookup value . The range where the lookup value is located. Remember that lookup value Should always be in first column in the range for  v lookup to work correctly. For example, if your lookup value is in cell C2 then your range should start with C.  USE  OF  V LOOKUP  FORMULA:               Use lookup when lookup values are located in the first column of a table with information organized vertically. Use H LOOKUP when lookup values are located in the first row of the table, and each "record" appears in the new column. Range-lookup controls weather values need to match exactly or not. How to use V LOOKUP Function in Excel:      V LOOKUP is one of the excel most useful func