Microsoft Access 2010

1. Microsoft Access 2010 Lesson 2 Access Lesson 2 Lesson Plans Michele Smith – North Buncombe High School, Weaverville, NC 28787

2. Learning Objectives Access Lesson 2 Lesson Plans Michele Smith – North Buncombe High School, Weaverville, NC 28787

3. Planning a Database Determine what information to store in the database Determine a logical arrangement of tables Gather all information that will be a part of the database Decide which information to store in each table Discuss the database with all users Access Lesson 2 Lesson Plans Michele Smith – North Buncombe High School, Weaverville, NC 28787

4. Sketching a database out on paper will aid in determining various pieces of information that are needed for the database. Sketching a database Access Lesson 2 Lesson Plans Michele Smith – North Buncombe High School, Weaverville, NC 28787

5. A database template(s) allows the user to accomplish various tasks! The Microsoft Access File Tab allows the user to create a New Database, blank database or a database from online templates. Database Templates Access Lesson 2 Lesson Plans Michele Smith – North Buncombe High School, Weaverville, NC 28787

6. Creating a table Access Lesson 2 Lesson Plans Michele Smith – North Buncombe High School, Weaverville, NC 28787

7. An empty table appears! Doesn’t contain any defined fields. Can use groups under the “Table Tools” tab to create a table manually. Creating a table – con’t Access Lesson 2 Lesson Plans Michele Smith – North Buncombe High School, Weaverville, NC 28787

8. Define Field Names – may be 64 characters in length Data Types Define the Fields & Data Types Access Lesson 2 Lesson Plans Michele Smith – North Buncombe High School, Weaverville, NC 28787

9. Guidelines for Field Names Access Lesson 2 Lesson Plans Michele Smith – North Buncombe High School, Weaverville, NC 28787

10. Data Types Access Lesson 2 Lesson Plans Michele Smith – North Buncombe High School, Weaverville, NC 28787

11. Accuracy Is this phone number correct? The computer doesn’t know it should be 778-645-1234 Table structure information must be accurate in order to ensure the table works properly! Access Lesson 2 Lesson Plans Michele Smith – North Buncombe High School, Weaverville, NC 28787

12. The Description Field It is important to provide a description for each field to assist future users. Access Lesson 2 Lesson Plans Michele Smith – North Buncombe High School, Weaverville, NC 28787

13. When you create a new table in Datasheet view, Access automatically creates a primary key for you and assigns it a field name of "ID" and the AutoNumber data type. The field is hidden by default in Datasheet View, but you can see the field if you switch to Design View. Primary Key – unique identifier Access Lesson 2 Lesson Plans Michele Smith – North Buncombe High School, Weaverville, NC 28787

14. Primary Key Video Access Lesson 2 Lesson Plans Michele Smith – North Buncombe High School, Weaverville, NC 28787

15. Examples of Good Primary Keys Access Lesson 2 Lesson Plans Michele Smith – North Buncombe High School, Weaverville, NC 28787