1 / 47

Access Database Administration

Access Database Administration. Introduction. P.O. Box 6142 Laguna Niguel, CA 92607 949-489-1472 http://www.d2associates.com. Orange Coast Database Associates. Loose association of local University instructors and IT Professionals. Started in 1996 Training

Download Presentation

Access Database Administration

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Access Database Administration Introduction P.O. Box 6142 Laguna Niguel, CA 92607 949-489-1472 http://www.d2associates.com Access Utilities

  2. Orange Coast Database Associates • Loose association of local University instructors and IT Professionals. • Started in 1996 • Training • Open Enrollment (public classes in San Juan Capistrano using standardized material) • On-site (custom classes for groups) • Private desk side training for individuals • Consulting & Programming (incl. offshore) Access Utilities

  3. ADB201 Access Database Administration • Introduction (s) • Facilities • Course Packet • Student Questionnaire • Curriculum overview • Syllabus • List of Useful Books • PowerPoint handouts for all sessions • Laminated Reference Guide to Access • Evaluation form in back • Training certificate Access Utilities

  4. Access Utilities

  5. MS Access Introductory (100 Level) Curriculum AIN100 AIN100T AIA101 AIN102 Queries AIN104 Reports & Forms AMP110 Macros Access Utilities

  6. ADB201 – Access Database Administration • Quick pace for experienced windows users • Assumes good prior knowledge of Access • Oriented towards those charged with administering the database Access Utilities

  7. ADB201 – Access Database Administration • 2 Sessions • Lecture • Demo • Student “hands-on” - by the end of the class the student will have worked through all the Access Utilities and secured a database • Exercises are cumulative – later examples build on objects created earlier CourseFormat: Access Utilities

  8. ADB201 – Access Database Administration • Session 1 • ODBC • Access Utilities • Session 2 • Security Course Schedule (3 hour sessions): Access Utilities

  9. Rocky2 DSN now available Note: the rocky2 DSN is available for all applications that can use ODBC, not just Access Access Utilities

  10. Link Tables(Use created DSN; still in second scenario) • We will now go through an abbreviated series of slides showing how the new DSN can used. Access Utilities

  11. Launch Link Tables Dialogue(Use created DSN; still in second scenario) Access Utilities

  12. Select New Rocky2 Data Source Access Utilities

  13. Select Tables Access Utilities

  14. New Bookstore Database with Linked Tables via rocky2 DSN Access Utilities

  15. Launch Link Tables Dialogue(Existing DSN third scenario) Access Utilities

  16. Admissions Database (for Relink example) Access Utilities

  17. Launch Linked Table Manager Access Utilities

  18. Linked Tables & Locations Access Utilities

  19. Select Table to Relink Access Utilities

  20. Locate Database or File (for Text, Excel ,Etc.) Access Utilities

  21. Table Relinked Successfully Access Utilities

  22. Access Utilities Database Splitter P.O. Box 6142 Laguna Niguel, CA 92607 949-489-1472 http://www.d2associates.com Access Utilities

  23. Database Splitter • Splits an Access database into two components • A new “back end” database with “_be” appended to the original database name. This database has the tables • The original database with the tables replaced by table links to the tables in the new back end database Access Utilities

  24. Why Split a Database? • Pro • Can improve performance • Allows front end to be changed or overlaid without disturbing the back end data • Con • May complicate maintenance, esp. by end-users Access Utilities

  25. Admissions Database Access Utilities

  26. Launch Database Splitter Access Utilities

  27. Start the Split Access Utilities

  28. Create Back End Database Access Utilities

  29. Original Database (Front End) Access Utilities

  30. Linked Table Manager Connections Access Utilities

  31. New Back End Database Access Utilities

  32. Access Utilities Switchboard Manager – Covered in Access Introductory Courses P.O. Box 6142 Laguna Niguel, CA 92607 949-489-1472 http://www.d2associates.com Access Utilities

  33. Access Utilities Upsizing Wizard P.O. Box 6142 Laguna Niguel, CA 92607 949-489-1472 http://www.d2associates.com Access Utilities

  34. Upsizing an Access Database • Upsizes to MS SQL Server only • Several approaches • Create tables in SQL Server only • Create tables in SQL Server and add table links to existing Access database (we will use this approach) • Create a “project” file (.adp). Deprecated in Access 2007. Access Utilities

  35. Factory 2000 Database Access Utilities

  36. Launch Upsizing Wizard Access Utilities

  37. Select Database Type Access Utilities

  38. Select Server and Database Name Access Utilities

  39. Select Tables Access Utilities

  40. Select Attributes Access Utilities

  41. Specify Application Approach Access Utilities

  42. Upsize! Access Utilities

  43. Print Upsizing Report Access Utilities

  44. DB Window with Linked Tables Access Utilities

  45. Using Linked Tables • Linked tables can be manipulated as if they were regular tables, subject to certain restrictions. • Can be used in queries, reports, forms • Data can be modified • But… table structure cannot be altered via Access Access Utilities

  46. Linked Table Manager Connections Access Utilities

  47. SQL Server Database Access Utilities

More Related