Office 2000 Tutorials : Access ------------------------------ http://www.fgcu.edu/support/office2000/access/ Getting Started * A few terms * Getting started * Blank Access database * Access database wizards, pages, and projects * Open an existing database * Converting to Access 2000 Screen Layouts * Database window * Design view * Datasheet view Creating Tables * Introduction to tables * Create a table in design view * Field properties (omit details of formats) * Primary key * Indexes * Field validation rules (omit input masks) Datasheet Records * Adding records * Editing records * Deleting records * Adding and deleting columns * Resizing rows and columns Table Relationships * Declaring table relationships Queries * Introduction to queries * Create a query in design view (omit details of wildcards and expressions) * Query wizard Forms * Create a form using the wizard * Create a form in Design View * Adding records using a form * Editing forms Form Controls * List and combo boxes * Check boxes and option buttons * Command buttons Subforms * What is a subform?