access 2013 unit a
DESCRIPTION
TRANSCRIPT
![Page 1: Access 2013 Unit A](https://reader033.vdocuments.us/reader033/viewer/2022061109/54511fdeaf7959917a8b653a/html5/thumbnails/1.jpg)
Getting Started with Access 2013
![Page 2: Access 2013 Unit A](https://reader033.vdocuments.us/reader033/viewer/2022061109/54511fdeaf7959917a8b653a/html5/thumbnails/2.jpg)
Objectives
• Understand relational databases• Explore a database• Create a database• Create a table
(continued)
Microsoft Office 2013-Illustrated 2
![Page 3: Access 2013 Unit A](https://reader033.vdocuments.us/reader033/viewer/2022061109/54511fdeaf7959917a8b653a/html5/thumbnails/3.jpg)
Objectives (continued)
• Create primary keys• Relate two tables• Enter data• Edit data
Microsoft Office 2013-Illustrated 3
![Page 4: Access 2013 Unit A](https://reader033.vdocuments.us/reader033/viewer/2022061109/54511fdeaf7959917a8b653a/html5/thumbnails/4.jpg)
Understand Relational Databases
• Lists of information are related to one another
• Access provides tools that allow sorting, grouping, analyzing and reporting data in many different ways
Microsoft Office 2013-Illustrated 4
![Page 5: Access 2013 Unit A](https://reader033.vdocuments.us/reader033/viewer/2022061109/54511fdeaf7959917a8b653a/html5/thumbnails/5.jpg)
Advantages of Access
• Minimizes duplicate data, increasing accuracy and consistency
• Data entry is faster and easier• Data can be viewed and sorted in
many ways• Information is more secure• Data can be shared and edited by
several users simultaneously
Microsoft Office 2013-Illustrated 5
![Page 6: Access 2013 Unit A](https://reader033.vdocuments.us/reader033/viewer/2022061109/54511fdeaf7959917a8b653a/html5/thumbnails/6.jpg)
Access vs. Excel
Microsoft Office 2013-Illustrated 6
![Page 7: Access 2013 Unit A](https://reader033.vdocuments.us/reader033/viewer/2022061109/54511fdeaf7959917a8b653a/html5/thumbnails/7.jpg)
Explore a Database
• Access can be opened in multiple ways
• Objects include:• Tables• Queries• Forms• Reports
Microsoft Office 2013-Illustrated 7
![Page 8: Access 2013 Unit A](https://reader033.vdocuments.us/reader033/viewer/2022061109/54511fdeaf7959917a8b653a/html5/thumbnails/8.jpg)
Access Objects
Microsoft Office 2013-Illustrated 8
![Page 9: Access 2013 Unit A](https://reader033.vdocuments.us/reader033/viewer/2022061109/54511fdeaf7959917a8b653a/html5/thumbnails/9.jpg)
Create a Database
• Start by using an Access template or by opening a blank database
• Table Design View provides the most options for defining fields
• Datasheet View is a spreadsheet-like view of the data in a table
Microsoft Office 2013-Illustrated 9
![Page 10: Access 2013 Unit A](https://reader033.vdocuments.us/reader033/viewer/2022061109/54511fdeaf7959917a8b653a/html5/thumbnails/10.jpg)
Data Types
Microsoft Office 2013-Illustrated 10
![Page 11: Access 2013 Unit A](https://reader033.vdocuments.us/reader033/viewer/2022061109/54511fdeaf7959917a8b653a/html5/thumbnails/11.jpg)
Create a Table
• Essential tasks in creating a table:• Defining the fields• Selecting data type for each field
(e.g., numbers, text, dates)• Naming the table• Determining how the table will
participate in the relational database
Microsoft Office 2013-Illustrated 11
![Page 12: Access 2013 Unit A](https://reader033.vdocuments.us/reader033/viewer/2022061109/54511fdeaf7959917a8b653a/html5/thumbnails/12.jpg)
Important Database Terminology
Microsoft Office 2013-Illustrated 12
![Page 13: Access 2013 Unit A](https://reader033.vdocuments.us/reader033/viewer/2022061109/54511fdeaf7959917a8b653a/html5/thumbnails/13.jpg)
Create Primary Keys
• Primary key field: Contains data that uniquely identifies each record; no 2 records can have the same entry in this field
• Primary key field relates one table to another in a one-to-many relationship; one record in the 1st table is related to many records in the 2nd table
Microsoft Office 2013-Illustrated 13
![Page 14: Access 2013 Unit A](https://reader033.vdocuments.us/reader033/viewer/2022061109/54511fdeaf7959917a8b653a/html5/thumbnails/14.jpg)
Designating the Primary Key Field
Microsoft Office 2013-Illustrated 14
![Page 15: Access 2013 Unit A](https://reader033.vdocuments.us/reader033/viewer/2022061109/54511fdeaf7959917a8b653a/html5/thumbnails/15.jpg)
Learning about field properties
• Properties = characteristics of a field• 2 properties required for every field:
Field Name and Data Type• You can add other properties, such
as Field Size, Format and Caption• More properties = more restrictions
= more data entry accuracy
Microsoft Office 2013-Illustrated 15
![Page 16: Access 2013 Unit A](https://reader033.vdocuments.us/reader033/viewer/2022061109/54511fdeaf7959917a8b653a/html5/thumbnails/16.jpg)
Relate Two Tables
• Tables must be linked before queries, forms, or reports can be created that utilize fields from more than one table
• Tables are linked in a one-to-many relationship
Microsoft Office 2013-Illustrated 16
![Page 17: Access 2013 Unit A](https://reader033.vdocuments.us/reader033/viewer/2022061109/54511fdeaf7959917a8b653a/html5/thumbnails/17.jpg)
Linking Tables
Microsoft Office 2013-Illustrated 17
![Page 18: Access 2013 Unit A](https://reader033.vdocuments.us/reader033/viewer/2022061109/54511fdeaf7959917a8b653a/html5/thumbnails/18.jpg)
Enter Data
• Focus: • Refers to which data would be entered
or edited if you started typing
Microsoft Office 2013-Illustrated 18
![Page 19: Access 2013 Unit A](https://reader033.vdocuments.us/reader033/viewer/2022061109/54511fdeaf7959917a8b653a/html5/thumbnails/19.jpg)
Moving the Focus to Navigate Data
Options• [Tab]• [Enter]• Navigation buttons:
Previous record
Next record
Microsoft Office 2013-Illustrated 19
![Page 20: Access 2013 Unit A](https://reader033.vdocuments.us/reader033/viewer/2022061109/54511fdeaf7959917a8b653a/html5/thumbnails/20.jpg)
Navigation mode keyboard shortcuts
Microsoft Office 2013-Illustrated 20
![Page 21: Access 2013 Unit A](https://reader033.vdocuments.us/reader033/viewer/2022061109/54511fdeaf7959917a8b653a/html5/thumbnails/21.jpg)
Edit Data
• Access automatically saves new data and changes to existing data as soon as you move to another record OR close the datasheet
• To change the contents of an existing record, navigate to the field you want to change and type the new information
Microsoft Office 2013-Illustrated 21
![Page 22: Access 2013 Unit A](https://reader033.vdocuments.us/reader033/viewer/2022061109/54511fdeaf7959917a8b653a/html5/thumbnails/22.jpg)
Edit mode keyboard shortcuts
Microsoft Office 2013-Illustrated 22
![Page 23: Access 2013 Unit A](https://reader033.vdocuments.us/reader033/viewer/2022061109/54511fdeaf7959917a8b653a/html5/thumbnails/23.jpg)
Resizing & Moving Datasheet Columns
• Click and drag column separators to manually widen or narrow columns
• Double-click the column separator to automatically adjust width to the widest entry in the field
• Click the field name and drag it left or right to move a column
Microsoft Office 2013-Illustrated 23
![Page 24: Access 2013 Unit A](https://reader033.vdocuments.us/reader033/viewer/2022061109/54511fdeaf7959917a8b653a/html5/thumbnails/24.jpg)
Summary
• Understanding relational databases• Exploring databases• Creating databases• Creating tables• Creating primary keys• Relating two tables• Entering and editing data
Microsoft Office 2013-Illustrated 24