Maricopa Community Colleges  BPC117AJ   19916-19992 
Official Course Description: MCCCD Approval: 12/08/98
BPC117AJ 19916-19992 L+L 1 Credit(s) 2 Period(s)
Database Management: FileMaker Pro-Level I
Introduction to the basic elements of a current version of the FileMaker Pro database management program, for casual and beginning users. Prerequisites: None.
Cross-References: CIS117AJ
Go to Competencies    Go to Outline
 
MCCCD Official Course Competencies:
 
BPC117AJ   19916-19992 Database Management: FileMaker Pro-Level I
1. Place database programs within the larger context of recent computer history. (I)
2. Identify the various types of database management programs. (I)
3. Describe the main features, advantages, and limitations of this specific database program. (II)
4. Operate the database program and the microcomputer on which it runs, at an elementary level. (III)
5. Create database files. (IV)
6. Add, delete, and alter records within the database files. (IV)
7. Retrieve information for screen display and printing. (V)
Go to Description    Go to top of Competencies
 
MCCCD Official Course Outline:
 
BPC117AJ   19916-19992 Database Management: FileMaker Pro-Level I
    I. Brief introduction to history and theory of databases
        A. History of databases and file management
        B. Survey of database types
      II. Overview of the specific database being studied
          A. Main features
            1. Files
            2. Fields
            3. Records
            4. Reports
            5. Indexes
            6. Other unique components special to this software (memos, catalogs, etc.)
          B. Advantages and limitations
            1. Capacity
            2. User-friendly aids and shortcuts
            3. Frequent problems and disadvantages
        III. Running the specific database program
            A. Database environment (keyboard, function keys, screen, etc.)
            B. Launching and quitting the program
            C. Issuing commands and making menu selections
          IV. Creation of simple database files
              A. Making elementary file structures
              B. Filling the file with appropriate data
              C. Changing the file
                1. Altering the file's structure
                2. Changing, deleting, and adding records
            V. Information retrieval
                A. Retrieving files, records, and fields
                  1. Global and selective retrieval
                  2. Elementary query methods
                B. Viewing and printing the results
                  1. Browsing, displaying, listing data on the screen
                  2. Sending organized data to a variety of printers
            Go to Description    Go to top of Competencies    Go to top of Outline