MICROSOFT ACCESS

Ms Access is a database management tool that enables one to have good command of data collected. The programme enables one to retrieve, sort, summarize and report results speedily and effectively. It can combine data from various files through creating relationships, and can make data entry more efficient and accurate. Microsoft Access (MS Access) enables one to manage all important information from a single database file. Within the file, one can use: • Tables to store your data. • Queries to find and retrieve specific data of interest. • Forms to view, add, and update data in tables. • Reports to analyze or print data in a specific layout. • Data access pages to view or update, the data. In MS Access, data is stored once in one table, but can be viewed from multiple locations. When the data is updated in a Table, Query or Form, it is automatically updated everywhere it appears Establishment of Ms Access database All Ms Access databases files are saved with extension .mdb A database should have a separate table for every major subject, such as pedigree records, Production data or Treatment information. Data should not be duplicated in multiple tables. Microsoft Access provides three methods to create a database „ Database Wizard (though easy, the wizard offers limited options to customize the database) „ Using a template (This method works best if one can find and use a template that closely matches the specific requirements) „ Creating a database directly (This is the most flexible method, but it requires one to define each database element separately). Create a new Access database [Tuurosung Joseph].

After creating a new database, this should be saved by the name which reflects the content of the database. Upon saving the database, the Ms Access database window opens with the Tables tab-active (i.e in such a way that the next activity should be to create a table).

Tab on LEVEL ONE to take your first tutorial lesson on database management in Microsoft access