In this course, students will be introduced to some the more advanced features of Microsoft Access, including designing effective forms with various types of controls such as command buttons, option groups, tabs and subforms. Students will also learn to create multi-table forms and Switchboard (Main Menu) forms. Various types of queries will be used to create calculated fields (and use conditional IFF statements), summarize in queries and to append tables, create tables and prompt with parameters. Students will also learn to control report design and use autoformats in reports. Time permitting, macros (in macro objects) will be created to automate tasks within an Access database.
On Request Only - Contact DPADuration: Two-Day Course
Platform: Windows Only
Fee: Call for information
We recommend one to eight people for this course.
Microsoft Access is a relational database management system which combines the relational Microsoft Jet Database Engine with a graphical user interface. Access can use data stored in Access/Jet, Microsoft SQL Server, Oracle, or any ODBC-compliant data container. Microsoft Access AutoForm creates a form that displays all fields and records in the underlying table or query. If the record source you select has related tables or queries, the form will also include all the fields and records from those record sources. You can also use the wizard, which asks you detailed questions about the record sources, fields, layout, and format you want and creates a form based on your answers. In addition you can also create a basic form and customize it in Design view to suit your requirements.
Users: IT, Database, Engineering, Finance, Legal, Marketing and Admin Professionals as well as anyone who needs create robust databases that can be searched, sorted, analysed, reported, updated and shared with other users.