Overview Our Introduction to Access course assumes no prior knowledge of the program and gives a thorough grounding in how Access works and the function of each of its key environments. Course Outline Fundamentals Basic database concepts, Designing a basic database, Overview of MS Access, Opening an existing database, The Access environment, Access Objects, Editing an Access table, Navigating through a table, Deleting records, Adding new records, Finding and sorting Creating tables Creating an Access database, Creating tables in design view, Using the Table Wizard, Setting field attributes, Setting a primary key, Datasheet view Filtering and sorting Finding records, Filtering records, Filtering with forms, Sorting records Working with forms Overview of forms, Using the Form Wizard, AutoForms, Bound and unbound forms, Data validation, Adding records via a form Relationships Relationships overview, Creating relationships, About referential integrity Queries Design view queries, Setting criteria, Using the query wizard, Sorting queries, Modifying and updating queries, Querying multiple tables Creating reports AutoReports, The Reports Wizard, Formatting a report, Linking reports to queries, Generating groupings, Creating custom headers, Adding your logo, Printing reports