Questions and Answers
What is the process to add the name quick start fields in columns 3 and 4 in Data sheet view?
Click to add column, click 'more fields' button in the add and delete group, scroll down and below quick start, and click 'name'.
How do you add a record with a company name of 'Front Poach Construction'?
Type in the information and then click the bottom row when done to complete the task.
What steps do you take to set the column width to best fit for the company name column?
Click the company name column, go to the home tab, in the records group click more, scroll down to field width, and click best fit.
What is required to create a new table in design view with PermitID as the primary key?
Signup and view all the answers
How do you add a second field named start date with the data/time data type?
Signup and view all the answers
What are the steps to display the relationships window and add the permits and contractors tables?
Signup and view all the answers
How can you create a one to many relationship between the contractorID field in the contractors table?
Signup and view all the answers
What steps are necessary to create a relationships report and save it?
Signup and view all the answers
How do you change the data sheets font size to 10 and the font to Verdana?
Signup and view all the answers
What steps must be taken to set the data sheet row height to 15 points?
Signup and view all the answers
How do you hide the contractor ID field?
Signup and view all the answers
What is the procedure to display the permits table in print preview?
Signup and view all the answers
How do you change the data sheet orientation to landscape and print it?
Signup and view all the answers
What steps are involved in adding a second field name CompanyName with short text data type in data sheet view?
Signup and view all the answers
Study Notes
Data Sheet View Operations
- Add quick start fields in columns 3 and 4 by clicking "more fields" in the add and delete group, then select "name."
- To add a new record, input "Front poach construction" as the company name, "Poarch" as the last name, and phone number as (805) 5557722, then click the append row to complete.
- Set column width for the company name column by selecting it, navigating to the home tab, and adjusting to best fit via field width options.
Table Design and Field Configuration
- In design view, create a new table by entering "PermitID" as the first field, assigning it the short text data type, and setting it as the primary key.
- Add a second field named "start date" with a data/time data type. Set its format to "short date" and caption to "start date."
Relationships and Reporting
- Access the relationships window via the Database Tools tab, adding the permits and contractors tables in order and closing all dialogue boxes.
- Establish a one-to-many relationship between contractorID fields in both tables, ensuring to enforce referential integrity with cascading options selected.
Reporting and Formatting
- Create and save a relationships report by clicking the relationship report option, followed by saving in the suggested format.
- Change the font size to 10 and set the font to Verdana using the text formatting group on the home tab.
Data Sheet Customization
- Adjust the data sheet row height to 15 points through the row height dialogue box.
- Hide the contractor ID field by selecting its column and using the hide fields option in the records group.
Print Settings and Layout
- Display the permits table in print preview by navigating through the file tab, print, and then print preview options.
- Change the data sheet orientation to landscape in print preview, followed by executing the print command.
Additional Field Management
- In data sheet view, add a second field named "CompanyName" with a short text data type, and change its field size to 50.
- Save the newly created table as "Contractors" by selecting the field name, altering the size and executing the save command.
Studying That Suits You
Use AI to generate personalized quizzes and flashcards to suit your learning preferences.
Description
Test your knowledge with this set of flashcards based on Chapter 1 of Access simulation training. Each card presents practical scenarios to enhance your understanding of database management techniques. Perfect for students preparing for hands-on applications in Access.