Access Planning a Relational Database
Course length: 1/2-day
Microsoft’s Office Access is Microsoft’s popular database program. Microsoft Access is an information management tool that allows you to store, report, and analyze information within a relational database. If you're trying to use Excel to manage large amounts of information, then chances are Microsoft Access will be helpful to you. Access makes it easy to keep track, organize, and sort your data.
This course guides access users through the process of planning a relational database in Access. Although you can always make changes to your database when necessary, a little planning before you begin can save time later on. When you plan a database, consider how you will use the data. What kind of data are you collecting? What kind of data are you entering? How are data values related to one another? Can your data be organized into separate, smaller groups? What kinds of safeguards can you create to ensure that errors do not creep into your data? As you consider these questions, you should apply the answers as you structure your database.
In this advanced Microsoft Access course, students will be guided through planning a database and practice the initial stages of building tables and relationships.
This course is delivered using Access 2016. With the exception of the new modern look and touch screen support, there are few differences between the Office suites; therefore, users currently operating on Office 2010 and later will benefit from the material in this course.
Before attending this course, students must have completed Access Foundation (Level 1) and Access Intermediate (Level 2) or have equivalent knowledge.
- Access Foundation (Level 1) or equivalent Knowledge
- Access Intermediate (Level 2) or equivalent Knowledge
- Determine the Purpose of the Database
- Plan and Organize Tables and Fields
- Understand and Determine Relationship Types Between Tables
- Specify a Primary Keys and Foreign Keys
- Understand Junction Tables and Compound Keys
- Understand and Choose Data Types
- Build the Basic Structure of Tables in Design View
- Establish Relationships in Access
- Normalize Excel Data and Import into Access