« Back to Class Listing

Microsoft Access: Accessing the Possibilities

Description


Create and manage your own Access database! Join us as we build and edit queries, tables, forms and reports for data manipulation. Explore various database objects, relationships, and primary keys while learning how to properly and efficiently utilize various Access functionalities. Course is best suited for current Access or intermediate Excel users with knowledge in database and/or table sorting/filtering functions. Homework is assigned between the classes.

After completing this course, students will be able to:

  • Create an Acces database with tables, forms, queries and reports
  • Understand Database Objects including tables, forms, queries and reports
  • Construct tables with text, date, numerical, and other fields
  • Use input masks to aid in entering and editing data for SSN, date, and other fields
  • Build queries for data manipulation and working with various types of criteria
  • Create forms for editing, deleting, viewing, and inputting data
  • Establish primary keys for our tables and appropriate relationships
  • Edit tables and fields, queries, forms, and reports to add functionality and customization

Section:
Notice: Undefined variable: SectionNumber in /it/web/std-prod/ece.emory.edu/htdocs/catalogSectionDetail.php on line 613
Dates:
Notice: Undefined variable: StartDate2Display in /it/web/std-prod/ece.emory.edu/htdocs/catalogSectionDetail.php on line 616

Notice: Undefined variable: EndDate2Display in /it/web/std-prod/ece.emory.edu/htdocs/catalogSectionDetail.php on line 616
-
Time: 9:00 AM
Tuition:
Notice: Undefined variable: Cost in /it/web/std-prod/ece.emory.edu/htdocs/catalogSectionDetail.php on line 620
Instructor:
Notice: Undefined variable: InstructorString in /it/web/std-prod/ece.emory.edu/htdocs/catalogSectionDetail.php on line 621

Notice: Undefined variable: ButtonName in /it/web/std-prod/ece.emory.edu/htdocs/catalogSectionDetail.php on line 624

Notice: Undefined variable: ButtonName in /it/web/std-prod/ece.emory.edu/htdocs/catalogSectionDetail.php on line 626

Notice: Undefined variable: ButtonName in /it/web/std-prod/ece.emory.edu/htdocs/catalogSectionDetail.php on line 630

Notice: Undefined variable: SectionDescription in /it/web/std-prod/ece.emory.edu/htdocs/catalogSectionDetail.php on line 646

Class Schedule

Date Times Meeting Type Location
06/06/2017 9:00 AM - 4:30 PM Classroom Executive Park
06/13/2017 9:00 AM - 4:30 PM Classroom Executive Park
06/20/2017 9:00 AM - 4:30 PM Classroom Executive Park

Additional Information

Final Enrollment:
Notice: Undefined variable: FinalEnrollmentDate2Display in /it/web/std-prod/ece.emory.edu/htdocs/catalogSectionDetail.php on line 702

Clock Hours:
Notice: Undefined variable: ClockHours in /it/web/std-prod/ece.emory.edu/htdocs/catalogSectionDetail.php on line 707