Advanced MS-Access
Access
Go beyond the basics with this powerful database program.
|
|
||||||||||
Training
Provided by Computers Etc Software Training Center
- asked: Do you have any class before the end of the year either at a Sharp location or at your Balboa location
- B asked: Hello! Are you in San Diego? I am interested in learning MICROSOFT ACCESS. I am almost afraid to tell you that my database is in a dos program and my latest HP printer does not want to even print labels any more! So... I am also interested in learning how to (or paying someone to) get my database into access and learning how to use it. There are only about records. Please call. Thanks, Bev
- C asked: I would like some information on your Advanced Access course. There is an August class that I'm interested in signing up for and was wondering if it was an online class or if I had to go to a campus. Any information regarding this would be helpful! Thank you!
- G asked: Does this course cover writing Access Basic Code including If...Then...Else...End statements.
- J asked: Hello- Please send me information on the above Advanced Access course. Thank you,
Advanced MS-Access
ADVANCED QUERIES:
Query multiple tables. Create Parameter Queries that do the work of many different queries. Perform multiple sorts using more than one criteria.
RELATIONSHIPS:
Create, edit, and delete relationships (links between different tables.) Learn about one-to-one, one-to-many, and many-to-many relationships.
MACROS:
Create macros that automate basic actions such as running queries and reports, finding data, etc.
FORMS:
Create forms with sub-forms. Add buttons to forms to run macros.
EXPRESSIONS:
Use expressions to perform calculations in queries, forms, and reports. Add, subtract, multiply, and divide numeric data.
SWITCHBOARD (MAIN MENU):
Create a Switchboard (or main menu) with buttons to organize your tables, macros, queries and forms into one central place.
SHARE DATA WITH WORD:
Merge names and addresses from an Access database into a Word form letter.
PREREQUISITES: Introduction to Access or comparable experience.
Query multiple tables. Create Parameter Queries that do the work of many different queries. Perform multiple sorts using more than one criteria.
RELATIONSHIPS:
Create, edit, and delete relationships (links between different tables.) Learn about one-to-one, one-to-many, and many-to-many relationships.
MACROS:
Create macros that automate basic actions such as running queries and reports, finding data, etc.
FORMS:
Create forms with sub-forms. Add buttons to forms to run macros.
EXPRESSIONS:
Use expressions to perform calculations in queries, forms, and reports. Add, subtract, multiply, and divide numeric data.
SWITCHBOARD (MAIN MENU):
Create a Switchboard (or main menu) with buttons to organize your tables, macros, queries and forms into one central place.
SHARE DATA WITH WORD:
Merge names and addresses from an Access database into a Word form letter.
PREREQUISITES: Introduction to Access or comparable experience.
About The Training Provider: Computers Etc Software Training Center
Computers Etc Software Training Center - Since 1992 we have provided hands-on computer training to over 10, 000 San Diego students from all walks of life. We offer basic and advanced training in Access, AutoCAD, Excel, FrontPage, HTML, PageMaker, PhotoShop, PowerPoint, Publisher, QuickBooks, Word, and other popular Windows-based programs.
We offer day, evening, and weekend classes. Certificates of Completion (suitable for framing)...
