CIS 125A Access-Database

Lecture Hours: 3
Credits: 3

Provides the tools necessary to create and maintain a basic database using Microsoft Access. Includes navigation through Windows and Access menus; PC relational database concepts; creation and updating of a relational database; simple queries, reports and forms; complex queries, reports and forms.

Prerequisite: CIS 101 or CIS 120, either with a grade of C or better; or consent of instructor.
Student Learning Outcomes:

Write a short description of the components that make up a DBMS software package.
Define terms related to working with DBMS software.
Navigate through the Graphical User Interface (GUI) menu of Microsoft Access.
Use all aspects of the Help system provided by Windows and Microsoft Access.
Perform basic table operations.
Perform basic query operations.
Design data entry forms.
Create custom reports.

Content Outline

Database Concepts
Access as PC Database
- Windows menu navigation
- Access menu navigation
- Changing default path and drive settings
- Access start-up procedures
- Selecting a table for viewing
Access Help
- Windows keying convention
- Access keying convention
Creating Database Structures
- Customer
- Orders
- Item
- Invoice
Multiple Database (Table) Operations
- Viewing multiple tables at the same time
- Moving between tables
Displaying Data
- Modifying the file structure
  - Inserting new fields
  - Moving fields
  - Deleting fields
Updating Files
Indexing and Sorting Databases
Linking Databases (Setting Relationships)
Views and Queries
- Simple queries (=,<>, <=, >=)
- Case dependent searches
- Date searches and date arithmetic
- Query by example
- Compound conditions
  - (AND, OR, NOT)
  - Substring search (LIKE)
  - Linked files queries and views
Creating Reports and Forms
Report Generation
- Single file
- Linked file
Discussion of Label Generation
Advanced Report Design
- Multiple line reports
- Control break reporting (group reporting)
- Calculated fields (memory variables)
- Wrapped fields
- Column totals
- Group totals
Customized Data Entry Screens
- Designing data entry forms
Multi-Table Forms