Access
Download
1 / 15

Access - PowerPoint PPT Presentation


  • 106 Views
  • Uploaded on
  • Presentation posted in: General

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).

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha

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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


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)

  • Title Bar– Double clicking the title bar alternately maximizes and restores Access.


Making Sense of the Sights (cont’d)

  • Main Menu– Access commands and functions


Making Sense of the Sights (cont’d)

  • Toolbar—common functions


Making Sense of the Sights (cont’d)

  • Utility buttons—Minimize, maximize, close


Making Sense of the Sights (cont’d)

  • Status bar—Whenever Access wants to tell you something a message appears on the status bar.


Making Sense of the Sights (cont’d)

  • Database window—waiting patiently for you


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


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)


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)


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


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


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)


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


ad
  • Login