Site menu
Search
Map

View Larger Map
Calendar
«  November 2017  »
SuMoTuWeThFrSa
   1234
567891011
12131415161718
19202122232425
2627282930
Site friends
  • Create a free website
  • Statistics

    Total online: 1
    Guests: 1
    Users: 0
    Ads
     Access Database
    Microsoft Access - Database and Table

    From this hour you will be able to learn about below topic –

    About Database & Microsoft Access 2003
    About Database Objects in Microsoft Access 2003
    How to Create Database with Access 2003
    How to Protect Database
    How to Open Protected Database
    How to Unprotect Database

     
     
    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
    To Protect Database:

    [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
    To Unprotect Database:

    [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
    ********************

    Copyright MyCorp © 2017