Access 2000-2003

Access 101

1. Introduction Welcome to Access 101 Important concepts 2. Terminology What is a database Database components (tables, queries, etc.) Describe each component and it's function 3. Planning Your Database Planning your database on paper Plan for needed tables Plan for needed fields in each table 4. Getting Started Starting Access Parts of the interface Creating a blank new database 5. Customer Table, Part 1 Creating a customer table using design view Creating the FirstName field 6. Customer Table, Part 2 Brief description of basic data types (text, memo, etc.) 7. Customer Table, Part 3 Adding additional fields to your table (phone, address. etc.) Brief description of basic field sizes (long int, decimal) 8. Customer Table, Part 4 Creating a CustomerID Autonumber Moving fields in order Saving your table Setting the primary key 9. Entering Data Adding data to your table Deleting records 10. Customer Query Building a query in design view Adding fields to your query Sorting your query (LastName, FirstName) Moving fields in your query Using criteria (e.g. show all customers from NY) 11. Customer Form Building a form using design view Selecting a data source Adding fields to your form using the field list Lining up your controls Switching to Form View and back to Design View Using navigation buttons to navigate records Moving controls with the Hand Selecting a block of controls Deleting controls Trick to add all controls from the field list to the form Saving your form 12. Form Formatting Changing colors of your form and objects Deleting a label, keeping the text box Editing your label text Resizing a text box Moving a block of controls together Moving a label independent of it's text box Resizing your form Object borders and special effects Deleting a record from the form 13. Mailing Labels Using the mailing label wizard Desigining a prototype label Report Print Preview Zooming in and out

Access 102

1. Welcome Objectives Pre-requisites Versions used How to learn 2. Review How to find sample database files Review topics from Access 101 3. Field Properties Text field sizes Number field sizes Format property Date formats Text formats Number formats Input masks Required property Default value Validation rule Validation text Indexing 4. Search Sort Filter Find & Replace Sorting Filtering data Both tables and forms 5. Queries Multiple OR criteria (NY or CA) AND from different fields (NY and Active) AND across, OR down Saving a query with a different name OR from different fields (NY or 200 credit) Between keyword Date criteria (>#1/1/1998#) Wildcards LIKE keyword Parameter Query 6. Forms Creating an Employee table Using OLE Objects Creating the employee form Adding a picture field to your form Resizing your form Intro to object properties picture size mode: stretch, zoom, clip The toolbox Combo box with static data (M/F) Using the combo box wizard. Change to: Combo box into a List Box Selecting and copying a record Tab Order Form fields: align left Zoom with shift-F2 Command button: Close Form 7. Reports Query for people not missing address data Is Not Null: AND condition People who are missing address data Is Null: OR condition New Mailing Labels Building a report with design view Building a report based on a query Page header & footer 8. Compact & Repair Why compact your database? How to compact & repair 9. Review Review topics Skills check What's Next?

Access 103

l. Introduction Objectives Pre-requisites Versions used How to learn Included files 2. Main Menu, Part 1 Creating a form with no data Unbound form instead of a Switchboard Command button to open a form and show all records Form properties Form caption Record selectors Navigation buttons Scroll bars 3. Main Menu, Part 2 Form background color Label control Label properties (font, size, bold, effects, etc.) Resizing a label Putting an image on a command button Button properties Send to back / bring to front Format painter Setting a database startup form Application title Hiding the database window Unhiding your database window Creating a shortcut to your database on your desktop 4. Customer List Form Query: sorted list of customers Building a form based on a query Lining fields up horizontally Continuous forms v. single form Optimizing form space Form header & footer Using the rulerbars to select across/down Cleaning up your labels Command button to open a form and show specific records Opening the selected customer record Filtered results in your form Removing a filter Autoform: Tabular Autoform: Columnar 5. Tracking Lead Sources Adding a lead source field to the customer table Combo box with static list of lead sources Making at table to store a dynamic list of lead sources Creating a combo box based on a table Adding new valves to your table Updating our Main Menu with the new buttons Using the Form Wizard to create a quick form Create a form for lead sources using the wizard Renaming your form Create a button to close the database 6. Review Review topics Skills check What's next?

Access 104

l. Introduction Welcome Objectives Pre-Requisites Versions Sample Database Files 2. Contact Table What is a "Contact" Using the customer notes field for contacts Limitations Creating the Contact Duplicate data problem Setting the default date with the Now() function 3. Contact Query Listing contacts by date Show only a specific date between two dates Between keyword Let the user enter the dates with a parameter Creating Full Name field by merging two fields String concatenation Formatting a query field Format property 4. Contact Report Using the page header Selecting objects using the ruler bar Notice an & disappears in label && in Label Adding a line object Keeping your line straight Text boxes with large amounts of data are truncated Can Grow / Can Shrink textbox properties Can Grow / Can Shrink section properties Sorting and Grouping Sorting in the report Group Header & Footer Keeping a group together on a page Report header / footer Adding page numbers to your reports Showing total number of pages 5. Miscellaneous Put contact report on Main Menu Control Tip Text 6. Review Review topics Skills check What's next?