As you begin this course, you should have the basic skills you need to work with a Microsoft® Office Access 2003 databases. This includes working with Access tables, relationships, queries, forms, and reports. But thus far you have been focusing on essential database user skills only. In this course you will consider how to design and create a new Access database, how to customize database components, and how to share Access data with other applications.
Upon successful completion of this course, students will be able to:
- follow the steps required to properly design a simple database.
- create a new database with related tables.
- control data entry by modifying the design of a table to streamline data entry and maintain data integrity.
- find and retrieve desired data by using filters and joins between tables and within a single table.
- create flexible queries to display specified records; allow for user-determined query criteria; and add, update, and delete data with queries.
- enhance the appearance, data entry, and data access capabilities of your forms.
- customize reports to better organize the displayed information and produce specific print layouts such as mailing labels.
- use Access data in other applications, including Microsoft Word and Excel.
Microsoft® Access 2003: Level 2 is designed for the student who wishes to learn intermediate-level operations of the Microsoft® Access program. The Level 2 course is for the individual whose job responsibilities include creating new databases, tables, and relationships, as well as working with and revising intermediate-level queries, forms, and reports. It also introduces the student to integrating Access data with other applications such as Microsoft® Word or Excel. This course is also designed for students pursuing the Microsoft Office Specialist Certification for Access 2003, and it is a prerequisite to taking more advanced courses in Access 2003.
To ensure the successful completion of Microsoft Access 2003: Level 2, we recommend completion of the following courses, or equivalent knowledge (basic familiarity with Access tables, relationships, queries, forms, and reports) from another source:
- Microsoft Access 2003: Level 1
A basic understanding of Microsoft® Excel and Microsoft® Word would also be helpful, but is not required.
Lesson 1: Planning a DatabaseTopic 1A: Design a Relational DatabaseTopic 1B: Identify Database PurposeTopic 1C: Review Existing DataTopic 1D: Determine FieldsTopic 1E: Group Fields into TablesTopic 1F: Normalize the DataTopic 1G: Designate Primary and Foreign KeysLesson 2: Building the Structure of a DatabaseTopic 2A: Create a New DatabaseTopic 2B: Create a Table Using a WizardTopic 2C: Create Tables in Design ViewTopic 2D: Create Relationships between TablesLesson 3: Controlling Data EntryTopic 3A: Restrict Data Entry with Field PropertiesTopic 3B: Create an Input MaskTopic 3C: Create a Lookup FieldLesson 4: Finding and Joining DataTopic 4A: Find Data with FiltersTopic 4B: Create Query JoinsTopic 4C: Join Unrelated TablesTopic 4D: Relate Data Within a TableLesson 5: Creating Flexible QueriesTopic 5A: Set Select Query PropertiesTopic 5B: Create Parameter QueriesTopic 5C: Create Action QueriesLesson 6: Improving Your FormsTopic 6A: Enhance the Appearance of a FormTopic 6B: Restrict Data Entry in FormsTopic 6C: Add Command ButtonsTopic 6D: Create a SubformLesson 7: Customizing Your ReportsTopic 7A: Organize Report InformationTopic 7B: Set Report Control PropertiesTopic 7C: Control Report PaginationTopic 7D: Summarize InformationTopic 7E: Add a Subreport to an Existing Report Topic 7F: Create Mailing LabelsLesson 8: Expanding the Reach of Your DataTopic 8A: Publish Access Data as a Word DocumentTopic 8B: Analyze Access Data in ExcelTopic 8C: Export Data to a Text FileTopic 8D: Merge Access Data with a Word Document