Access 2007 Essentials

Rapid Skillz

Course

Online

£ 37.43 VAT inc.

*Indicative price

Original amount in USD:

$ 47

The best Access courses

See all

See all

Description

  • Type

    Course

  • Level

    Intermediate

  • Methodology

    Online

  • Duration

    Flexible

  • Start date

    Different dates available

Explore the endless capabilities of Microsoft Access 2007. These lessons, hosted by Jeff Conrad begin with a solid introduction of Access and cover topics such as defining a database, knowing when to use Access, working with database objects, and converting older databases.

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

Once you’re up to speed on the intricacies of Access 2007, Jeff walks you through step-by-step procedures on how to construct your table structures, create and adapt meaningful data entry forms, as well as share tracked information with others through reports.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Database training
  • Database
  • Access
  • Design
  • Macros
  • Mail Merge
  • Exporting Data
  • Startup
  • PivotTables
  • PivotCharts
  • Referential Integrity
  • Database Tools
  • Databases Access
  • Switchboards

Teachers and trainers (1)

Name Name

Name Name

Teacher

Course programme

Chapter I: INTRODUCING ACCESS 2007 (17 min)
  • Defning a Database
  • Knowing When to Use Access™
  • Working with Database Objects
  • Converting Older Databases
Chapter II: EXPLORING THE NEW USER INTERFACE (84 min)
  • Exploring the Getting Started Screen
  • Opening a Microsoft Template
  • Using the Navigation Pane
  • Using the Home Tab, Part 1
  • Using the Home Tab, Part 2
  • Using the Create Tab
  • Using the External Data Tab
  • Using the Database Tools Tab
  • Using the Office Menu
  • Explaining the Access Options
  • Using the Quick Access Toolbar
  • Adding Custom Commands to the Quick Access Toolbar
  • Using the Help Menu
  • Understanding the Message Bar
  • Creating Trusted Locations
  • Working in the Object Window
Chapter III: WORKING IN THE NAVIGATION PANE (45 min)
  • Displaying Categories
  • Showing Views
  • Sorting the Objects
  • Searching for Objects
  • Collapsing Groups
  • Creating Custom Groups
  • Adding Object Shortcuts
  • Hiding Custom Groups
  • Changing the Interface Mode
  • Final Comments & Credits

Part/Disc II
Chapter I: CREATING TABLES (67 min)
  • Explaining the Datasheet Tab
  • Entering Data in a New Table
  • Using a Table Template
  • Identifying the Entities
  • Working with Design View
  • Creating DataTypes
  • Using Field Validation Rules
  • Defining Primary Keys
  • Adding Indexes
  • Working with Table Relationships
  • Creating Table Relationships
  • Defining Multi-Value Field Lookups
Chapter II: CREATING QUERIES (50 min)
  • Creating a Select Query
  • Using Expressions in a Query
  • Sorting Data
  • Searching for Data
  • Selecting Data from Many Tables
  • Working in Layout View
  • Working in SQL View
  • Creating a Crosstab Query
  • Running Action Queries
  • Running Update Queries
  • Using the Query Wizard
Chapter III: CREATING FORMS (48 min)
  • Using Quick Create Commands
  • Exploring Form Types
  • Navigating within Forms
  • Using the Form Wizard
  • Creating a Form from Scratch
  • Working in Layout View
  • Working in Design View
  • Setting Form Properties
  • Using Form Controls
  • Using Control Layouts
  • Applying AutoFormats
  • Understanding Subforms
Chapter IV: CREATING REPORTS (57 min)
  • Using the Report Command
  • Running the Report Wizard
  • Exploring Report Views
  • Creating a Report from Scratch
  • Using Conditional Formatting
  • Grouping & Sorting
  • Setting Report Properties
  • Detailing Your Report
  • Applying AutoFormats
  • Adding Subreports
  • Alternating Record Colors
  • Filtering in Report View
  • Creating Labels
Chapter V: CREATING MACROS (26 min)
  • Working in Macro Design Mode
  • Assigning Macro Actions
  • Setting Macro Arguments
  • Running an AutoExec Macro
  • Creating Embedded Macros
  • Final Comments & Credits

See related categories

Access 2007 Essentials

£ 37.43 VAT inc.

*Indicative price

Original amount in USD:

$ 47

The best Access courses

See all

See all