CSULB Home  •   MyCSULB  •   BeachBoard  •   Library  •   E-mail  •   Directory  

 

Suggested Study Topic: Access

  • BASICS
    • Creating a database
    • Creating a table
    • Inserting data
    • Viewing database, table, data from different views
  • TABLES AND RECORDS
    • Modifying table field properties
    • Inserting, modifying, deleting, and finding records
    • Sorting records
    • Filtering records by selection
    • Previewing and printing table data
  • TABLE RELATIONSHIPS
    • Assign primary key
    • Assign primary key with multiple fields
    • Creating and modifying relationships
  • QUERY (Query by Example)
    • Creating, saving, and running a query
    • Creating a query with multiple tables
    • Creating and formatting a calculated field
    • Using functions in query expressions
  • FORMS AND REPORTS
    • Creating a form using a wizard
    • Modify form controls
    • Setting form properties
    • Creating a report using a wizard
    • Adding sorting and grouping levels
    • Adding a calculated control to a report
    • Adding a control to calculate total