Office 2010 Class #42: Access Create Database, Import Table, Create Table, Data Validation For Table

Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/busn216.htm
This video goes with the Highline Community College Busn 216 Computer Applications Class Access 2010.
Topics Covered In Video:
1. Create a database
2. Import Two Tables
3. Create a Table
4. Select appropriate Data Type
5. Add Field Properties including Data Validation Rule and Lookup to a different table
6. Test the database

Category:

Science & Technology

Tags:

• Office
• 2010
• Access
• Mike
• Gel
• Girvin
• excelisfun
• Highline
• Community
• College
• Ron
• Davidson
• Computer
• Information
• Systems
• Busn
• 216
• Applications
• Class
• Create
• database
• Import
• Two
• Tables
• Table
• Select
• appropriate
• Data
• Type
• Add
• Field
• Properties
• including
• Validation
• Rule
• and
• Lookup
• to
• different
• table
• Test
• the

[irenezhang1234]

love the way you're teaching, great!!!

[ExcelIsFun]

I am glad that you like it!

[rotfarm]

Learned alot :P

[ExcelIsFun]

Cool!

[MrBezarloss]

Awesome, thank you so much

[ExcelIsFun]

You are welcome!

[craiglist2010]

The way you teach - AWESOME!!!

I had question related to primary key.

I want to use the current date and time as the unique identifier when filling out field records. What data type and field properties should I use?

For example, there are three entries today. So the unique identifier should record the date and time of entries. Is there a way to do this?

Thank you in advance.

[JoannasStudio]

what text book do you use for this course?

[Bangash0077]

::::::::::You Are JUst AWESOMEEEEEEE:::::::::

[84Enchantress]

I work as a business analyst and I needed to create an access database. This video is perfect for my project. Keep up the good work.