909.981.6331
Excel

Excel

Word

Word

Access

Access

PowerPoint

PowerPoint

Outlook

Outlook

Publisher

Publisher

Quickbooks

Quickbooks

Windows & Computers

Windows & Computers

Internet & Cloud

Internet & Cloud

Specialty

Specialty

Access Intermediate

Now that your data is safely being held in Access tables, it’s time to create a means to enter new data and print that data. This class focuses on Form and Report Design, utilizing Access’s Form and Report Controls. We also continue working with Queries including creating user prompts, Parameter Queries, and Grouping Queries. PARAMETER QUERIES * GROUPING * FORM & REPORT DESIGN!

Scheduled Dates

Course NameDateTimeOpen SeatsPrice
Access Intermediate10/24/20199:00AM - 4:00PM9$145.00 Register
Access Intermediate11/15/20199:00AM - 4:00PM9$145.00 Register
Access Intermediate12/11/20199:00AM - 4:00PM9$145.00 Register
Access Intermediate1/16/20209:00AM - 4:00PM9$145.00 Register

Topics Include:

  • Primary Key
  • Adding and Deleting Database Relationships
  • Importing tables, queries,forms, reports
  • Linking tables
  • Creating a parameter query
  • Set up grouping with queries
  • Creating an Autoform
  • How to use a Form
  • Add Records
  • Edit Records
  • Delete Records
  • Open/Close a form
  • Using Form Wizard to design a form
  • Viewing, resizing and moving sections
  • Resizing objects
  • Moving a single object or group
  • Aligning items
  • Deleting items
  • Adding labels
  • Formatting text
  • Using Size to Fit
  • Drawing lines and rectangles
  • Adding colors and borders
  • Sending an object to the back
  • Adding special effects
  • Using the Label Wizard
  • Using the Report Wizard with and without grouping
  • Grouping sections
  • Creating a calculating textbox
  • Office Links

California Computer Schools, Inc.

Location 3290 East Guasti Road
Suite 110
Ontario, CA 91761
Phone: 909.981.6331 Hours: Monday – Friday: 9:00 AM – 4:00 PM (PST)

Contact Us

View Cart (0)