Microsoft Access Training – Level 1


access

1. GETTING STARTED


  • Getting Familiar with the Access Screen +


    1. Starting Access
    2. Identifying parts of the Access screen
    3. Working with the Ribbon & backstage view
    4. Using the quick access toolbar
    5. Creating a new blank database


  • Planning & Designing a Database +


    1. Determining current & future needs
    2. Organizing data & selecting fields names
    3. Deciding data types for fields


  • Managing Data Base Files +


    1. Opening & closing an existing database
    2. Using the navigation Pane
    3. Working with database objects
    4. Exiting Access



2. TABLES


  • Creating a Table in Datasheet View +


    1. What is a table?
    2. Creating a new table in datasheet view
    3. Defining table fields
    4. Assigning field names & data types
    5. Using the quick add feature
    6. Entering, editing, or deleting records
    7. Setting field sizes & using best fit
    8. Navigating through records
    9. Saving a table


  • Changing Views +


    1. Switching between design & datasheet view


  • Creating a Table in Design View +


    1. Adding fields
    2. Selecting data types & entering description
    3. Defining a field as a primary key
    4. Renaming, rearranging, or deleting fields
    5. Using the lookup wizard


  • Modifying Field Properties +


    1. Setting field size & formatting
    2. Using the input mask


  • Sorting Records +


    1. Sorting records in ascending or descending order
    2. Sorting records using multiple criteria


  • Searching Records +


    1. Finding & replacing records


  • Printing +


    1. Printing & previewing a table
    2. Printing records
    3. Changing margins & page orientation


3. TABLE RELATIONSHIPS


  • Managing Relationships +


    1. Understanding relationships
    2. Setting primary keys & foreign keys
    3. Creating table relationships
    4. Types of relationships
    5. Viewing related tables
    6. Specifying referential integrity
    7. Printing database relationships
    8. Editing or deleting relationships
    9. Displaying related records in a sub-datasheet



4. CHECKING SPELLING & GETTING HELP


  • Spelling Check +


    1. Using the spelling check


  • Getting Help +


    1. Searching help or using content help



5. QUERIES


  • Creating a Query by Using the Wizard +


    1. What is a Query?
    2. Using the simple query wizard
    3. Selecting the table source
    4. Selecting fields
    5. Saving the query


  • Creating a Query in Design View +


    1. Adding tables to the design query window
    2. Selecting fields & establishing query criteria
    3. Creating a multiple related tables query
    4. Sorting fields in a query
    5. Saving the query


  • Controlling Queries Output +


    1. Opening & switching queries to design view
    2. Adding, rearranging or deleting fields
    3. Sorting the query output
    4. Filtering the query output with one or multiple criteria
    5. Hiding fields
    6. Changing column headings in a query


  • Filtering Data +


    1. Filtering records by selection or by form


6. FORMS


  • Creating Forms by Using the Form Wizard +


    1. What is a form?
    2. Creating a form using the form wizard
    3. Saving or renaming a form
    4. Sorting records using a form
    5. Entering, editing or deleting records using a form
    6. Creating a form from related tables
    7. Moving within or between records
    8. Printing forms


  • Creating Forms in Design View +


    1. Switching views: Form, layout, & design view
    2. Showing or hiding the field list
    3. Adding or deleting controls
    4. Resizing, formatting, or aligning controls
    5. Moving controls & labels
    6. Displaying form properties
    7. Using fields to add controls
    8. Adding a form header & footer



7. REPORTS


  • Report Views +


    1. Report view
    2. Print preview
    3. Layout view
    4. Design view


  • Creating Reports by Using the Report Wizard +


    1. What is a report?
    2. Creating reports based on queries
    3. Preparing a report based on two or more tables
    4. Modifying reports


  • Creating a Report in Design View +


    1. Using fields to add controls
    2. Moving & Resizing controls
    3. Adding & formatting controls
    4. Changing the report theme
    5. Adding headers & footers


  • Printing Reports +


    1. Setting page margins & changing page orientation
    2. Printing & previewing reports


Register Now