From the course: Access 2019 Essential Training
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Enter data
- [Narrator] Adding new records to your database is as easy as filling in the blanks. Each record, or horizontal row, will contain information about a single entity. In our case, the guest table will collect information about the individuals that visit the Landon Hotel. Each row will contain information about a single guest. Let's start to put in a couple of records into our database. First, I'll open up our Guests table by double-clicking on it over here in the navigation pane if it's not open already. Notice that each record gets a unique ID number. If you try and type in the first GuestID number here, you'll get a message down the very bottom of the window here that says the control can't be edited, it's bound to an AutoNumber field called "GuestID". This is Access's way of telling us that it's gonna take care of this number for us. All I need to do is type in the guest's first name, last name and phone number. I'll go ahead and press the Tab key to move over to the FirstName…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.