Client Login

MICROSOFT ACCESS DATABASE

    CREATING FILES
  • About Access Files
  • Creating a new database file
    OPENING AND CLOSING A DATABASE FILE
  • Opening a database file
  • Closing a database file
    ACCESS WORKSPACE
  • Using the Menu bar
  • Using the Database toolbar
  • Using the Task Pane
  • Using the Status bar
  • Using the Office Assistant
  • Customizing the toolbars
    USING THE DATABASE TOOLBAR
  • Using the New button
  • Using the Open button
  • Using the Save button
  • Using the Search button
  • Using the Print button
  • Using the Print Preview button
  • Using the Spelling button
  • Using the Cut button
  • Using the Copy button
  • Using the Paste button
  • Using the Undo button
  • Using the OfficeLinks button
  • Using the Analyze button
  • Using the Code button
  • Using the Microsoft Script Editor button
  • Using the Properties button
  • Using the Relationships button
  • Using the New Object button
  • Using the Microsoft Access Help button
    USING THE OPEN A FILE AREA OF THE NEW FILE TASK PANE
  • Opening the New File task pane
  • Viewing and opening recent files
    USING THE NEW AREA OF THE NEW FILE TASK PANE
  • Using the Blank Database option
  • Using the Blank Data Access Page option
  • Using the Project (Existing Data) option
  • Using the Project (New Data) option
    USING THE NEW FROM EXISTING FILE AREA OF THE NEW FILE TASK PANE
  • Using the Choose File option
    USING THE NEW FROM TEMPLATE AREA OF THE NEW FILE TASK PANE
  • Using the General Templates option
  • Using the Templates On Microsoft.com option
    USING THE CLIPBOARD TASK PANE
  • About the Office Clipboard feature
  • Opening the Clipboard task pane
  • Using the Office Clipboard feature
    USING THE SEARCH TASK PANES
  • About the Search feature
  • Opening the Search task pane
  • Using the Search feature
    THE DATABASE MENU BAR
  • Using the Database Menu Bar
  • Using the Open button
  • Using the Design button
  • Using the New button
  • Using the Delete button
  • Using the Icon buttons
  • Using the List button
  • Using the Details button
    THE DATABASE WINDOW TOOLBAR
  • About the Groups feature
  • Using Groups in the Toolbar
  • Using the Favorites button
  • Using the Tables button
  • Using the Queries button
  • Using the Forms button
  • Using the Reports button
  • Using the Pages button
  • Using the Macros button
  • Using the Modules button
    CREATE A TABLE
  • About creating a table in Design view
  • Creating a Table in Design View
  • About using the Table Wizard to create a table
  • Using the Table Wizard to create a table
    WORKING WITH TABLES
  • About changing a table design
  • Changing a table design
  • Adding records
  • Finding Records
  • Editing records
  • About filtering records
  • Filtering records
  • About sorting records
  • Sorting records
    CREATE A QUERY
  • About queries
  • About creating a new query in Design view
  • Requirements for a query in Design view
  • Creating a new query in Design view
  • About creating a new query using a wizard
  • Creating a numerical query using the wizard
  • Creating a non-numerical query using the wizard
  • Saving queries
  • Opening an existing query’s result window
  • Open an existing query in Design view
  • Refining the results of a query
  • About adding calculations to a query in Design view
  • Adding calculations in Design view
    USING AND CREATING FORMS
  • Using Forms
  • Creating forms with the wizard
  • Creating a simple form from scratch in Design view
  • Modifying a form in Design view
  • Using a form to locate information
  • Using a form to organize information effectively
    CREATING AND USING REPORTS
  • Using Reports
  • Creating a report using AutoReport
  • Creating a report using a wizard
  • Creating a report from scratch in Design view
  • About totals or averages in a report
  • Creating a report with totals or averages
    SAVING, MAINTAINING, AND PRINTING REPORTS
  • Saving a report
  • Setting report properties
  • Previewing a report (before you print it)
  • Printing a report