Microsoft Access
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Microsoft Access as PDF for free.
More details
- Words: 299
- Pages: 1
Microsoft Access Microsoft Access: Microsoft Access is database management software where the information is stored. It includes tables, queries, forms, reports and other components, all of which allow us to manipulate and view the database information in a variety of ways.
Steps for Creating Database: 1. 2. 3. 4. 5. 6. 7.
Identify the information to be stored. Identify and create tables to hold the information. Define a primary key for each table. Join the tables using a common field. Create forms, if required for data entry. Create queries (Optional) for quickly searching information. Create reports, if required.
Table: Table is the most basic components of a database. This is a collection of information stored in records (rows) and fields (columns). Almost every table has a primary key for the purpose of identifies the records in the table and helps in creating relationships. This primary key is defined for joined the common fields among the tables.
Query: A query is the fastest way to get information from a database. You use queries to view, change, and analyze data in different ways. You can use them as the source of records for forms and reports.
Input Masks: Input mask is a series of special characters that establish the pattern for the field entries. They save the trouble of entering certain characters like hyphens etc. The input mask is used to ensure that data is entered in the right format. For Example you use the mask AB00000, the letters AB will appear on the screen and the user must entered 5 digits.
Validation Rule: Validating rules can be put to specify requirements for data entered in a record or a field.
Primary Key: Primary key is used to maintain the order of records. They are used to uniquely identify the records.
Steps for Creating Database: 1. 2. 3. 4. 5. 6. 7.
Identify the information to be stored. Identify and create tables to hold the information. Define a primary key for each table. Join the tables using a common field. Create forms, if required for data entry. Create queries (Optional) for quickly searching information. Create reports, if required.
Table: Table is the most basic components of a database. This is a collection of information stored in records (rows) and fields (columns). Almost every table has a primary key for the purpose of identifies the records in the table and helps in creating relationships. This primary key is defined for joined the common fields among the tables.
Query: A query is the fastest way to get information from a database. You use queries to view, change, and analyze data in different ways. You can use them as the source of records for forms and reports.
Input Masks: Input mask is a series of special characters that establish the pattern for the field entries. They save the trouble of entering certain characters like hyphens etc. The input mask is used to ensure that data is entered in the right format. For Example you use the mask AB00000, the letters AB will appear on the screen and the user must entered 5 digits.
Validation Rule: Validating rules can be put to specify requirements for data entered in a record or a field.
Primary Key: Primary key is used to maintain the order of records. They are used to uniquely identify the records.
Related Documents
Microsoft Access
October 2019 17
Microsoft Access
May 2020 12
Microsoft Access
December 2019 17
Microsoft Access
June 2020 11
Microsoft Access
July 2020 12