Learn to design a database, create tables, use forms, use filters, enter and correct information, perform queries by using practical examples and create reports.
Learn how to use action queries, use calculated fields, adjust data types, set field properties, and perform database maintenance. You will also use input masks, use controls in forms, learn the lookup feature, and work further with queries and reports.
Learn the principles of table relationships; advanced query techniques; an introduction to functions, macro actions, advanced form techniques including using macros in forms; database security, and advanced report techniques.
Learn how to modify the properties of a form using Visual Basic for Application; learn about implicit and explicit variables and their scope; understand how to use conditional statements and looping statement; Identify ActiveX Data Objects (ADO) architecture; understand error handling techniques.