Upon successful completion of this one day course, students will be able to: Modify the design and field properties of a table to streamline data entry and maintain data integrity. Create a list of values for a field. Create query joins, join unrelated tables, relate data within a table. Set select query properties, create parameter and action queries. Design a form layout and enhance the appearance of a form. Restrict data entry in forms, add a command button to a form and create a subform. Organize report information, format the report and set report control properties. Control report pagination, summarize report information and add a subreport to an existing report. Import and export data. Analyze Access data in Excel. Export data to a text file. Merge Access data with a Word Document.