My blog is about information technology and its tips and tricks. People can get information about Ms Access, MS Excel, MS Word, C Language, Turbo C++, and more things...
Basic Concept And Terminology Of DataBases
Get link
Facebook
X
Pinterest
Email
Other Apps
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).
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 verti...
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 k...
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 u...
Comments
Post a Comment