| About database & Microsoft Access |
|
Database: A database is a collection of information that's related to a particular subject or purpose, such as tracking customer orders or maintaining a music collection. If your database isn't stored on a computer, or only parts of it are, you may be tracking information from a variety of sources that you have to coordinate and organize yourself.
For example, suppose the phone numbers of your suppliers are stored in various locations: in a card file containing supplier phone numbers, in product information files in a file cabinet, and in a spreadsheet containing order information. If a supplier's phone number changes, you might have to update that information in all three places. In a database, however, you only have to update that information in one place — the supplier's phone number is automatically updated wherever you use it in the database.
Applications:
- Banking: all transactions
- Airlines: reservations, schedules
- Universities: registration, grades
- Sales: customers, products, purchases
- Manufacturing: production, inventory, orders, supply chain
- Human resources: employee records, salaries, tax deductions
- Databases touch all aspects of our lives
Microsoft Access: Access is a database application software. It is a semi RDBMS (Relational Database Management System) which is used for data processing. This Software is created by – Microsoft Corporation which is situated at California in U.S.A.
We can create customized Table, Query, Form, Report, Macro, and Page and so on with MS Access, easily.
Microsoft Access Database: A collection of data and objects (such as tables, queries, or forms) that is related to a particular topic or purpose. The Microsoft Jet database engine manages the data.
| Database Objects in Microsoft Access 2003: |
|
Database Objects in Microsoft Access: An Access database contains objects such as tables, queries, reports, pages, macros, and modules.
Tables: A database consists of one or more tables. A table is a collection of data, arranged in rows and columns. For example, you might have a table for author information called authors. Each column would contain a certain type of information, such as the author’s last name. Each row would contain all the information about a specific author: first name, last name, address, and so on.
Queries: To find and retrieve just the data that meets conditions that you specify, including data from multiple tables, create a query. A query can also update or delete multiple records at the same time, and perform predefined or custom calculations on your data.
Forms: To easily view, enter, and change data directly in a table, create a form. When you open a form, Microsoft Access retrieves the data from one or more tables, and displays it on the screen with the layout you choose in the Form Wizard or with the layout that you created on your own in Design view. You can also use a form as a switchboard that opens other forms and reports in the database, or as a custom dialog box that accepts user input and carries out an action based on the input.
Reports: A report is an effective way to present your data in a printed format. Because you have control over the size and appearance of everything on a report, you can display the information the way you want to see it.
Data Access Pages: A data access page is a special type of Web page designed for viewing and working with data from the Internet or an intranet— data that is stored in a Microsoft Access database or a Microsoft SQL Server database. The data access page may also include data from other sources, such as Microsoft Excel.
Macros: A macro is a set of one or more actions that each performs a particular operation, such as opening a form or printing a report. Macros can help you to automate common tasks. For example, you can run a macro that prints a report when a user clicks a command button.
Modules: A module is essentially a collection of declarations, statements, and procedures stored together as one named unit to organize your Microsoft Visual Basic code. Microsoft Access has two types of modules: standard modules and class modules.
Information: The term information is used for meaningful or processed data. “Putul’s age is 28 and her gender is female” is information.
Table: A table is a collection of data about a specific topic, such as products or suppliers. Using a separate table for each topic means that you store that data only once. This results in a more efficient database and fewer data-entry errors.
Field: An element of a table that contains a specific item of information, such as a ‘Mem_Name’ is called field. A Title field might contain Mr. or Ms. Database such as Microsoft SQL Server refers to fields as columns.
Column: A vertical space in a database table that represents a particular domain of data is called column. A column has a column name and a specific data type.
Record: A collection of column information corresponding to a single row is called record.
Tuple: A collection of column information corresponding to all rows is called tuple.
Data: Data are simply values of sets of values. Data may be numeric or non numeric. For example, an employee has name – Putul, age-28, and gender-female. Here Putul, 28 & Female are data.
| To Create Database with Access 2003: |
|
- Open Access (Start > Run > type access > Enter/Ok)
- On the File menu, click New
- Click Blank Database from 'Task Pane'
- Select location > Type File name: abcCompany (or your choose) > Save as type: Microsoft Office Access Database (*.mdb) > Click Create button
[Close the Database if it is opened]
- On the File menu, click Open
- Select location > Select the database > Click 'down arrow' of Open button > Click Open Exclusive
- Click Open button
- On the Tools menu, point to Security and click Set Database Password…
- Type Password: 123 (or your choose) into 'Password: box'
- Again type same Password: 123 (or your choose) into 'Verify: box'
- Click Ok button
| To Open Protected Database: |
|
[Close the protected Database if it is opened]
- On the File menu, click Open
- Select location > Select the database > Click Open button
- Enter database password: 123 > Click Ok button
[Close the Database if it is opened]
- On the File menu, click Open
- Select location > Select the database > Click 'down arrow' of Open button > Click Open Exclusive
- Type database password: 123 > Click Ok button
- Click Open button
- On the Tools menu, point to Security and click Unset Database Password…
- Type Password: 123 (or your choose) into 'Password: box' > Click Ok button
|
Custom Search 
