ICT

• The Microsoft Access Database for Windows is a program that allows users to create a customized databases that store information in an ordered structure.
• Table - This contains a list of records.
• Microsoft Access helps to store data for reporting, reference, and analyze. This program helps to analyze data, and manage related data than Microsoft Excel or any other spreadsheet applications.
• In 1992, Microsoft released the first version of Access.
• The next version 1.1, was released in May 1993.
• Formats of MS Access - Access 1.0 - Access 1.1 - Access 2.0 - Access 7.0 - Access 97 - Access 2000 - Access 2002 - Access 2007 - Access 2010
• MS Access 2010 is composed of four (4) objects: tables, queries, forms, and reports.
• A user can easily create their first database using Microsoft Access.
• The whole data list that will be encoded in the table will be called records.
• Datasheet View - offers a visual feature to help the user while creating or modifying a table. The encoded data will be displayed in the format of rows and columns.
• Pivot Table View - allows you to view data in the normal grid-like structure of spreadsheet
• Pivot Chart - presents data in a chart format.
• Design View - gives a detailed look at the table's structure. This also allows the user view form design information.
• Printing Database Objects - Microsoft Access allows the user to print the database objects (tables, queries, forms and reports) created.
• Click Quick Print if you want to send the object directly to the default printer without making changes.
• A table is a collection of data presented in rows and columns. This mannered representation allows for easier matching and contrasting of data.
• A table is the most important part of any database. Without tables the system will not be able to build a database.
• The Datasheet view offers a visual interface when creating a table where the encoded data is displayed in the format of rows and columns.
• Navigation allows the system to move to the first row, previous row, next row, and the last row of the table. You can also go to a specific record by entering the record number.
• Sorting Records - This allows the user to easily organize data in the tables.
• Click Remove Sort to remove sorting
• Filtering records makes it easier to retrieve data.
• Text- an alphanumeric character. For example, Last Name, Address
• Memo - texts that use formatting. For example, Product Description
• Number - numeric values. For example, Student Number
• Date/Time- for date or time
• Currency- for financial or money values
• AutoNumber - for auto generated numbers
• Yes/No - for Boolean values
• OLE Object -vfor OLE objects. For example, a Word Document
• Hyperlink - for hyperlinks. For example, email address
• Attachment - for files. For example, photos
• Primary Key is a unique key. It will be used by the database to associate data from multiple tables and combine that data in a meaningful way.
• Version 1.1 was developed to enhance compatibility specifications with other Microsoft software products.
• Forms - for entering data
• Queries - for searching data and for retrieving yhe records to satisfy the criteria that the users are looking for
• Reports - for representing the data in a table or queries for print
• Tables - for storing data