Microsoft Access-Advanced CEMS-987
|Course Name||Microsoft Access-Advanced|
|Description||The Microsoft Access-Advanced course employs a combination of instructor-led study and self-guidance to cover the basic to intermediate features of Microsoft Access.
Using a preset table of information, the instructor will walk you through using Access to produce professional customized database systems and management concepts. Macros and the advantages of the Wizards supported by Access will be covered in an in-depth manner. Microsoft Access-Advanced will also examine essential topics such as creating and modifying advanced tables, creating and modifying forms, defining queries, using advanced report features, using Access tools, using data from the Internet and other sources, and more.
Because this course will include a structured tutorial approach followed by case-oriented problem-solving exercises for learning the powerful spreadsheet software, you will gain much hands-on experience.
At the conclusion of the course not only will you have the skills required for certification on the Core Level of MS Access, you will also be able to:
• Create, maintain and edit database records, files and tables;
• Create related tables using primary key field, foreign key field and one-to-many relationships;
• Plan and create tables, queries, lists, forms and reports for efficient data display and access;
• Create files and tables with data exports, including Web pages with hyperlinks.
|Notes||This course is offered in both CE and Distance Learning formats.|
|Section||Cost||Semester||Start Date||End Date||Meeting Times||Campus|
|Legend for Days
M - Monday T - Tuesday W - Wednesday R - Thursday F - Friday S - Saturday U - Sunday
TBA - To Be Announced