CMAP 245 - Advanced Database Applications

• Demonstrate advanced database design principles by designing a database with more than three related tables of different types; look-up, main and bridge tables
• Utilize entity relationship diagramming to create and accurately describe the structure of a database
• Identify and describe the three main types of relationships and the appropriateness of each; one-to-one, one-to-many and many-to-many
• Explain the concept of referential integrity and its importance to database design and data accuracy
• Explain the process of normalization and apply the process to correctly design a database
• Create and use advanced queries such as parameter, action, summarizing (aggregating), find duplicate and find unmatched queries
• Create simple one table queries using SQL. Students will correctly use SELECT, FROM, WHERE and ORDER BY clauses
• Describe and use proper table joins in queries; inner, full outer, and left and right outer joins
• Create a custom form without the use of a wizard that contains advanced form controls such as options groups and combo boxes
• Create a form and corresponding subform with correct master/child relationship
• Create a tabbed form
• Create a custom report with advanced sorting and grouping options
• Create calculated and summarized fields in a report
• Create custom macros; conditional, macro groups and autoexec macros
• Attach macros to object events and command buttons
• Create a switchboard; custom and using the switchboard manager
• Convert database to an ?application? by setting start-up options, creating a switchboard, and creating custom toolbars and menus

View Schedule of Classes