This session will assist in
obtaining the skills required to create a relational database utilizing
Microsoft Access. Participants will
learn to customize forms, reports, Data Access Pages in design view and to
import and export data in different formats.
Designing a Relational Database Describe basic principles of relational database management
systems • Split a database into relational tables using key fields • Understand
the importance of referential integrity • Design a table for a relational
database
Creating Table
Relationships
Create and edit table relationships • Arrange tables in the Relationship window
• Enforce referential integrity • Use the Lookup Wizard • Modify a lookup list
• Display related records in a sub-datasheet
Joining Tables with
Queries Create
and modify a multi-table select query • Specify join properties for
relationships • Understand the effect of join types in a query • Use self joins
and cross joins
Summarizing and
Calculating Data
Create a query to summarize values • Add a calculated field to query output •
Apply query properties • Add a calculated field to form or report • Use the
Expression Builder to create expressions
Creating a Summary
Report Create
a summary report using the Report Wizard • Modify group properties • Add and
remove group headers and footers • Modify group and detail section sort orders
• Modify report section properties
Designing Forms and
Reports Create
a new form or report in design view • Understand the use of different sections
• Display, hide, and resize a section • Modify form/report, section, and
control properties • Add a bound control • Use the Control Wizard to add a
control (list box, combo box, check box, option group) • Add a hyperlink
control
Modifying Controls Select a single control or multiple
controls • Move, resize, align, and distribute controls • Change the tab order
of controls on a form • Identify and resolve errors • Modify control properties
• Insert a graphic control • Set control defaults • Create a form/report
template
Importing Data Import data from different sources
(spreadsheet, text file, database, Outlook/Exchange Address Book) • Use Drag-and-Drop
and the Clipboard to copy and paste data
Exporting Data Export a table or query to Excel •
Export data to Word and complete a mail merge • Create a report snapshot • Save
data in other file formats • Export data objects to a different database • Save
a table, query, or form as a web page • Export data to XML