1 / 120

Learn Microsoft Access 2007: Database Terminology, Features, and Security

This section provides an overview of Microsoft Access 2007, including database terminology, new features, and security concepts. Learn how to create a database from scratch or using templates, apply passwords, use the Trust Center, and access help resources.

templin
Download Presentation

Learn Microsoft Access 2007: Database Terminology, Features, and Security

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. In this section you will learn how to: Identify and understand some database terminology Use the new features of Access 2007 Create a database from scratch Create a database using one of the many templates Identify some database security terminology and concepts Understand and use the Trust Center Apply a password to a database file Use the Access help page Use the features of Office Online

  2. Microsoft Access 2007 is a database management program in the Microsoft Office suite. • Access 2007 has been rebuilt from the ground up. • Access 2007 features an all-new interface, drag-and-drop functionality, modern styling, enhanced connectivity, more features, and better security.

  3. What is Microsoft Access? Information management program

  4. What’s New in Access 2007? New interface design, more intuitive

  5. Basic Terminology Field, Record, Table, Database, Form, Query, Report

  6. Opening Microsoft Access Start  All Programs  Microsoft Office  Microsoft Office Access 2007

  7. Interface Overview You will see the Getting Started window first.

  8. Closing Microsoft Access Office Menu  Exit Access

  9. The Getting Started window appears every time you open Access without directly opening a file, or after you close an opened database without actually closing Access.

  10. Overview of the Window Three panes in window

  11. Navigating Through the Window Point and click!

  12. Creating a Database fr. Template Choose category, click database

  13. Creating a Blank Database Click Blank Database under the New Blank Database heading.

  14. Trust Center helps protect you from malicious attacks.

  15. Warnings You May See When Opening a Database Warnings are designed to protect you, not scare you!

  16. Enabling Content If file is safe, click Enable Content.

  17. About Digital Signatures Identify who someone or what something is

  18. About Trusted Locations Tell Access that files in a particular location are OK

  19. Opening the Trust Center Office Menu – Access Options – Trust Center

  20. Assigning a Password to Your Database Database Tools - Encrypt with Password

  21. When all else fails, you can always ask for help! • All programs included in the Office 2007 package make extensive use of the Office Online functionality if an Internet connection is available at the time.

  22. Opening the Help Screen Help icon or F1

  23. Overview of the Help Screen Similar in design to web browser

  24. Online Help vs. Offline Help If your computer is not currently connected to the Internet you still have access to all of Access’ help features.

  25. Searching for Help Browse, Table of Contents, Keyword Search

  26. In this section you will learn how to: Recognize a contextual tab Use the commands located in the ribbon Expand extra commands using the Chunk icons Use and customize the Quick Access toolbar Use the Office menu Use the four default ribbons

  27. Provides quick access to common commands • Can easily be customized

  28. About the Default Buttons Save, Print, Undo

  29. Adding Buttons Right-click, Add to Quick Access Toolbar

  30. Removing Buttons Right-click, Remove From Quick Access Toolbar

  31. Customizing the Toolbar Arrow, More Commands

  32. Instead of having a list of menu commands to choose from (including a number of options that are grayed out and not accessible), Access 2007 features a more intuitive control system of tabs.

  33. About Ribbons General and contextual

  34. Opening Dialogue Boxes Click arrow icon in corner of chunk

  35. About the Office Menu Accessible from Office logo

  36. This ribbon contains most of the commonly used commands for databases and working with data.

  37. Views Cycle through views available

  38. Clipboard Common editing commands

  39. Font Format text

  40. Rich Text Modify appearance of rich text fields

  41. Records Basic data management commands

  42. Sort and Filter Helps organize your data

  43. Find Find, replace, and select data

  44. Used to make new database objects

  45. Tables Tables are the main objects used in databases.

  46. Forms Forms are a way of entering data into a table one record at a time.

  47. Reports Used to summarize data returned by a query

  48. Other Commands to construct queries, macros

  49. Contains commands to import data from nearly any source.

  50. Import Bring data from other programs

More Related