Access
This presentation is the property of its rightful owner.
Sponsored Links
1 / 15

Access PowerPoint PPT Presentation


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

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

Access

Finding Your Way Around like a Native


Making sense of the sights

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

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 d1

Making Sense of the Sights (cont’d)

  • Main Menu– Access commands and functions


Making sense of the sights cont d2

Making Sense of the Sights (cont’d)

  • Toolbar—common functions


Making sense of the sights cont d3

Making Sense of the Sights (cont’d)

  • Utility buttons—Minimize, maximize, close


Making sense of the sights cont d4

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 d5

Making Sense of the Sights (cont’d)

  • Database window—waiting patiently for you


Making sense of the sights cont d6

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 d7

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

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

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

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

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


  • Login