Who this course is for
Lesson One - Including: terminology, working with existing databases, opening a table, query, form and report, entering new records. Lesson Two - Including: planning and design, relationships, defining fields, data types and properties, creating tables, entering data, resizing columns. Lesson Three - Including: defining relationships, creating tables, formatting, modifying, using the input mask wizard, using templates. Lesson Four - Including: editing data, adding records, printing preview, changing page orientation, enforcing referential integrity in a relationship, creating a relationship report, creating a form, working with controls in form design. Lesson Five - Including: Using advanced sort, using filters, importing a table from an external database using a junction table to resolve a many to many relationship, defining a composite (primary) key, using a calculated control on a form, creating a multi-value field. Lesson Six - Including: using query wizard, setting sort criteria, using expressions to set criteria, creating different types of queries. Lesson Seven - Including: adding a field with data validation in a table, creating a form with subform, entering data using a form/ subform combination, creating a split form, creating and modifying the design of a report, using the concatenate expression, adding a subreport to an existing report. Lesson Eight - Including: exporting an html document, understanding object dependencies, importing and exporting a spreadsheet, importing a text file, using the analyze table function, using the analyze performance function. Lesson Nine - Including: adding and modifying a chart, changing the tab order in a form, displaying the current date and time in a form. Lesson Ten - Including: creating a macro, adding a control button to a form, backing up a database, viewing database properties, compacting and repairing a database, encrypting a database using a password, saving the database as a previous version.
