course ilt access basics unit objectives define database and database-related terminology, and plan...
TRANSCRIPT
![Page 1: Course ILT Access basics Unit objectives Define database and database-related terminology, and plan a database Start Access and open, create, view, and](https://reader033.vdocuments.us/reader033/viewer/2022042718/56649ec05503460f94bcb8af/html5/thumbnails/1.jpg)
Cou
rse
ILT
Access basics
Unit objectives Define database and database-related
terminology, and plan a database Start Access and open, create, view,
and close a database Create, save, close, and delete tables Get help
![Page 2: Course ILT Access basics Unit objectives Define database and database-related terminology, and plan a database Start Access and open, create, view, and](https://reader033.vdocuments.us/reader033/viewer/2022042718/56649ec05503460f94bcb8af/html5/thumbnails/2.jpg)
Cou
rse
ILT
Topic A
Topic A: Database basics Topic B: Getting started Topic C: Database tables Topic D: Getting help
![Page 3: Course ILT Access basics Unit objectives Define database and database-related terminology, and plan a database Start Access and open, create, view, and](https://reader033.vdocuments.us/reader033/viewer/2022042718/56649ec05503460f94bcb8af/html5/thumbnails/3.jpg)
Cou
rse
ILT
Database basics
Collection of data or information Examples:
– Phonebook– Filing cabinet
Relational databases – Tables– Entities– Properties
![Page 4: Course ILT Access basics Unit objectives Define database and database-related terminology, and plan a database Start Access and open, create, view, and](https://reader033.vdocuments.us/reader033/viewer/2022042718/56649ec05503460f94bcb8af/html5/thumbnails/4.jpg)
Cou
rse
ILT
Database terminology
Data value– Item of data
Record– Single set of related data values
Field– Column or cell in a table
Table– Collection of records
![Page 5: Course ILT Access basics Unit objectives Define database and database-related terminology, and plan a database Start Access and open, create, view, and](https://reader033.vdocuments.us/reader033/viewer/2022042718/56649ec05503460f94bcb8af/html5/thumbnails/5.jpg)
Cou
rse
ILT
Database planning considerations
Database purpose Number of tables and type of
information Fields in each table Information to extract How to enter data Reports
![Page 6: Course ILT Access basics Unit objectives Define database and database-related terminology, and plan a database Start Access and open, create, view, and](https://reader033.vdocuments.us/reader033/viewer/2022042718/56649ec05503460f94bcb8af/html5/thumbnails/6.jpg)
Cou
rse
ILT
Topic B
Topic A: Database basics Topic B: Getting started Topic C: Database tables Topic D: Getting help
![Page 7: Course ILT Access basics Unit objectives Define database and database-related terminology, and plan a database Start Access and open, create, view, and](https://reader033.vdocuments.us/reader033/viewer/2022042718/56649ec05503460f94bcb8af/html5/thumbnails/7.jpg)
Cou
rse
ILT
Getting started
Access is an RDMS Used for data:
– Storage– Organization– Retrieval
![Page 8: Course ILT Access basics Unit objectives Define database and database-related terminology, and plan a database Start Access and open, create, view, and](https://reader033.vdocuments.us/reader033/viewer/2022042718/56649ec05503460f94bcb8af/html5/thumbnails/8.jpg)
Cou
rse
ILT
Opening a database
1. Select Open an existing file and click OK.
2. Navigate to a folder and select a database.
3. Click Open.
![Page 9: Course ILT Access basics Unit objectives Define database and database-related terminology, and plan a database Start Access and open, create, view, and](https://reader033.vdocuments.us/reader033/viewer/2022042718/56649ec05503460f94bcb8af/html5/thumbnails/9.jpg)
Cou
rse
ILT
Creating and saving a database
1. Choose File, New.
2. Click OK.
3. Use the Save in list to specify a location.
4. In the File name box, type the database name.
5. Click Create.
![Page 10: Course ILT Access basics Unit objectives Define database and database-related terminology, and plan a database Start Access and open, create, view, and](https://reader033.vdocuments.us/reader033/viewer/2022042718/56649ec05503460f94bcb8af/html5/thumbnails/10.jpg)
Cou
rse
ILT
Using the Database Wizard
1. Choose File, New or click
2. Select template from Database tab.
3. Click OK.
4. Specify a folder and a name.
5. Choose Create to open the Database Wizard.
6. Follow steps and click Finish.
![Page 11: Course ILT Access basics Unit objectives Define database and database-related terminology, and plan a database Start Access and open, create, view, and](https://reader033.vdocuments.us/reader033/viewer/2022042718/56649ec05503460f94bcb8af/html5/thumbnails/11.jpg)
Cou
rse
ILT
Database views
Print Preview Datasheet View Design View Form View SQL View
![Page 12: Course ILT Access basics Unit objectives Define database and database-related terminology, and plan a database Start Access and open, create, view, and](https://reader033.vdocuments.us/reader033/viewer/2022042718/56649ec05503460f94bcb8af/html5/thumbnails/12.jpg)
Cou
rse
ILT
Adding a toolbar
1. Choose View, Toolbars
2. Select the toolbar you want to add
![Page 13: Course ILT Access basics Unit objectives Define database and database-related terminology, and plan a database Start Access and open, create, view, and](https://reader033.vdocuments.us/reader033/viewer/2022042718/56649ec05503460f94bcb8af/html5/thumbnails/13.jpg)
Cou
rse
ILT
Closing a database
Choose File, Close. Click the Close box on menu bar. Double-click database Control icon. Click database Control icon and
choose Close.
![Page 14: Course ILT Access basics Unit objectives Define database and database-related terminology, and plan a database Start Access and open, create, view, and](https://reader033.vdocuments.us/reader033/viewer/2022042718/56649ec05503460f94bcb8af/html5/thumbnails/14.jpg)
Cou
rse
ILT
Closing Access
Choose File, Exit. Double-click the Access Control menu. Click the Access Control menu icon
and choose Close. Press Alt+F4.
![Page 15: Course ILT Access basics Unit objectives Define database and database-related terminology, and plan a database Start Access and open, create, view, and](https://reader033.vdocuments.us/reader033/viewer/2022042718/56649ec05503460f94bcb8af/html5/thumbnails/15.jpg)
Cou
rse
ILT
Topic C
Topic A: Database basics Topic B: Getting started Topic C: Database tables Topic D: Getting Help
![Page 16: Course ILT Access basics Unit objectives Define database and database-related terminology, and plan a database Start Access and open, create, view, and](https://reader033.vdocuments.us/reader033/viewer/2022042718/56649ec05503460f94bcb8af/html5/thumbnails/16.jpg)
Cou
rse
ILT
Database relationship
Tables contain related data Relationships connect tables
– Common fields in two or more tables
![Page 17: Course ILT Access basics Unit objectives Define database and database-related terminology, and plan a database Start Access and open, create, view, and](https://reader033.vdocuments.us/reader033/viewer/2022042718/56649ec05503460f94bcb8af/html5/thumbnails/17.jpg)
Cou
rse
ILT
Referential integrity
Set of rules that makes relationships valid
Prevents accidental deletion or modifications
![Page 18: Course ILT Access basics Unit objectives Define database and database-related terminology, and plan a database Start Access and open, create, view, and](https://reader033.vdocuments.us/reader033/viewer/2022042718/56649ec05503460f94bcb8af/html5/thumbnails/18.jpg)
Cou
rse
ILT
The Table Wizard
![Page 19: Course ILT Access basics Unit objectives Define database and database-related terminology, and plan a database Start Access and open, create, view, and](https://reader033.vdocuments.us/reader033/viewer/2022042718/56649ec05503460f94bcb8af/html5/thumbnails/19.jpg)
Cou
rse
ILT
A table in Design view
Row selector
![Page 20: Course ILT Access basics Unit objectives Define database and database-related terminology, and plan a database Start Access and open, create, view, and](https://reader033.vdocuments.us/reader033/viewer/2022042718/56649ec05503460f94bcb8af/html5/thumbnails/20.jpg)
Cou
rse
ILT
The Save As dialog box
![Page 21: Course ILT Access basics Unit objectives Define database and database-related terminology, and plan a database Start Access and open, create, view, and](https://reader033.vdocuments.us/reader033/viewer/2022042718/56649ec05503460f94bcb8af/html5/thumbnails/21.jpg)
Cou
rse
ILT
Deleting a table
1. Close the table you want to delete.
2. In the Database window, display the table objects.
3. Select the table you want to delete, and press Delete.
![Page 22: Course ILT Access basics Unit objectives Define database and database-related terminology, and plan a database Start Access and open, create, view, and](https://reader033.vdocuments.us/reader033/viewer/2022042718/56649ec05503460f94bcb8af/html5/thumbnails/22.jpg)
Cou
rse
ILT
Topic D
Topic A: Database basics Topic B: Getting started Topic C: Database tables Topic D: Getting Help
![Page 23: Course ILT Access basics Unit objectives Define database and database-related terminology, and plan a database Start Access and open, create, view, and](https://reader033.vdocuments.us/reader033/viewer/2022042718/56649ec05503460f94bcb8af/html5/thumbnails/23.jpg)
Cou
rse
ILT
The Microsoft Access Help window
![Page 24: Course ILT Access basics Unit objectives Define database and database-related terminology, and plan a database Start Access and open, create, view, and](https://reader033.vdocuments.us/reader033/viewer/2022042718/56649ec05503460f94bcb8af/html5/thumbnails/24.jpg)
Cou
rse
ILT
The Office Assistant
Animated character that helps you interact with Help system
Type questions to find Help topics
![Page 25: Course ILT Access basics Unit objectives Define database and database-related terminology, and plan a database Start Access and open, create, view, and](https://reader033.vdocuments.us/reader033/viewer/2022042718/56649ec05503460f94bcb8af/html5/thumbnails/25.jpg)
Cou
rse
ILT
Unit summary
Learned what a database is, defined database-related terms, and learned how to plan a database
Learned how to open, create, save, view, and close databases
Created, saved, closed, and deleted tables
Used the Help window and the Office Assistant to get help