1 / 15

Access

Access. Finding Your Way Around like a Native. Making Sense of the Sights. Control menu button– Click the icon (the Access key) in the upper-left corner to open the Control Menu. Double click the icon to close Access. Making Sense of the Sights (cont’d).

nikkos
Download Presentation

Access

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 Finding Your Way Around like a Native

  2. Making Sense of the Sights • Control menu button– Click the icon (the Access key) in the upper-left corner to open the Control Menu. Double click the icon to close Access.

  3. Making Sense of the Sights (cont’d) • Title Bar– Double clicking the title bar alternately maximizes and restores Access.

  4. Making Sense of the Sights (cont’d) • Main Menu– Access commands and functions

  5. Making Sense of the Sights (cont’d) • Toolbar—common functions

  6. Making Sense of the Sights (cont’d) • Utility buttons—Minimize, maximize, close

  7. Making Sense of the Sights (cont’d) • Status bar—Whenever Access wants to tell you something a message appears on the status bar.

  8. Making Sense of the Sights (cont’d) • Database window—waiting patiently for you

  9. Making Sense of the Sights (cont’d) • Task pane—Used for everything from opening existing database files to working with Help system. Use F1 to display

  10. Making Sense of the Sights (cont’d) • Office Assistant—click Help on menu bar, Show Assistant, right click on Assistant to configure (can be turned off if it bugs you)

  11. Objects—What’s Up with That? • Tables—Places to put your data • Queries—Records questions you ask • Forms—Designs custom entry info • Reports—Getting printed copies of info • Pages—Web pages to gather data • Macros—Independent programs • Modules—Libraries of functions and subroutines (not for us)

  12. Database Terms to Know and Tolerate • Data (Your Stuff) is want is stored, shuffled and stacked for you • Fields (The Rooms for Your Stuff) each field holds one kind of data • Records (The Rooms in One House) All the fields on one baseball card, one accounting entry, or one customer. • Table (Houses in a Neighborhood) collection of records that describe similar data (all the customers of Faunteroi’s) • Database (Community of Neighborhoods) collection of everything relating to a particular set of information

  13. Frolicking through the Fields • A field is the place where your data lives; each field hold one piece of data such as a first name, last name, city, etc. • Field types: • Text • Memo • Number • Date/Time • Currency • AutoNumber • Yes/No or True/False • OLE object • Hyperlink • Lookup Wizard

  14. Flat Files versus Relational Databases • Flat files: simple answers for simple needs • All the data is lumped into a single table • Phone directory and Excel spreadsheets are good examples • Duplication occurs • Relational databases: • Uses as little storage space as possible by cutting down on duplicated data • Tables can “talk” to each other to find answers to your questions by using a “KEY FIELD” (your student ID number is an example)

  15. Designing and Building a Home for Your Data • Indexing names • Designing the table • Entering data • PROOFREADING (remember, garbage in will result in garbage out) • Answering questions • Deleting/Adding customers • Answering more questions • And the BIG FINISH—Project test

More Related