Most of the organizations maintain and manage huge amounts of information. One of the most efficient and powerful ways of managing data is by using relational databases. Information can be designed, stored, linked, and managed using a single relational database application and its associated tools.
Microsoft Access 2007 is an application used to create small and medium-sized relational databases for the Microsoft Windows family of operating systems. It can also be used as a database server for a web-based application. It is also supported by ADO, OLEDB, ODBC, and the .NET Framework, etc.
Microsoft Access 2007 now makes it easier for anyone to use, or create powerful database solutions to help organize, access, and share data, in no time.
By completing the entire two parts Microsoft Access 2007 training, students will:
Know how to use and design tables, forms, and queries.
Know how to link information and automate data entry.
Create Queries to find and select records by criteria, and write, test, and update those queries.
Understand how to create forms with subforms to represent one-to-many relationships.
Create a Search Form that uses a Combo Box to filter the records
. Learn to use criteria, parameters, concatenation, and operators in Query designs: calculate with DateDif(),Left(), and IIF(), improve report designs with Sorting and Grouping.
Know how to use Microsoft Access and Word together in a Mail Merge, as well as publish an Access report to Word, and optimize a database for multiple users.